27,057 reputation
660112
bio website
location United Kingdom
age
visits member for 2 years, 9 months
seen 1 hour ago

Email: stackoverflowmartinsmith@gmail.com


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?
Feb
12
comment Why do I need Transaction logs at all
2014 also has delayed durability which compromises on the D aspect somewhat.
Feb
12
revised sql_slovak_cp1250_ci_as vs Slovak_CI_AS
added 264 characters in body
Feb
12
revised sql_slovak_cp1250_ci_as vs Slovak_CI_AS
Added use of COLLATIONPROPERTY function
Feb
12
comment Timeout while using table valued parameter
@SQLFox - That was why my suggestion to use OPTION (RECOMPILE). You might find that gives an OK plan using the TVP directly without the need for an intermediate step of loading the #temp table. Though would be useful to get an idea of how long each step in the process is taking.
Feb
12
comment Timeout while using table valued parameter
Ah I assumed you were using the TVP directly in the merge. If you are looking for suggestions to speed things up then post the procedure and the execution plan.
Feb
12
comment Timeout while using table valued parameter
You're probably getting a plan optimised for a single row. Try adding OPTION (RECOMPILE)
Feb
12
revised Should I nest dependent outer joins in SQL Server?
added 179 characters in body
Feb
12
answered Should I nest dependent outer joins in SQL Server?