yes.

eccentricDBA (5/17/2012)

---

Curious of why you gave the following order? My personal preference is SQL logins but...wait for it..It depends. I personally like SQL Logins when I have control....

The error is fairly self explanatory. The file did not exist or the path was unavailable, or perhaps the file was corrupted at the time for whatever reason.

GSquared (5/17/2012)

---

I know a DBA you can get really inexpensively.

It's mainly because he's never...

I like to hire the ones I can pay the least amount of money. 😛

"SET @sql = 'KILL @@SPID'

EXEC (@SQL)"

Killing ones self is a depressing solution.

RBarryYoung (5/16/2012)

---

I'm still trying to figure out what it means to "Organically Cancel" a resultset. Does that mean that it comes with a sprig of broccoli or something? ...

Lynn Pettis (5/16/2012)

---

Before you can do Agile or Scrum type development, there still needs to be a period of time up front to develop the system requirements. There needs...

using "if exists()" before the actual query is the only way I know of to do what you want.

Lynn Pettis (5/15/2012)

---

Eugene Elutin (5/15/2012)

---

...

Now, for whatever reason, Microsoft by default makes it the clustered index. This is 99% of the time wrong.

The clustered index should be on a...

jfogel (5/14/2012)

---

I also know some people with 20+ years of coding experience and to me their biggest problem is that they have had 20 jobs over those years. I...

Jeff Moden (5/12/2012)

---

Good article, Steve. I believe that you've hit the nail on the head. So many managers think that Hours worked = Hours wisely spent = Good...

You might consider moving a snapshot of the subset of data over to a separate database where you can set up any kind of structure you want. You would only...

djackson 22568 (5/10/2012)

---

Management - In my experience, this is what usually causes most of the issues. Team building does not work when you create an atmosphere that makes it...

Question Guy (5/10/2012)

---

At my former company we had "Beer Friday" starting at 4PM,(ok 3PM unofficially) every week. It was fun. And typically we stayed a little bit longer...