James' SQL Footprint

if you run BACKUP DATABASE T-SQL, there is a parameter STATS which reports the percentage complete, However when you run the...

2012-03-31

1,901 reads

Select : Lock or No Lock?

Here is a post I happen to find today: why select command is not blocked by update command?

http://blog.csdn.net/zjcxc/article/details/4383113
First, I...

2012-03-30

2,979 reads

I thought it would be good to put my thoughts down on how to...

You want the short answer? Well, the only antidote to knowledge stagnation is probably...

It always starts the same way. You open your laptop on a Monday morning,...

Sorry, but you do not have permission to view this content.

Comments posted to this topic are about the item Database File Growth Report Script

I maintain an application written years ago, where the database is on a Windows...

Can I run this code:

DECLARE ANewTable CURSOR FOR 
SELECT * FROM ANewTable