This is a follow up post from a comment on my blog.
Earlier I posted about using xp_instance_regread to get default...
2012-01-10 (first published: 2012-01-05)
2,821 reads
Getting row count for all tables in a database is straight forward. You can display row count for all tables...
2011-12-28
2,819 reads
Identifying current service pack installed for SQL Server can be difficult if you don’t know which command to use! Most...
2011-12-25
2,775 reads
The sys.dm_exec_requests is a great way to find out how long the BACKUP will take to complete. If you are...
2011-11-18
3,473 reads
You run into this error when using sys.dm_db_index_physical_stats DMV on a database which is running under SQL Server 2000 (80)...
2011-11-14
1,843 reads
Last week, i posted about moving tables to different file groups by recreating indexes. However, this method does not *work*...
2011-10-19
2,668 reads
Well, it can’t be done. You cannot move a table to a particular file in database.
What you can do is...
2011-10-13
2,087 reads
Microsoft has released Service Pack 3 for SQL Server 2008 yesterday. You can read this blog post from SQL Server...
2011-10-07
864 reads
Marking a stored procedure as system object allows to run the procedure in a user database context. There are two...
2011-10-03
2,683 reads
A dump device is simply a logical device which redirects to a specified physical device. The main advantage of using...
2011-09-26
1,311 reads
By Steve Jones
This is my last week of the year working (I guess I come back...
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
I am getting the below error when I execute a SQL command in SQL...
I am getting the below error when I execute a SQL command in SQL...
Hi everyone. I have this table and this information. (left side of the image)...