Viewing 6 posts - 1 through 6 (of 6 total)
timestamp is equal to binary(8).
December 30, 2014 at 6:27 am
GilaMonster (12/29/2014)
m.kancleris (12/29/2014)
It does not return rows multiple times and does not miss any row
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
GilaMonster (12/29/2014)
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.
NOLOCK is not a performance...
December 29, 2014 at 3:42 am
"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
"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
Viewing 6 posts - 1 through 6 (of 6 total)