Hyperlink Solutions: Project management, Consultation, Development @ Web
Hyperlink Solutions deals in Project management, Consultation, Designing and Development of Web Applications
Friday, April 1, 2011
Gmail Motion - A new era to communicate with your others
The mouse and keyboard were desiged before the evolution of Internet. Since then, countless technological advancements have allowed for much more efficient human computer interaction. Why then do we continue to use outdated technology? Introducing Gmail Motion -- now you can control Gmail with your body.
Labels:
email writing without keyboard mouse,
gmail,
motion
Thursday, February 3, 2011
Microsoft Office SharePoint Server(MOSS) 2007 Training for free from Microsoft
Now you can explore Microsoft Office SharePoint Server (MOSS 2007) with training from Microsoft experts by living at your desktop.
You can download a simple file which have grand tour of the latest features and changes in SharePoint, including automated workflows to track approval cycles, business dashboards showing how well you are performing on your goals, and syncing documents to Outlook.
Training topics included
- Collaboration
Finding your way around a team site Understanding permissions Customizing a team site Linking calendars to Outlook Adding Web Parts Collaborating in libraries, lists, and workspaces Using blogs and wikis to share information
- Enterprise Content Management
- Search
- Portals and personalization
- Business processes and forms
- Business intelligence
So, why are you waiting …..click here to download from Microsoft’s official site
Friday, January 28, 2011
SCOPE_IDENTITY, IDENT_CURRENT, and @@IDENTITY
SCOPE_IDENTITY, IDENT_CURRENT, and @@IDENTITY are similar functions because they return values that are inserted into identity columns.
IDENT_CURRENT is not limited by scope and session; it is limited to a specified table. IDENT_CURRENT returns the value generated for a specific table in any session and any scope. For more information, see IDENT_CURRENT (Transact-SQL).
SCOPE_IDENTITY and @@IDENTITY return the last identity values that are generated in any table in the current session. However, SCOPE_IDENTITY returns values inserted only within the current scope; @@IDENTITY is not limited to a specific scope.
For example, there are two tables, T1 and T2, and an INSERT trigger is defined on T1. When a row is inserted to T1, the trigger fires and inserts a row in T2. This scenario illustrates two scopes: the insert on T1, and the insert on T2 by the trigger.
Assuming that both T1 and T2 have identity columns, @@IDENTITY and SCOPE_IDENTITY will return different values at the end of an INSERT statement on T1. @@IDENTITY will return the last identity column value inserted across any scope in the current session. This is the value inserted in T2. SCOPE_IDENTITY() will return the IDENTITY value inserted in T1. This was the last insert that occurred in the same scope. The SCOPE_IDENTITY() function will return the null value if the function is invoked before any INSERT statements into an identity column occur in the scope.
Thursday, August 5, 2010
optimizing ASP.NET website/application
I really like this article. Got a lot of tips from it. I hope you will also like it.
http://toddanglin.ulitzer.com/node/1054992
http://toddanglin.ulitzer.com/node/1054992
Labels:
asp.net,
c#,
web application optimization,
web page,
web site
Wednesday, August 4, 2010
How to truncate transaction log file via sql statement
Sometimes you wish to truncate transaction log file via SQL statement. you don't want to create mess as you would have 24x7 (online) production database and recovery model would also be set to full.
Solution available before SQL SERVER 2005 was very simple. Just run below line and you have achieved your desired results.
But in SQL SERVER 2005 and above, previous statement generates syntax error as it is no more supported in SQL SERVER 2005 and above. Then what is solution for SQL SERVER 2005 and above. Solution is very simple, a regular BACKUP LOG to a backup device is sufficient. That truncates the log. Use below statements in order to get your desired output
I hope it will solve your problem
Solution available before SQL SERVER 2005 was very simple. Just run below line and you have achieved your desired results.
backup log dbname with truncate_only
But in SQL SERVER 2005 and above, previous statement generates syntax error as it is no more supported in SQL SERVER 2005 and above. Then what is solution for SQL SERVER 2005 and above. Solution is very simple, a regular BACKUP LOG to a backup device is sufficient. That truncates the log. Use below statements in order to get your desired output
use master
alter database dbname set recovery simple
go
dbcc shrinkdatabase(dbname )
go
alter database dbname set recovery full
go
I hope it will solve your problem
Labels:
2005,
2008,
Back UP,
Log file backup,
SQL SERVER 2000,
Transaction Log
Tuesday, August 3, 2010
Open Source Project Management Tools
Here is list of available project management tools which are currently available for your usage.
Find the Most Time Consuming Code in your SQL Server Database
I liked this article. I hope you will also get valuable information from it.
Subscribe to:
Posts (Atom)