Viewing 7 posts - 1 through 7 (of 7 total)
Thanks for posting. It will be easy for me to learn, if you give some example for invalid queries for the first point under important points.
June 18, 2013 at 12:37 am
#1624870
Thanks Steve for the good question on new year.
Happy new year for everyone...
December 31, 2012 at 10:30 pm
#1572645
Thanks Mr.Bhuvnesh. Now i have created an index
CREATE INDEX IX_tmpsize_tmpsizepk
ON tmpsize (tmpsizepk);
Again the count of Extent remains same as before.
December 28, 2012 at 3:20 am
#1572056
Trace will show the duration in milliseconds. Correct answer should be third option. Please check it out
December 27, 2012 at 4:27 am
#1571810
Is there any performance difference in the below given three queries.
Note: Col1 is NOT NULL column
SELECT COUNT(*) FROM Sales.SalesOrderDetail;
SELECT COUNT(Col1) FROM Sales.SalesOrderDetail;
SELECT COUNT(0) FROM Sales.SalesOrderDetail;
December 26, 2012 at 11:48 pm
#1571753
Good question. Small trick cost 1 point
December 26, 2012 at 11:20 pm
#1571747
How to deallocate the unused pages?
December 26, 2012 at 3:40 am
#1571529