Viewing 6 posts - 1 through 6 (of 6 total)
timestamp is equal to binary(8).
December 30, 2014 at 6:27 am
#1766982
There is a "SET ROWCOUNT 1".
Try to remove it.
December 30, 2014 at 6:12 am
#1766980
GilaMonster (12/29/2014)
m.kancleris (12/29/2014) It does not return rows multiple times and does not miss any row
m.kancleris (12/29/2014)
Yes, it can.
http://technet.microsoft.com/en-us/library/ms190805%28v=sql.105%29.aspx
Missing one or more rows that were not the target of update
When you...
December 29, 2014 at 3:55 am
#1766720
m.kancleris (12/29/2014) "Don't use NOLOCK" - should have "(depends)" tag too. It depends on database design. Personally, I use it a lot to increase SELECT performance.
It depends on database design. Personally, I use it a lot to increase SELECT performance.
NOLOCK is not a performance...
December 29, 2014 at 3:42 am
#1766715
"Normalize the data as it benefits performance" - should have "(depends)" tag.
The statment is not always true, since too many inner/left joins affect CPU usage.
"Don't use NOLOCK" - should...
December 29, 2014 at 3:26 am
#1766709
"Use table variables instead of temp tables"
What is "table variables" ?
Does it mean that "DECLARE @temp TABLE()" is preferred over "CREATE TABLE #temp ()" ?
December 29, 2014 at 3:23 am
#1766708