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


Jan
22
reviewed Approve How to cast as type of a table column?
Jan
22
reviewed Approve io_stall question
Jan
21
revised How AlwaysOn Availability Group secondary replica catches up with primary after secondary server long downtime
edited tags
Jan
21
comment A Domain user cannot modify SQL database related c# application
you claim that it's a domain user, yet your connection string seems to imply that you're attempting to authenticate with a sql user. i'm not sure why the stackoverflow community recommended you coming here - this isnt a dba question, this is a programming question.
Jan
8
comment How can I filter an extended event by database in SQL Server 2008 R2
@JustinDearing because it doesnt exist in 2008r2
Jan
8
comment How can I filter an extended event by database in SQL Server 2008 R2
SQLSEVER ... sounds painful.
Jan
7
reviewed Approve custom product variant upload
Jan
6
comment SQL Server Index Update Deadlock
while the queries are running, you'll need to take a look at the sys.dm_tran_locks to see how many and what type of locks are actually being taken on related objects in question
Jan
2
answered At What Point Should I Split or Partition a Very Large but Simple Table
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?