No, please not!

Alvin Ramard (3/15/2010)

---

How about a "knocking head against the wall" one...

What I don't like about this is that it is attempting to subtract 1 year... and this will...

RBarryYoung (3/14/2010)

---

Well, my back surgery is tomorrow (it got moved up). They've been putting me through medication withdrawal the last two weeks in preparation, so apologies if I've been...

The 2005/2008 query that I use is:

select OBJECT_NAME(object_id), *

from sys.all_sql_modules

where definition like '%<your search phrase goes here>%'

If I want to limit the results to just views, proc,...

Isn't it amazing how one perfectly innocent term in one culture means something completely different in...

You might want to check out the POWER and SQRT functions in BOL.

Shark Energy (3/9/2010)

---

In the absence of the smart solution have you considered an ugly process of a trigger updating a logging table everytime the column gets updated, and running a...

Lynn Pettis (3/8/2010)

---

IT'S OFFICIAL!! Kirisa is now on Varsity! Coach told her today that she earned the position and is now one of his permanent defenders!!

WAY TO GO...

luissantos (3/8/2010)

---

If i write like this :

select conta, left(dcli.oldesc,charindex('-',dcli.oldesc)-1),dcli.oldesc,

ltrim(rtrim(conta))+' '+right(ltrim(rtrim(dcli.oldesc)),

len(ltrim(rtrim(dcli.oldesc)))-(charindex('-',dcli.oldesc)-1)),

* from dcli where conta <> left(dcli.oldesc,charindex('-',dcli.oldesc)-1)

I receive the following error:

Msg 536, Level 16, State 5, Line 2

Invalid length...

The problem we ran into is that our file server had a local hard drive crash, and was down for 3 days while the entire system was being rebuilt. It...

What I reverted to was to have the servers do their backups locally. Then, on the file servers where the backups are being stored, running a scheduled task that runs...

I don't know about DAC being on a list of tools to master. Agree with others about DTA not being on it... I've seen DTA (and the missing indexes dmv's)...

The style parameter can also used when converting float/real, money/smallmoney, xml and binary/varbinary/char/varchar.

See BOL for...

Grant Fritchey (3/5/2010)

---

I recently interviewed at a company where it was made pretty clear, just how little I know. You're only as good as your experience and the information you've...