27,122 reputation
660112
bio website
location United Kingdom
age
visits member for 2 years, 10 months
seen 40 mins ago

Email: stackoverflowmartinsmith@gmail.com


Feb
26
answered Re-run a specific actual query plan
Feb
22
revised What's the difference between a temp table and table variable in SQL Server?
added 445 characters in body
Feb
21
comment View scripts ran by a specific user?
That query shows you the text of queries that happen to be in the plan cache. It is absolutely not an exhaustive list of all SQL that was executed in the past 24 hours.
Feb
21
reviewed Reject suggested edit on What's the difference between a temp table and table variable in SQL Server?
Feb
20
comment Converting char to varchar columns increases database size
14975.13 MB is not considerably greater than 17062.50 MB. The old fixed width columns stay in the row until you rebuild the table though
Feb
19
comment SPIDs stuck indefinitely in suspended state
You can add SET XACT_ABORT ON to the stored procedure to have the transaction rolled back on client timeout.
Feb
19
revised SQL Server 2014 In Memory OLTP - Garbage Collection on Transaction Rollback
added 116 characters in body
Feb
19
revised SQL Server 2014 In Memory OLTP - Garbage Collection on Transaction Rollback
added 63 characters in body
Feb
19
revised SQL Server 2014 In Memory OLTP - Garbage Collection on Transaction Rollback
added 5580 characters in body
Feb
18
answered SQL Server 2014 In Memory OLTP - Garbage Collection on Transaction Rollback
Feb
18
comment Method or Counter to track dropped connections in SQL Server?
I take it you already know about the connectivity ring buffer?
Feb
18
answered semaphore in SQL Server
Feb
18
comment semaphore in SQL Server
What is the purpose of SET Free_SBS_NO = Free_SBS_NO?
Feb
18
revised semaphore in SQL Server
added 261 characters in body
Feb
17
revised Should I nest dependent outer joins in SQL Server?
added 522 characters in body
Feb
17
comment Full Transaction Log on closed source system
Don't think that can be responsible. Try SELECT TOP (10000) * FROM sys.fn_dblog(NULL,NULL) and have a look at what is being logged. I just tried BEGIN TRAN SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; COMMIT and it doesn't write anything to the log file (no LOP_BEGIN_XACT / LOP_COMMIT_XACT pair)
Feb
16
answered Is it possible to decouple row size estimation from maximum column width?
Feb
16
comment Parameter Sniffing vs VARIABLES vs Recompile vs OPTIMIZE FOR UNKNOWN
Some additional details about the 2014 cardinality estimator and ascending key problem here.
Feb
14
comment Is adding index on bit column significantly slow down inserts?
What version of SQL Server? If 2008+ sounds like a filtered index could be what you need.
Feb
13
comment What is a bucket in database?
In what context? NTILE? hash index?