Reputation
2,126
Top tag
Next privilege 2,500 Rep.
Create tag synonyms
Badges
2 14 32
Newest
 Yearling
Impact
~169k people reached

Feb
9
comment Parameter Sniffing vs VARIABLES vs Recompile vs OPTIMIZE FOR UNKNOWN
It's been a couple years since I posted this... but I just wanted to let you know. I still use the term "imperfectly understood" all the freaking time, and I always think of Paul White when I do. Makes me chuckle every time.
Sep
25
comment Identifying if spid on SQL Server is in rollback after low disk space
Further, the total reads keeps climbing and the duration reports all the way back to the original statement (16 hours now and over 8 billion reads) wow.
Sep
25
comment Identifying if spid on SQL Server is in rollback after low disk space
Thanks for the link... that lines up with what I've seen - which reinforces why I think a rollback due to disk space and a rollback due to being killed don't report the same. I listed the results of your recommended query. It's interesting to me that it has 2 open transactions.
Sep
25
comment Identifying if spid on SQL Server is in rollback after low disk space
spid: 56, reads: 66280626, writes: 44150147, last_wait_type: PAGEIOLATCH_EX, wait_type: PAGEIOLATCH_EX, wait_time: 568, open_resultset_count: 1, open_transaction_count: 2
Sep
10
comment SQL Server Core - Installed SQL Server features
More info on what @KenWilson is suggesting: msdn.microsoft.com/en-us/library/ms143702.aspx
Jul
9
comment What is the proper way to store a full table of data outside of a database? It needs to be able to be restored as well
Good idea scripting out schema as well.
Jul
8
comment Why is this simple join taking so long?
You say it has "lot's of indexes". But, does it specifically have an index on just page_views.itemId and playpack_media.media_Id? How about page_views.started_at? I'm not a MySQL guy, so I don't know how to interpret the DESCRIBE result.
Nov
3
comment Change data capture - how to know who made the change?
Ahhhh, didn't catch that. I get what your saying now.
Nov
1
comment Change data capture - how to know who made the change?
That only gets you the svc account/owner of cdc, you might note that I tried those things and documented the results in my original question way back in Feb.
Oct
4
comment Doing a point in time restore with CDC enabled; Possible?
We've been running CDC on an async mirror for several months. It's been working great for tbe data warehouse to query the snapshot. It wasn't until we moved the mirror partner to a new datacenter that all this became an issue. Setting up mirror and then CDC, no problem. CDC and then mirroring... not so easy.
Oct
4
comment Doing a point in time restore with CDC enabled; Possible?
You know what... I just had an epiphany... do a full restore with keep_cdc on the new box. That will build cdc out, then start you multi file restore over the top of it without keep_cdc to do your point in time recovery. Ok, I'm squared away now.
Oct
4
comment Doing a point in time restore with CDC enabled; Possible?
So restoring to a different database, a new database, or a database that will be a mirroring partner is still a no? I read this same article but it left me wondering about the scenarios above in a multi file scenario.
Mar
21
comment Upgrade SQL Server 2012 Express to Evaluation Edition
Yeah, sharepoint install makes it a little more fragile for sure.
Mar
21
comment Upgrade SQL Server 2012 Express to Evaluation Edition
How many databases on your express install? How much work to backup, install fresh, and restore?
Mar
8
comment Delete a variable number of records by a chronological order
Also, I was trying to get around deprecation with the sub select but it's a nil issue now. Thanks again.
Mar
8
comment Delete a variable number of records by a chronological order
Apparantly I didn't get the memo about using parenthesis. Thank you SQL2005. Awesome.
Mar
7
comment Change Data Capture and the __$update_mask binary
Check out my NEW answer before you do. As cool as the CLR is... we found an even better way. Good luck.
Mar
6
comment TSQL DateTime DataType - fractional seconds vs milliseconds
Its turning out to be a "taking their word for it" problem on my end with the vendor proc. They are using the LSN time mapping functions related to change data capture which DO allow < instead of =< calls. So, we'll be fixing code. msdn.microsoft.com/en-us/library/bb500137.aspx
Mar
6
comment TSQL DateTime DataType - fractional seconds vs milliseconds
If the range was in our own code that would be what we would do but we are passing to other procs that only take datetime for range and are inclusive on both ends
Feb
11
comment Quick way to validate two tables against each other
Nice, thanks... good way to find differences after aggregate indicates differences exist. Thanks.