gaffar786 (12/18/2010)

---

Trace ID '3' was stopped because of an error. Cause: Stopping the trace because the current trace file is full and the rollover option is not specified.. Restart the...

Steve Jones - SSC Editor (12/17/2010)

---

Jack Corbett (12/17/2010)

---

I tried the music and eyes closed, but couldn't manage it. I tried David's suggestion on thinking on the things mentioned in...

I'm not sure the MRI is really necessary in my case. It was ordered because some liver enzymes were off in my blood tests, but in a more recent...

I've used VirtualPC, but its lack of 64 bit guest support is annoying. I know several others who use VritualBox and if I had a machine on which to...

Seems to be working correctly. I did have to use r3 instead of r2 for later grouping because I found instances where r2 was not grouping correctly.

GSquared (12/16/2010)

---

I like the Red Gate intellisense more than the SSMS default, but I have to admit, they both get in the way as often as they help, till you...

GSquared (12/15/2010)

---

Kit G (12/15/2010)

---

Lynn Pettis (12/15/2010)

---

I'm not in a position to test, but don't you get the same issue when using decimal(19,4) as you do when usinf money?

Now I may...

CirquedeSQLeil (12/15/2010)

---

Brandie Tarvin (12/15/2010)

---

CirquedeSQLeil (12/15/2010)

---

Agreed on the interesting advertisement. Is the...

CirquedeSQLeil (12/14/2010)

---

GSquared (12/14/2010)

---

Stefan Krzywicki (12/14/2010)

---

WayneS (12/14/2010)

---

Stefan Krzywicki (12/14/2010)

---

Wow. I was having problems with an older query taking too long, so I made what I thought was a little switch to...

Okay, here's what I've got now:

USE [tempdb]

GO

CREATE TABLE [pershist]

(

[personno] [varchar](6) NOT NULL,

[fromdate] [datetime] NOT NULL,

...

Craig,

Looks like it might work. I'm still trying to understand how/why it works but it does look good.

Here's what's needed for the rest of the columns:

acctstatcd needs to be...

Nice post, especially since it works from 200 up.

With 2005 and later you should look into Event Notifications or with 2008 and later Extended Events. These can...

Steve Jones - SSC Editor (12/10/2010)

---

Jack Corbett (12/9/2010)

---

Jeff Moden (12/9/2010)

---

Travel money, hotel money, earn money... I'd love to make the trip from...

Jeff Moden (12/9/2010)

---

Travel money, hotel money, earn money... I'd love to make the trip from Detroit to Florida this time of year...

Grant Fritchey (12/9/2010)

---

Steve Jones - SSC Editor (12/9/2010)

---

Grant Fritchey (12/9/2010)

---

Jack Corbett (12/8/2010)

---

Hey guys, I don't see any threadizens on the list of submissions to SQLRally yet! What's taking y'all...