4,631 reputation
1851
bio website swasheck.wordpress.com
location The Wild, Wild West
age
visits member for 3 years
seen 2 hours ago

Most days I feel like I'm in over my head.

Some days I actually am.

But every day, I feel like MacGyver.

... 99% of the time I name my table expressions agg


Nov
19
comment Duplicate Key Entry
it's hard to troubleshoot something like this if you're not going to provide actual structures, actual(ish) data, and actual query plans. otherwise we're just left to speculate
Nov
16
awarded  Yearling
Nov
13
comment Thoughts on further optimizations
what are the queries? what are the structures? what are the query plans?
Nov
11
comment SQL Server 2012 Very Slow to Consume Memory
which edition of each did you install?
Nov
6
comment Best design to handle multiple query keys
Hey. Seriously. Leave him alone. If he wants to walk into oncoming traffic then let him. You've warned him. Now sit back and enjoy the DBA Darwin awards.
Nov
5
comment Trace Flag 1222 Not Working?
Are they actually deadlocks or are they just long lasting blocks??
Oct
27
awarded  Notable Question
Oct
10
reviewed Approve suggested edit on Parallel Plan Selection
Oct
10
comment Parallel Plan Selection
@wBob thanks. dropbox is blocked here :S
Oct
10
comment Parallel Plan Selection
run the query with option (recompile,querytraceon 9204,querytraceon 3604) and check to see which stats objects are being loaded. from there, i'd query the sys.dm_db_stats_properties() DM(F|V|O) to see what their sample rates were and then progress from there to ascertain whether or not you're getting good statistics sampling. i've got some information here
Oct
3
comment How to query from a linked server via a linked server in sql server?
shamless play for more unicorn points.
Oct
3
comment How to query from a linked server via a linked server in sql server?
stop arguing about something that can't be done. it's unclear as to why you would want to do this in the first place. i think that the fact that such a feature isn't supported should clarify why this behavior is so unclear. give it a rest. the question wording is quite clear, but the problem you're trying to solve isn't. the actual answer is, "go back the the stakeholders/management and tell them it's not possible using linked servers."
Oct
3
comment Generating an ER Diagram from SQL CREATE TABLE statements
yes. your brain. a pencil, and (if you want to get really fancy) graph paper.
Sep
30
comment Will increased network latency cause table locks in MS SQL Server?
@EvanM ... what is the specific problem that you're trying to solve?
Sep
30
awarded  Explainer
Sep
25
comment Searching for array elements nested in MongoDB Documents
@MaxVernon also ... writes are unimportant to this workload, apparently
Sep
24
awarded  Autobiographer
Sep
24
comment How can i resolve this problem of taking more time to execute then the previous?
which version of sql server are you running?
Sep
22
comment Alternatives for a LEFT OUTER JOIN query
Yikes! More like "H2-uhOH"
Sep
19
comment Backup without using SQL Server Management Studio
sqlcmd to run your backup script