Monday, April 23, 2012

Sysprocesses CPU and CPU Percentage - utilization

›
I am not sure how many of you have faced this situation? I have faced it many many times. Somebody asks you to provide currently running ex...
Sunday, April 8, 2012

Calling Function / UDF using linked server

›
If one needs to call a UDF or System function ( ex: Serverproperty, Getdate(), etc ) on a remote server, then one cannot use the usual 4 par...
Tuesday, March 27, 2012

Inserting UniCode / Special characters in tables

›
Consider the situation where one needs to store multilingual data / Special characters into a table. For example Chinese characters or Tamil...
2 comments:
Friday, January 13, 2012

File Group Backups - Intro

›
What is File Group backup? Backing up a portion of a database, say a File Group is termed as Filegroup backup. If you are wondering what ar...
Tuesday, November 1, 2011

Log file size after backup and restore

›
Quick summary of the post: A restoration of a full database backup retains the log file size before restoration. Now for the details : Con...
Tuesday, October 4, 2011

Backup/Restore vs Detach & Attach

›
You want to move a database from one server to another. There are two options to do that. 1) Detach/Attach: To Detach the database from sour...
4 comments:
Thursday, August 25, 2011

Reading SQL Error log

›
SQL Error log can be read from SQL Server's management studio. However, Management studio is too slow and definitely not the greatest ...