Nope. But I am in Austin for SQL Saturday here.

Just wanted to say thanks on this again, Grant. Work has given me the green light for SQLBits; it's a bit (no pun intended) last minute though so all...

Also, salaries are very regional. A DBA in Tulsa probably isn't paid what a DBA in NYC is paid (honestly, they should be, but they aren't). This isn't specific to...

Exactly that, or, have a second job scheduled two hours after the one that starts it.

So catching up and getting back into the forums here...

Saw the talk about the SQL conferences and this may be the first year I go to PASS Summit!  When...

Always a fan of "whatever works". Glad you found a solution.

Full text indexes are an option. Although, in all honesty, I hate 'em. Hard to maintain and frequently don't actually speed things up much, if at all. Extra storage. Ugh....

Trying to get different perspectives! May be I am looking at the things might not be the right. Getting awareness from wise people will definitely make me think with...

The optimizers suggesting for missing indexes are, at...

Should be relatively straightforward. A check constraint will have to perform some action to validate the data, let's keep it simple and say all values have to be > 0....

So, performance comes down to identical behaviors. A similar query running on a similar structure with similar data sets may, yeah, perform wildly different. This is because every little thing...

Oh yeah, take a look at the execution plan. You can just get an estimated plan, you don't have to execute the query. That will show you all the activity...

Almost impossible to tell you exactly what is wrong without more data. It could be as simple as you didn't commit your transaction. It could be blocking. Assuming you have...

It's simple. COALESCE as part of filtering criteria, WHERE/ON/HAVING, means that statistics and indexes can't be used becuase you're making a calculation. That's going to slow things down, leading to...

It does. It's just not obvious when looking at the XML. You can open the blocked process report as a report which will resolve the values for you. However, to...