Why don't you ask the DBA to explain in detail why this is a good idea, and post what he says on this thread?

So how long will it be before Homeland Security requires all air travelers to have an RFID in their ear?

http://www.sciam.com/article.cfm?id=rfid-power

"Now Hitachi, the maker of that chip, is aiming even smaller....

Peso (5/7/2008)

---

Somewhat shorter code

SELECTCOUNT(*)

FROMmaster..spt_values AS d

INNER JOINmaster..spt_values AS h ON h.Type = 'p'

WHEREd.Type = 'p'

AND d.Number <= DATEDIFF(DAY, @Date1, @Date2)

AND h.Number BETWEEN 0 AND 23

AND DATEADD(HOUR, h.Number, d.Number + @Date1)...

This script analyzes the size of all database datafiles on a server in a number of different ways for files size, uses, unused, etc.

Get Server Database File Information

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=89058

If you just need a column to be a unique identifier, then you could just add this to your view:

Select

MyUniqueID = newid(),

…Rest of columns…

From

MyView

There is no point in not running them every 15 minutes right now. You are just running a bigger job every two hours, instead of a small job every...

I recommend doing transaction log backups much more often. I usually set them up to run at least every 15 minutes, 24x7.

This will reduce the amount of data loss...

william.ring (5/1/2008)

---

okay i guess i need to outline the whole picture. its on a Dying server, there is not enough space on the server for backups so they are being...

It's simpler to do this with a join to a temporary table, and will probably run much faster.

-- declare value pair table

declare @values table (col1 int not null, col2 int...

The cursor is on a multi-table join, so I am not sure "WHERE CURRENT OF myCursor" can really be used there. I've never tried that so I don't really...

This was my favorite solution from the thread Peso linked to.

declare @ int set @=0while @<100begin set @=@+1print left(@,sign(@%3*@%5)*3)+

left('Bizz',4-sign(@%3)*4)+left('Buzz',4-sign(@%5)*4)end

Short and easy to understand 🙂

Here is a link to the...

I have seen topics like this about a thousand times on different sites, and have yet to see one where the OP could answer the question “What constitutes a duplicate?”.

Doesn't...

John Mitchell (5/1/2008)

---

Or this one, which uses less string manipulation, but does contain dynamic SQL:

...

-- has to be global temp table to be visible to the dynamic SQL

CREATE TABLE ##Temp(col1...

Will Summers (5/1/2008)

---

I showed how their building network using cascaded hubs was a bottle neck. The brute force traffic study showed that the Network Neighborhood browser keep alive packets...

Jeff Moden (5/1/2008)

---

Or "number" or "sequence" or... that's all part of the reason...