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


Oct
10
reviewed Approve suggested edit on Terrible Bad Query Plan
Oct
10
comment Terrible Bad Query Plan
@wBob thanks. dropbox is blocked here :S
Oct
10
comment Terrible Bad Query Plan
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."
Oct
3
comment Generating an ER Diagram from SQL CREATE TABLE statements
yes. your brain. a pencil, and (if you want to get really fancy) graph paper.
Sep
30
comment Will increased network latency cause table locks in MS SQL Server?
@EvanM ... what is the specific problem that you're trying to solve?
Sep
30
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 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?