I know, I know.... I keep hoping to catch up with the tooth fairy - that...

GilaMonster (5/8/2008)

---

Does anyone have any best practice documents/white papers on SAN configuration for SQL Server?

I'm having a rather large fight with the storage team, who want to give me non-dedicated...

I see Jeff has already smacked himself on the hand about using the assignment syntax for aliasing, so I won't pile on...:)

It's actually in the "deprecated file" called...

Wayne West (5/7/2008)

---

Someguy (5/7/2008)

---

...Apparently this company thinks that allowing me the honor of being a walking billboard for their marketing wing is sufficient incentive to pay too much money for...

well - you could simply filter your update statement to not update those rows.

Or you could have a BEFORE UPDATE trigger that catches and prevents the "bad values" from being...

Are those objects in your Model database? That's what gets used as the template for new databases, so any objects in Model at the time you create a new...

davidthegray (5/6/2008)

---

Matt,

Then you should start firing your lighter.

See this sample:

CREATE TRIGGER ToyInventory_UPDATE ON ToyInventory AFTER UPDATE

AS

DECLARE @rcnt int

SET @rcnt=@@ROWCOUNT

IF @rcnt=0 RETURN

IF @rcnt > 1 BEGIN

RAISERROR('You may only change...

I'd agree with the assessment that #2 is a multiplexing scenario. #1 might be interesting though. Depending on what Server B does (or rather doesn't do) with that...

Derek Dongray (5/7/2008)

---

janine.rawnsley (5/7/2008)

---

Hmm I know exactly how UDF's work given that I write/use them but this question must have been worded really badly (for me).

"SELECT UDF FROM Table" -...

sudhakara (5/6/2008)

---

i want retrieve the data from data base files not from table . each row has one unique row key ,if blacking happen its showing that row id...

What - only 12 useful tips? in a single article?:hehe:

Stop it now - you're setting the bar too high for the rest of us....

(superlative as usual).....

Sergiy (5/6/2008)

---

Well, I'm probably lucky, but I'm not THAT lucky.

I'm not sure there is any scientific proof that...

I do hope in a way that they get that deal back together. There is a definite need to have at least 2 viable 1600-lb gorillas going at it...

Jeff Moden (5/6/2008)

---

I don't know about Sergiy, but the only big advantage I've found is that I don't have to convince reluctant DBA's into having two helper tables. I...

Just curious. I like having the utility tables like Tally - but is there a value in having all of those things in a SINGLE table? to do...