Monday, May 27, 2013

How to Size the SQL Server Memory & Why is it important?

›
The following blog post has 2 objectives.  1) How to size the memory correctly ( or atleast being close to correctly )  2) Why is it impo...
7 comments:
Thursday, May 16, 2013

Xp_readerrorlog in SQL Server 2012

›
I have always been a big fan of Xp_readerrorlog. The simple reason is that it much faster to read errorlog using the script compared t...
3 comments:
Friday, March 1, 2013

When was the last successful backup?

›
What is the fastest and perhaps easiest way to find the last successful database backup? Just right click on the Database on pick properti...
Sunday, May 20, 2012

SQL Server Memory Usage - Task Manager

›
Another question I have answered 100s of times to Non SQL folks. "SQLServr.Exe is consuming 80% of memory. Can you please help to r...
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: