sorte.orm (11/5/2009)

---

I asked why "select *" is such a bad thing, and as far as I can tell there has not been any single answer that was good imho. ...

the sqlist (1/21/2011)

---

Doug Bishop (1/21/2011)

---

Very good article. I do have a question. I am aware of SQL Server creating intersecting indexes when you have a query on multiple columns and...

Very good article. I do have a question. I am aware of SQL Server creating intersecting indexes when you have a query on multiple columns and each column has its...

When I saw the subject on the SSC home page, I though to myself, "Oh no, not another article with connection strings cut-and-pasted from any number of the thousands of...

Martin Bell-290511 (11/29/2010)

---

Doug Bishop (11/29/2010)

---

I am still confused as to how using scripts is better than using stored procedures and using a job with multiple steps to control the flow....

Martin Bell-290511 (11/29/2010)

---

If you are using version control then you would use the script held in version control as the definitive copy. Relying on backups to keep a history of...

Martin Bell-290511 (11/29/2010)

---

Some people use a thing called version control for those stored procedure scripts, and although there are some flashy features in Visual Studio or third party tools to...

Why, oh why, oh why, oh why do people still insist on using scripts? They do it here too and it is frustrating.

Anyone ever hear about a new object...

I also have used smart rename in SQL Refractor. However, I am a consultant and it is my own property, so not everyone on our team has it.

It is very...

Great responses. Thanks a lot.

BTW, although I mentioned I've seen the date stored as a character string and ISDATE() function used in queries, it is not a method I...

Use NULL, don't use NULL, use an indicator, don't use an inidcator. Seems like us poor developers never get a break! I know it is possible to design a database...

Leo Peysakhovich:

"In light-load transactional systems (1-2 transactions per second) you can produce a unique id based on the timing characteristics of the transaction itself. I use this method for years...

First of all, what is wrong with using LEFT(DATENAME(mm, date), 3) to get the month abbreviation. It is a WHOLE lot easier that several CASE statements with 12 WHEN/THEN pairs.

I...