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,916 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,996 reads

Reading tutorials is fine. Shipping something is better. If you are trying to break...

We work hard at Redgate, though with a good work-life balance. One interesting observation...

Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...

Comments posted to this topic are about the item Liability for AI Errors

Hello , I would like to run a stored procedure on a secondary replica...

Comments posted to this topic are about the item Pro SQL Server Internals

I run this command to start SQLCMD:

sqlcmd -S localhost -E -c "proceed"

At the prompt, I type this (the 1> and 2> are prompts):

1> select @@version
2> go

What happens?