257 reputation
112
bio website
location
age
visits member for 1 year, 9 months
seen 2 days ago

Nov
29
comment DBCC TRACEON (652) does not disable read ahead reads
Wow, found out 2 awesome things in a single answer, though wondering, how did you find out that there is an exceptional case with the Batch Hash table build? Did you read about that somewhere, or was it just from trial and error?
Nov
28
awarded  Citizen Patrol
Nov
28
comment Will using bigint vs mediumint have a performance impact?
Kind of OT, but you mention Why does the user know the value of the ID column? . Isnt this acceptable behaviour in some cases? Example: students in a school will know their roll numbers, and that will probably be the only value uniquely identifying them. The same can be said for a bank account number as well.
Nov
27
comment DBCC TRACEON (652) does not disable read ahead reads
@MartinSmith No, I do have Hash Match (Inner Join) and parallelism though. Have uploaded the XML execution plan, though I have no clue how to read it
Nov
27
revised DBCC TRACEON (652) does not disable read ahead reads
added 19842 characters in body
Nov
27
asked DBCC TRACEON (652) does not disable read ahead reads
Nov
26
comment Bitwise operations in TSQL
True, but like in C I can say 0x00000010 to represent 16 in hexadecimal, or 0b00000010 to represent 2 in binary, is there a similar set of notations for TSQL?
Nov
26
comment Bitwise operations in TSQL
Ohk.. I'm actually moving to a SQL role from a C background, and atleast there, bitwise operators are usually noticeably faster than integer operators. I thought it would translate here as well
Nov
26
accepted Bitwise operations in TSQL
Nov
26
awarded  Editor
Nov
26
comment Bitwise operations in TSQL
oh.. Got it. Is there a way to specify binary numbers in T-SQL?
Nov
26
revised Bitwise operations in TSQL
added 302 characters in body
Nov
26
comment Bitwise operations in TSQL
But I explicitly casted 100 to binary
Nov
26
asked Bitwise operations in TSQL
Nov
26
suggested suggested edit on I have to update all the rows of a Column in a table. Here is my query
Nov
26
asked Does the Query cost in Sql Server account for buffering?
Nov
15
awarded  Scholar
Nov
15
accepted How much work actually happens on SSMS and how much on the server itself?
Nov
12
awarded  Supporter
Nov
12
awarded  Student