You can use sp_msforeachdb to execute the shrink database command against every database very easily if you are certain that is really what you want to do. There is...

Excellent article. Thank you.

Excellent article. Thank you.

Also, remember you can get similar information in SQL Server 2005 for a specific query by looking at the xml plan and its missing index section....

Ninja's_RGR'us (9/17/2008)

---

Are you calling both sps from SSMS?

I know that results to grid will screw up the formating, but since you say you are printing that is most likely not...

Steve Jones - Editor (9/11/2008)

---

Mark,

The problem is that this guy might have been "successful" as a DBA at his last job. Perhaps another group ran backups using Tivoli or something...

majorbloodnock (9/11/2008)

---

Dunno. I do all my SQL formatting in nylon, with lace undies and diamante jewellery. I prefer dinner suit,...

Leo (9/10/2008)

---

First of all thaks to Lynn and Tim,

Tim,

what do you mean 'locked table and not write to it, you can consider adding 'with (nolock)' to the reading transaction...

The charindex function should do what you want and it can be placed inside of the substring function so its results get passed directly to the substring function.

I completely concur with Lynn, but to add to it, if the transaction being held up only needs to read from the locked table and not write to it, you...

Gleb, listings is exactly what I wanted. Thank you.

Gail, I agree, a SQL consultant in latex is a scary thought, but SQL code in LaTeX (with listings) can look...

lage_bergstrom (9/9/2008)

---

Thank you for an interesting article!

The company I work for is still using SQL Server 2000. I tried the example and it seem like the NOEXPAND just gave...

Adrian, that is a great idea on the nomenclature. Thanks for pointing it out.

Jack, to add just a little to what Gail said, it is similar in many ways to HTML except designed specifically for math and science publications.

Gail, Thanks. I have...

Jeff, I must be missing something. Why would you want to do the sort in the gui instead of letting the server do that?

I do understand why you...

I have to agree with Chad in saying that the only way to gauruntee that the results are returned in a specified order is to use an order by clause,...