Small world indeed...

Is that Bryan Nike? My old cube neighbor?

What is the table definition? I was at a Brent Ozar session at PASS 2018 and they said the column order in index recommendations is based on the order they...

Here are my assignments if it helps you decide what to do with your open slots:

CRTL+1: sp_who

CRTL+2: sp_lock

CRTL+3: sp_who2

CRTL+4: sp_spaceused

CRTL+5: sp_monitor

CRTL+6: sp_tables

CRTL+7: sp_columns

CRTL+8: sp_stored_procedures

CRTL+9: sp_helptext

CRTL+0: select * from

The only thing I don't like about this at first glance is there is no check to see if the data actually changed. So if I issue the statement...

UPDATE Users

SET...

SecondAry.

Formatting of script is screwy. I don't think the XML tags should show, correct?

The script itself once I found it and ran it worked. Helpful info...

ken.trock (9/22/2011)

---

Carlo Romagnano (9/22/2011)

---

I also use this "Select TOP 50 * FROM "....

That's exactly how it works for me.

Glad to be...

SaintGr8 (9/22/2011)

---

Matt Wright (9/22/2011)

---

As others have mentioned, I have CTRL+0 set up as "SELECT * FROM", Yes, I know it's bad using SELECT * but picking 50 is arbitrary and...

As others have mentioned, I have CTRL+0 set up as "SELECT * FROM", Yes, I know it's bad using SELECT * but picking 50 is arbitrary and I usually need...

Works fine unless your tables are in different schemas. Easy fix, but could have been fixed before sharing...

Tom.Thomson (6/14/2011)

---

Matt Wright (6/14/2011)

---

COALESCE picks the first non-NULL value, so to solve the OP's question, he needs only use the date in a date format with the COALESCE as Lowell...

Tom.Thomson (5/8/2011)

---

Since...