Very good article. I had fogotten that the CLR was available in Express. There are all kinds of things that you can do in the CLR that can't...

Bharathi-902714 (10/18/2009)

---

I tried to re-produce the scenario and ended up failing 🙁

When DbLive.mdf is renamed to DbBad.mdf, the database name in the Mgmt Studio does not change??? As a result,...

Brilliant!

One of our local congregations put in a centralized control system for heating and A/C. There were tiny sensors in the wall in each room. From the central...

I would love to see REPLACE INTO in T-SQL. If not that then support the alternative INSERT INTO syntax.

INSERT INTO MyTable SET

OrderNumber='Test12345'

, CustomerID=21785

, OrderDate='2010/09/23'

, DeliveryDate='2010/11/25'

Don't get me...

krowley (9/22/2010)

---

david_wendelken (9/22/2010)

---

Remembered who had the book.

"The Essence of SQL: A Guide to Learning the Most of SQL in the Least Amount of Time" by David Rozenshtein. ...

Yes, it's important.

I spend a bit of tie each day consulting with the rest of the development team on SQL issues. I'm not popular as I don't just answer...

"Whistle While You Work."

"The Manager Is A ..." Oops, here he comes! :w00t:

I still think of a quote from Col. Saito in the movie "The Bridge on the River Kwai[/url]" which goes: "Be Happy In Your Work".

The sarcasm and irony is not...

Good editorial and good observations.

I often find that just chatting with my collages is very helpful. It works both ways. Often more is accomplished in less...

Hey. With the Maine Coon reference in there you get some great pictures of tail.:w00t: That'll get your Labor Day week end started. 😉

Steve's advice is good at many company levels. "Get close to the users." Like a couple of others so far I'm a developer. I concentrated on SQL...

Steve Jones - Editor (8/11/2010)

---

The backup file isn't changed. What happens when you do the restore is that the mdf/ldf/ndf are created as sparse files. All reads from these files...

This might be a cool tool to save your bacon on a bad day. I see one danger that has not been pointed out. This could get abused...

Great article. If you have to parse strings in SQL then having the tally table is great.

I would have appraoched the problem with a different tool set.

SELECT '|' +...

For both the Missing and Unused index tools it is good to remember that these are recommendations. The best tool is properly tuned squishware (that part of the system...