I've got a 6 node cluster with 4 instances on it. Each instance has over 1000 databases attached. Between 4000 and 10000 users connect to each instance daily...

Right before the end in the cursor loop you need to add another one of these.

fetch next from email_cursor into @pm, @email

while (@@fetch_status = 0)

begin

PRINT @pm...

That's awesome...

Sadly I screwed up... been working in our external data centers too long and posted a SQL 2000 question in a SQL 2005 forum (our data centers for our...

The output is the same, but that's coincidence.

I need a solution that even if I had 20 changes between groups on a single ticket say

1 to 2 to 1 to...

Blah I should have spent more time on the test data.

Multiple entries can be entered in sequence for the same group, it doesn't always change from record to record. ...

Jeff Moden (7/8/2009)

---

The new future requirement of using a ";" at the end of each T-SQL statement is, perhaps, my greatest disappointment. Let's stop and think about this... we're...

Sorry on the double post... every time I post I get errors these days. Not sure why.

I'm late to the party, but here's my take.

Lynn clued me into Hyperbac when I was exploring this last year.

We've got it deployed on 3 SQL clusters backing up over...

I'm late to the party, but here's my take.

Lynn clued me into Hyperbac when I was exploring this last year.

We've got it deployed on 3 SQL clusters backing up over...

george sibbald (7/1/2009)

---

have you tried the freetext function? that should return any word that contains the word 'red'

select * from addressinfo

where

freetext(address1,N'red')

Its not as precise as contains so you should...

george sibbald (7/1/2009)

---

have you tried the freetext function? that should return any word that contains the word 'red'

select * from addressinfo

where

freetext(address1,N'red')

Its not as precise as contains so you should...

WayneS (7/1/2009)

---

Thanks Wayne... that's not what I meant.

I'm looking for a way to leverage FTI because using LIKE is forcing table scans...

nscott (6/30/2009)

---

Isn't that what backups are for? :blush: Seriously though, I see the real importance of that, even with a "simple" procedure like this. What is the best or...

nscott (6/30/2009)

---

INSERT INTO dbo_WKORDER ( WO_NUMBER, WO_END_DT, WO_CAT_TY, WO_CAT_CD, WO_USER15, WO_USER22, WO_MOD_BY, WO_MOD_DT )

SELECT "SR-" & [dbo_s_repair]![S_Rpr_ID] AS Expr1, dbo_s_repair.S_Rpr_Dt, "Service Laterals" AS Expr2, "10130" AS Expr3, dbo_s_repair.S_Rpr_By, dbo_s_repair.S_Rpr_ID, "nscott"...

GSquared (6/3/2009)

---

An example of a bad clustered index is one on a GUID column that uses newid() instead of newsequentialid(), or one on a varchar column with people's names in...