4,575 reputation
1651
bio website swasheck.wordpress.com
location The Wild, Wild West
age
visits member for 2 years, 10 months
seen 14 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


16h
comment Will increased network latency cause table locks in MS SQL Server?
@EvanM ... what is the specific problem that you're trying to solve?
17h
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 High Logical Reads for Worktable
@AaronBertrand yep. thanks.
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
Sep
18
comment Relational Model vs. Database Products
@ypercube someone set up us the bomb
Sep
17
comment Keeping rows ordered by counter value
@MaxVernon but ... i thought JOINs were slow!
Sep
17
comment Use serial ID for multiple columns and return it from INSERT
good observation, erwin. thanks!
Sep
17
comment How can I sync databases to a secondary server for read-only usage?
i'm confused. do you want high availability (so, high availability tag)? do you want disaster recovery (so, log shipping tag)? or do you just want a copy of the data that you can use to serve data to SSRS so that you're not interfering with production? if what your question states is taken at face value (option 3), then set up replication.
Sep
16
comment Performance/Health checking queries for a user with Read permissions
+1 nice job, @kin. you got the whoisactive link before me :)
Sep
16
answered Performance/Health checking queries for a user with Read permissions
Sep
16
reviewed Leave Closed Is database record access sequential after retrieving the indexed page from disk?
Sep
16
reviewed Leave Closed Proposal: MySQL blob handling revision
Sep
16
reviewed No Action Needed Boolean fields in Oracle, best practice?
Sep
16
reviewed Leave Open Getting the value from a column during a trigger
Sep
16
reviewed Close best possible index on this situation
Sep
16
reviewed Close What Is dummy bind in mainframe?