Reputation
673
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
7 18
Impact
~88k people reached

Dec
30
awarded  Popular Question
Dec
18
revised Are SQL Server in-place upgrades as ill advised as they used to be?
Mention server roles and provide example script
Dec
18
answered Are SQL Server in-place upgrades as ill advised as they used to be?
Nov
24
comment Deterministic function for getting today's date
Have you considered just pushing the view instead of replicating a table? I suppose this assumes the servers are in the same timezone which could be overcome in the view.
Nov
14
revised Why does ORDER BY not belong in a View?
added 8 characters in body
Nov
14
revised Why does ORDER BY not belong in a View?
Improve example/comments and suggestion.
Nov
14
answered Best practice between using LEFT JOIN or NOT EXISTS
Nov
11
awarded  Notable Question
Nov
6
comment How to log error details when using using try/catch for dynamic SQL backup commands
This works great for some common errors but there are some errors that apparently only get thrown directly to the client. The sp_readerrorlog log will include a message saying refer to "application log", where I assume by "application" they mean the external process that is issuing commands. SO Link
Oct
24
comment First log backup after FULL taking lots of space
I haven't tried it but this query from SqlServerCentral, "DBCC SQLPERF (LOGSPACE)" , may tell you the approximate size of the transactions ready to be written to the log. It could be run 1/minute or between critical steps.
Sep
28
accepted Why does Recursive CTE estimate just 1 row?
Sep
24
revised Extracting a field from RESTORE HEADERONLY in sql server
improve formatting
Sep
24
suggested approved edit on Extracting a field from RESTORE HEADERONLY in sql server
Sep
18
suggested rejected edit on How to log error details when using using try/catch for dynamic SQL backup commands
Sep
8
accepted Is it possible to get seek based parallel plan for distinct/group by?
Aug
21
awarded  Yearling
Aug
3
comment Handling concurrent access to a key table without deadlocks in SQL Server
Is IDName unique? Then reccommend "create unique nonclustered index". However if you need null values then the index would also need to be filtered.
Aug
3
awarded  Constituent
Aug
3
awarded  Caucus
Aug
1
answered Effiiency of multiple OR predicates versus a single range