27,037 reputation
660112
bio website
location United Kingdom
age
visits member for 2 years, 9 months
seen 13 hours ago

Email: stackoverflowmartinsmith@gmail.com


Jun
15
revised Rejoining range seek on nullable composite index?
added 589 characters in body
Jun
15
reviewed Close Reducing log files?
Jun
15
awarded  Custodian
Jun
15
reviewed Reopen “Replicate” Table structures with sp_addscriptexec
Jun
15
comment Rejoining range seek on nullable composite index?
@ypercube - The plans are simpler as it chops off the seek and corresponding merge union that will never return anything for that case. Still 1020 reads though. Maybe that's as good as it will get and there is no SQL that will return the optimum plan.
Jun
15
comment Rejoining range seek on nullable composite index?
@ypercube - Looks worse as 1523 reads and it no longer leverages the index order and has an explicit sort. Frustrating because all I want it to do is seek into (NULL, 1000 ) follow the index along and chuck out the next 1,000 rows in index order but doesn't seem easy!
Jun
15
comment Rejoining range seek on nullable composite index?
@ypercube - SQL Server just gives an ordered scan for that unfortunately so re-reads all the rows already processed by the application (logical reads 2015). It doesn't seek into to the first key of (NULL, 1000 )
Jun
15
comment Rejoining range seek on nullable composite index?
SQL Fiddle
Jun
15
comment Rejoining range seek on nullable composite index?
Yes Oracle is different I believe.
Jun
14
asked Rejoining range seek on nullable composite index?
Jun
12
awarded  Nice Answer
Jun
12
comment SQL Server large transaction log for simple recovery model? help!
Have you tried shrinking that file specifically with DBCC SHRINKFILE? Also why do you care about the size of the log file anyway if you have plenty of disc space? If it has to regrow to that size shrinking will just waste resources as the growth involves zeroing out previous disc contents.
Jun
12
comment SQL Server large transaction log for simple recovery model? help!
Ok. I've retracted my close vote then.
Jun
12
comment SQL Server large transaction log for simple recovery model? help!
It's described in the possible duplicate. Did you look at it?
Jun
12
comment SQL Server large transaction log for simple recovery model? help!
What is log_reuse_wait_desc?
Jun
12
comment SQL Server large transaction log for simple recovery model? help!
SQL Server 2014 in memory OLTP has schema only non logged tables BTW.
Jun
12
comment SQL Server large transaction log for simple recovery model? help!
possible duplicate of Why Does the Transaction Log Keep Growing or Run Out of Space?
Jun
12
answered NULL value returned when concatenating a string in SQL while loop!
Jun
12
comment SQL Server large transaction log for simple recovery model? help!
Do you have a long running open transaction?
Jun
12
revised What's the difference between a temp table and table variable in SQL Server?
added 116 characters in body