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


20h
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 Returning value of 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 SOLVED:MySql: how do I insert a large data set into existing rows automatically?
Sep
16
reviewed Close Scaling mongoDB & Node.js
Sep
16
reviewed Close Migrating SQL Server 2008 R2 to SQL Server 2014. What are the importing replication changes?
Sep
16
reviewed Close best possible index on this situation
Sep
16
reviewed Close What Is dummy bind in mainframe?
Sep
16
reviewed Close Is schema always in 1st normal form?
Sep
16
reviewed Close Create relational database with same table items
Sep
16
reviewed Close Export sql Table to sql file on server with php