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

If you're a data analyst juggling varied datasets, mastering SQL data type conversions isn't...

It’s that time of the month again, when the T-SQL Tuesday blog party takes...

I’m hosting T-SQL Tuesday this month and our topic is Managing SQL Agent Jobs....

I am researching and learning about query optimization in SQL Server to improve system...

Comments posted to this topic are about the item Execution Plan Operators

--for a given member if the startdate and endate is continous we need to...

When looking at an execution plan in SSMS, what types of operators are shown?