Reputation
3,259
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
1 11 35
Newest
 Explainer
Impact
~116k people reached

Jun
26
comment Is it better to use an ID (int) or a Name (varchar) as PK for a table?
The name might change. That makes for a bad PK.
Jun
25
comment What exactly can SQL Server 2014 execute in batch mode?
There's a connect item for enabling batch mode for all queries: connect.microsoft.com/SQLServer/feedback/details/1422984/…
Jun
23
comment Understanding the usage of version store in tempdb
The version store numbers are very small (e.g. 45 MB). Why do you think the version store would have anything to do with this?
Jun
23
comment What happens if a client connection is killed while holding a lock?
@MartinSmith yes, I saw that link after commenting. Bad habit. So transactions could stay open for like 40 seconds (MSDN says the retransmit count is fixed to 10 on >= Vista - msdn.microsoft.com/en-us/library/windows/desktop/…;.
Jun
23
comment What happens if a client connection is killed while holding a lock?
If the other side of a TCP connection simply goes away (cable plugged) then SQL Server is not notified of that fact. Would be interesting to know what happens then (and how quickly).
Jun
22
comment Error in partition switching in Sql Server 2014 when migrating a database from Sql Server 2005
Probably a bug, report it on connect with an executable repro script.
Jun
22
accepted Why does a Columnstore index build often wait on SLEEP_TASK?
Jun
21
comment Restore Error event id 17066 and 3624 while restoring diff backup
What T-SQL did you run?
Jun
21
comment Restore Error event id 17066 and 3624 while restoring diff backup
Assertion failures are mostly bugs in SQL Server. An assert is a runtime verification of a condition the programmer did not think was possible under any circumstances.
Jun
19
answered Move a Filestream column between tables
Jun
19
comment Error in partition switching in Sql Server 2014 when migrating a database from Sql Server 2005
Is that error all? I'm not sure what it's supposed to tell us.
Jun
18
awarded  Explainer
Jun
18
answered Order of DROP_EXISTING and ONLINE for CREATE INDEX
Jun
18
answered Is there a less manual way of changing database properties for all databases in an instance?
Jun
18
comment Adding PRIMARY KEY and IDENTITY attributes to SQL Server 2008 tables
Turns out I did not read the error message :) Neither did you. "can only be specified when a column list is used" Do that. List the columns in the INSERT statement. INSERT INTO T (a, b, c, ...)
Jun
18
comment Adding PRIMARY KEY and IDENTITY attributes to SQL Server 2008 tables
That's one batch with two statements. Insert GO.
Jun
18
revised Adding PRIMARY KEY and IDENTITY attributes to SQL Server 2008 tables
added 7 characters in body
Jun
18
comment Adding PRIMARY KEY and IDENTITY attributes to SQL Server 2008 tables
That error is generated at batch compile time but the identity insert has not run yet. Split this into two batches.
Jun
18
comment Adding PRIMARY KEY and IDENTITY attributes to SQL Server 2008 tables
I'm happy they don't support other operating systems. That way they can invest the time into feature that are useful to me :)
Jun
18
comment Adding PRIMARY KEY and IDENTITY attributes to SQL Server 2008 tables
Well, you can write the rebuild script yourself. I edited the answer. There are no other options beside SWITCH and the manual table rebuild. it is beyond me why the product team does not add an ALTER COLUMN IDENTITY ON/OFF feature. Seems simple enough to implement.