Jack Corbett (1/14/2009)

---

Do you work for...

I just saw our CEO (30,000+ employees) was wearing a hoodie and jeans today.

Guess I’m going to have to start dressing down.

This way will prevent SQL Server from bypassing the check.

Case statement conditions are evaluated one at a time, and processing of the case stops on the first true condition.

Select

9 as...

If you mean a true remainder, this will give it:

select 2621475%65535

If you actually mean you want to see the decimal fraction, this will give it:

select 2621475./65535.

As to why, you should...

Getting back to the original subject of the T-shirt, I just looked at our company manual, and it specifically bans wearing T-shirts, along with sweat suits, hats, tank tops, stretch...

I have rarely seen anything below 99%, so I don’t pay much attention to it.

I look more at Average Page Life Expectancy and Page Reads/Sec. These seem to be...

Going strictly by the stated requirements, then -2147483648 is the lowest unused value.

RBarryYoung (1/8/2009)

---

Yeah, but "YDM" is not the date standard for any nation. That's why ISO choose it. And what is the alternative way to do this that is...

DATEADD(YY,1,MyOldDate) is the way to go to update the year, but you should be aware that dates of 2008-02-29 wirll be converted to 2009-02-28, because there is no Feb 29...

sqlservercentral (1/6/2009)

---

Thanks for the feedback so far. I was curious as to whether the use of an Identity column for the PK would result in a possible bottleneck when several...

The best way to handle this is to let SQL Server compute the time difference as a datetime (EndTime-StartTime) that is an offset from 1900-01-01 00:00:00.000 and then parse the...

CAST(CAST(ROUND(dbo.invoice_line.qty_shipped, 0) as int) as varchar(40))

There really is no self-documenting code. Looking at the code only tells you what it actually does, not what it was meant to do. At the very least,...

This thread is amazing; there hasn’t been an on-topic post since Sunday but it just keeps on going. :exclamationmark:

A better backup strategy would be to eliminate the differential backups and run transaction log backups every 15 minutes 24x7. This will prevent your transaction log file from growing...