parulprabu (9/30/2013)

---

Sean Pearce (9/30/2013)

---

kapil_kk (9/30/2013)

---

SELECT 'UPDATE table_1 T

SET labeltext ='+ T.labeltext

'WHERE...

There is a lot of unknown information here. If done correctly the logical drives sit on different raid sets or LUNs. But we can't say for sure. In addition there...

I have to agree with Sean on this. It does not make any sense to hard-code database connections. It presents so much work for the developer and produces a...

Ed Wagner (9/27/2013)

---

Sean Lange (9/27/2013)

---

Jon Higgins (9/27/2013)

---

Meanwhile, walk up to that developer and punch him straight between the eyes. It is unacceptable to hard code a connection string into an...

sestell1 (9/27/2013)

---

You should definitely read that article, it is very good but the solution presented there only works for integers.

I think something like this will get you close:

WHEN ISNUMERIC(Value) =...

I'd probably do something silly like this:

declare @somedata table (ID int primary key identity (1,1)

...

Can you provide the table definition for PORT?

I ran into an issue like this where by there were nulls in the source data. Once I excluded them I had no...

Luis Cazares (9/26/2013)

---

Be careful on using table variables, they might reduce performance on your query depending on the number of rows. You should test what's better for your performance (temp...

When I provision for a new SQL Server box here is what I ask for:

1) System disk

2) Data disk

3) Log disk

4) TempDB Data disk

5) TempDB Log disk

Most of systems, these...

+1

I find this question somewhat puzzling. All of my backups go to a designated backups folder. I have never created a backup in an unwanted location. So...

I agree here with the CTE or CROSS APPLY. Otherwise you would have to but your select in your WHERE clause which is in my opinion is bad coding....

This is something I do all the time. There are several methods you can choose from. The first is a real simple method that you discovered. The...

Hold the phone here.... you are placing a stereotype on DBAs which I don't really agree with.... I have played the role as DBA for a very long time along...

Interesting script. I ran it against one of my legacy databases to which I manage but did not design. It was quite clear the designer didn't understand the...