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
Thanks Steve for the good question on new year.
Happy new year for everyone...
December 31, 2012 at 10:30 pm
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
Trace will show the duration in milliseconds. Correct answer should be third option. Please check it out
December 27, 2012 at 4:27 am
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
Good question. Small trick cost 1 point
December 26, 2012 at 11:20 pm
Viewing 7 posts - 1 through 7 (of 7 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy