29,863 reputation
874126
bio website
location United Kingdom
age
visits member for 3 years, 4 months
seen 11 hours ago

Email: stackoverflowmartinsmith@gmail.com


Dec
30
revised Can rebuilding indexes cause worse performance after the rebuild is finished?
edited title
Dec
30
comment What is the cause of this problem with CONVERT()?
The first byte is scale (0x01 = 1), The second byte is precision (0x00 = 0), The final byte is the value (0x01 = 1). Not sure what bytes three and four are for. The sign is in there but that doesn't need two bytes. Certainly flipping that bit doesn't seem to have affected anything.
Dec
29
comment Email address unique or primary key?
No. A unique constraint is treated slightly differently and has some additional metadata and additional restrictions compared to a unique index but SQL Server allows either to be used in an FK.
Dec
29
comment Email address unique or primary key?
In SQL Server you can reference a unique index as a FK.
Dec
28
comment The SQL server Log folder is expanding because of the SQL Dump files (what to do with it ?)
Why are you accumulating so many mini dump files? Is the service constantly crashing?
Dec
27
answered MySQL WHERE if NULL select another column
Dec
27
revised MySQL WHERE if NULL select another column
added 22 characters in body
Dec
26
revised Converting a Unicode value to a non-Unicode value (SQL Server)
added 8 characters in body
Dec
24
comment Reasons for avoiding large ID values
Though if you do have a legitimate expectation that you may need bigint you'll probably thank yourself for deciding that in advance rather than needing to add this in to a table with billions of rows.
Dec
18
awarded  Enlightened
Dec
18
awarded  Nice Answer
Dec
17
comment In SQL Server, can I guarantee an order without an explicit ORDER BY clause when an index seek is forced on a table with only a clustered index?
@JeroenMostert - IGNORE_DUP_KEY could do that.
Dec
17
comment In SQL Server, can I guarantee an order without an explicit ORDER BY clause when an index seek is forced on a table with only a clustered index?
Though would be easier if HashSet<T> was available in v2 of the CLR...
Dec
17
comment In SQL Server, can I guarantee an order without an explicit ORDER BY clause when an index seek is forced on a table with only a clustered index?
@JohnnyM - I'm guessing CLR
Dec
15
comment Identical tables, identical columns, identical records, but why different record sizes?
@PavelNefyodov - Probably they are including the column count offset AKA NULL bitmap offset (depends where you are counting from) in that Null_Bitmap as otherwise the fixed overhead would need to be 6.
Dec
15
comment Identical tables, identical columns, identical records, but why different record sizes?
@PavelNefyodov - The easiest way to see that would be to create a table with less than 8 columns but for which the row size would be above the 9 byte minimum. Then you no longer have that unused byte confusing things. Or see Paul Randal's example here where it happens to use a single byte. (Byte 10 in his case)
Dec
14
comment How to join a table with a table valued function?
@ShaulBehr not many competing answerers about on a Sunday!
Dec
14
answered How to join a table with a table valued function?
Dec
14
revised Identical tables, identical columns, identical records, but why different record sizes?
Made point more explicit
Dec
14
revised Is it possible to define a function within a stored procedure?
added 133 characters in body