I didn't even know STR() existed... when I need to make strings out of numbers I always use cast and convert.

Thanks a lot Jeff... as I said before, I just...

I'm the only DBA type person for my company.

That means I support 3 internal SQL Servers with a total of 60 databases running on them that keep the company running,...

As always when I read an article by Jeff two things happen.

1. I find a very useful tip that I'm sure I'll need within 1 month of reading the article

2....

Triggers can do this... could even call sp_send_dbmail to alert you to the change if you wanted it to.

Yup I'm one of the 2% who got it wrong.

Because I define SSMS as a GUI. It has menus and icons. Granted I open a big text window...

Iulian -207023 (11/18/2010)

---

Great point. Amazing, the compiler see two creations of the #tmpID table and stops the procedure from compiling.

Do you have at hand some best practices for using...

SanDroid (11/17/2010)

---

Disapointing and Lame trick question.

The question asked which row had the "largest defined row size", not "the largest storage size".

Compression can allow more rows to be stored on a...

mister.magoo (11/16/2010)

---

Thanks to those of you who appreciate this question.

To those who think it had unnecessary "tricks" in it, I did try several variants of this question and they all...

Full Text Search only does wildcard searches where the beginning of the word is specified.

i.e.

If you do a wildcard search for RED you will get hits on

RED

REDmond

REDding

RED-orange

You won't get hits...

I'd expect a user report would be...

OCTom (11/5/2010)

---

Hugo Kornelis (11/5/2010)

---

Probably because of February 29, 1900.

There is no such date. The full rule for leap years is not...

Bob Cullen-434885 (11/5/2010)

---

The question asks us to 'predict' the outcome, which implies you do it by inspection. But how is anyone supposed to know that 40358 is a relevant date...

naveendas (10/22/2010)

---

set the key as user_count, PK (in that order). Then if you sort by key, it should sort by user_count and then by key. So user_count=2 will show up...

stevefromOZ (10/22/2010)

---

Do you want to be able to modify the sort, or have it come out specifically in (say) ASC order? If it's the latter, then why not set...

I set the key to be a composite of the

ai_agn_seq (PK) and the user_count.

I set the order by user_count.

Excel still...