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,896 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

How U.S.-India Tariff Disputes Could Ripple Through the Indian IT Sector Although the newly...

Why Microsoft Azure Certifications Are Beneficial for Your Career How to Schedule...

I had someone ask me about using triggers to detect changes in their tables....

Comments posted to this topic are about the item What is a Failed Deployment?

Comments posted to this topic are about the item Generating a Series I

Comments posted to this topic are about the item Dimensional Modeling Case Study Part...

What is returned by this code in SQL Server 2022?

SELECT value
FROM GENERATE_SERIES(4, 1);