4,267 reputation
1043
bio website swasheck.wordpress.com
location The Wild, Wild West
age
visits member for 2 years, 5 months
seen 6 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


6h
comment SQL Profiler - Insert values?
What you're seeing is a parameterized INSERT.
Apr
11
comment SQL Server CPU spikes - possibly non-query related - suggested indicators
we're going to need a lot more information than this. please see if you can capture activity (specific queries) on the server during these CPU spikes. sqlnexus is a tool you can use, or you can search for "glenn berry diagnostic dmv queries" and snag some useful scripts there
Apr
10
comment Can not start SQL Server, model db in RESTORING state
the bigger question you should ask is what the vendor did that was messing with model and tempdb.
Apr
3
comment Improve performance of COUNT/GROUP-BY in large PostgresSQL table?
I just saw that there's a third party columnstore addon for Postgres. Also, I just wanted to post from the new ios app
Apr
3
comment Order of update column?
uhhhhhhhhhhhhhhhhhhhhhh ... you'd be the person most likely to be able to answer that
Apr
2
comment Multiple Transaction Log files and performance impact
writes are tricky to consistently measure with "eyeball analytics" on a SAN because most of them are cached writes.
Mar
31
awarded  Good Question
Mar
30
reviewed Reject suggested edit on Upstart script in ubuntu for mongodb
Mar
27
comment Concurrent queries hang - update using with nolock
@AaronBertrand I found the answer: digital-polyphony.com/turbo-boost.jpg
Mar
26
comment How to aggregate pairs of id values into groups
whoosh!!!!!!!
Mar
24
comment Postgresql subquery speed much slower than individual queries
please post the query plan (EXPLAIN ANALYZE)
Mar
23
comment How to distribute a given database between multiple DBMS on a LAN?
Look into Denodo. I agree with @Craig, though. I don't think I'd ever intentionally design an architecture like this.
Mar
20
comment Accidental Turn On of Replication
That's right. It's been a while since I've worked with replication. Thanks for the information.
Mar
19
comment Accidental Turn On of Replication
Perhaps maybe ... maybe ... they'd be the owner of the replication jobs too?
Mar
19
comment How to audit all activity for a Windows Group in SQL Server 2012/2014?
"Which one should I choose?" is a subjective question and you will get a range of opinions. Could you please rephrase your question to state a specific problem ("certain people keep getting escalated permissions and are damaging our data integrity" or something like that) and then ask a targeted question ("i suspect my DBAs are always escalating permissions for FWBs [probably not necessary but ...]. how do i go about determining why/how/when/if these changes are made?").
Mar
19
comment Accidental Turn On of Replication
Which version of SQL Server is this?
Mar
19
comment SQL Server Memory for Backup Buffer
... even in 2008 (if I'm reading this correctly) the buffers for backup operations did not come from the buffer pool.
Mar
7
comment Disk Latency vs Throughput
Latency on disk or latency between OS and storage?
Mar
7
comment Disk Latency vs Throughput
In theory there is no difference between theory and practice. In practice there is.
Mar
7
reviewed Approve suggested edit on send custom email when SQL Server job fails