4,640 reputation
1953
bio website swasheck.wordpress.com
location The Wild, Wild West
age
visits member for 3 years, 1 month
seen 3 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


Dec
17
awarded  Enlightened
Dec
17
awarded  Nice Answer
Dec
10
awarded  Popular Question
Dec
5
comment Reuse a complex non-deterministic expression in SELECT and WHERE clauses
unfortunately we're probably going to need to see this non-deterministic expression
Dec
3
comment What significance does an index_id < 256000 have?
"What does this accomplish?" Technically the answer would be "nothing." Circumstantially, it's a way that people have correlated filtering out XML indexes.
Dec
3
comment What significance does an index_id < 256000 have?
i have it right here. which page? also - i respect the heck out of those authors but i'm not sure that counts as "official documentation."
Dec
3
comment What significance does an index_id < 256000 have?
do you have official documentation for this claim?
Dec
1
comment Replication Madness
@Cameron - this is quite the word problem. what are you attempting to achieve? HA? DR? Both? If it's truly "life-or-death" then you, as the consultant/contractor need to influence them to at least invest in disk space for full recovery model/log backups. That gives you log shipping as an option. Just going along with this plan without raising documented concerns does neither the client nor your firm any favors at all, in any capacity.
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 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."