I thought this was a very interesting article and certainly presented a new way to handle delimited strings without looping. For new applications I would just have the application...

Paul,

Thanks for the replies. When I ran CheckDB and CheckTable there were no other processes running on the SQL server. I was working on the SQL Server because...

WILLIAM MITCHELL (11/30/2007)

---

I've tried Ubuntu Linux 6.06 and it's waaaay more stable than the Win 98 SE that it replaced on my old Sony laptop. It recognized all the hardware...

Grant Fritchey (11/30/2007)

---

Having sent a few e-bombs in my time, I try hard to look at what I've written before I hit send if emotion is an attachment. Usually, if...

cburleigh (11/29/2007)

---

SQL Server is a machine...

I'm going to simply answer the question posed in the title.

Foreign Keys are a good practice. At the very least there is always at least 2 applications that can...

If you don't have a valid log file you can use sp_attach_single_file_db which will create an new log file. Use BOL for syntax. I had to use this...

Good article and it definitely provides a way to find out if you are doing what needs to be done.

As far as #10, how do you deal with...

Thanks for the reply Paul. I didn't think there was anything I could do to a detached database file.

Yes I am having a problem attaching the database. I...

With respect to the features, service broker can be extremely helpful, but only if you intend to use it. Doing SOA via SQL Server (HTTP endpoints) saves you a server...

COALESCE is a function that takes 2 to n arguments and returns the first non-null value. So in Ramesh's example the SUM(OrderLine.QtyOrdered) for any products that have no orders...

Ramesh's query should give you the result that you want.

Brandie is correct in discussing table order. If you just change the Inner Joins to Left Outer Joins in your...

He does state...

In the past I have used temp tables or table variables in this situation reasoning that it is usually going to be better to hit the big table once. ...

Stewart Joslyn (11/16/2007)

---

I think we're still technology fixated - you don't need a pen drive or any other IT hardware to steal a few social security numbers or bank details...