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...

It's probably better to avoid using a reserved word, like INDEX, for a table name.

I think some of the more important reasons to maintain all the data in one database are transactional integrity and referential integrity. Doing a restore to a common, consistent...

Why not just call it a NUMBER table, since that's what it contains? Well, it's really integers, but INTEGER is a reserved word...

(Shameless plug for my own Number Table...