Good question, thank you for writing it!

Thanks for an easy Order of Operations question.

Or for that matter with a properly normalized system.

Many or few joins is dependant...

Nice question... made me think for a moment... staring at the code going... Something isn't as easy as it sounds... 🙂

Got it right... yay me!

Erin Stellato (2/4/2013)

---

Hi Chris-

Thanks for reading and for your comment! I don't think you need to change your strategy to get more of a benefit. I'd be interested...

There is an option 4 on wait states (at least)

1. Capture the wait stats every 15 minutes

2. Store the current captured value into a staging table

3. Calculate the differences in...

Good Question... thank you

Dineshbabu (1/31/2013)

---

Hi tom,

I don't think there will be a real need of chaining computed columns. Whatever experssion may be, we can...

SQL doesn't exist to format data. Have the User Interface format the data.

I.e. set the number format in Report Builder/SSRS or in Excel or whatever the tool is.

If the...

I'll second that! I'd prefer if there was a way to compress off page data such as varchar(max), which...

Thanks for the question. Glad I was right on it.

Also thanks to demonfox and others for the further details into the refresher on the bit data type

You know, google and 5 minutes of download time and you can get it... MS puts it up on Codeplex for you

Of course it technically errors out because of the period at the end of Season in the Select COUNT(Season) query

Thanks for the question.

After all of the questions on COALESCE and ISNULL I was glad to feel confident on answering this one 🙂

Yay! I guessed correctly in the guessing game for a change!

My first thought was.... something like Sharepoint which is basically a relational model with xml.

Since both wasn't an option,...