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,822 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,823 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,846 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,670 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,089 reads
Microsoft has released Service Pack 3 for SQL Server 2008 yesterday. You can read this blog post from SQL Server...
2011-10-07
865 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,688 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,314 reads
By Kevin3NF
The Two-Layer Model Explained “We added them to the database, but they still can’t...
By Steve Jones
Someone sent me this code. WITH p AS ( SELECT ID, ROW_NUMBER() OVER (ORDER...
Wondering which database to tackle first? I’ve got the lowdown on the top free...
Comments posted to this topic are about the item A Basic Data API Builder...
Comments posted to this topic are about the item Sentiment Analysis & Key Phrase...
Hi we often use non expiring windows and sql accounts to actually run (credential...
What parameters are required for the dab add command in the Data API Builder?
See possible answers