That's what I thought...

jfogel (6/27/2012)

---

Toreador (6/27/2012)

---

No it's not. Just because it is created for one purpose...

Thomas Abraham (6/27/2012)

---

I too went for the #2 choice. I knew that the no index would be created automatically, but thought ..... same as the others. At least I have...

Koen Verbeeck (6/27/2012)

---

vk-kirov (6/26/2012)

---

I can create an index by means of a unique constraint:

CREATE TABLE dbo.QotD

(KeyColumn int NOT NULL PRIMARY KEY,

RefColumn int NOT...

Dangit Jeff!

I like your approach better, but I came up with this... which invariably is very similar to yours...

First we turn it into a calendar table,...

Have to agree with Lynn.... there's a lot of potential issues that could cause truncation, but without the procedure source, table create scripts, and data population scripts so we can...

Nice easy and straightforward.

Fully reading the question, and waiting until after lunch probably helped me. Never seem to get even the easy ones right in the morning.

sestell1 (6/25/2012)

---

mtassin (6/25/2012)

---

If that is the case, are there any advantages to using a table variable over a temp table? I know the optimizer treats them very differently... ...

sestell1 (6/25/2012)

---

I was always under the impression that there was no reason to create indexes on table variables because they exist only in memory.

Does anyone know what SQL Server actually...

Put me in the group who'd use CASE.

But Hugo's explanation was definitely worth the trip into the discussion of the question. 🙂

If your version of sQL supports it, look at using Backup Compression to make your backups smaller.

Make sure to clean up your backups and only keep a small number of...

I agree with the sp_send_dbmail proponents. At least that way you can query msdb.dbo.sysmail_allitems to see the status of the emails if something goes wrong. There are also...

I got this right because my copy of Local Transact SQL Help says as does BOL

' database_name ' | database_id | 0

Is the name or ID of the database...

I'm with Lynn. If the databases are on separate servers, Peer-to-Peer Transactional replication seems the easiest way to do it. You can just publish the necessary trables and...

Are the databases on the same server?

If so, transactions will stretch across them.

If not... DTS can handle your needs.