You might want to check out the white paper SQL 2008 Technical Reference Guide

Yes, I assumed that a table with a million records would already have a clustered index. That's why we pull the data into a #temp table, and throw the index...

Steve Jones - Editor (8/19/2010)

---

You don't know my voice? I thought everyone did 😛 (http://sqlservercentral.mevio.com/)

I need to install it and play with it. Haven't done it so far since I...

You know, the people that help out here are all un-paid volunteers, so please HELP US HELP YOU. Providing the DDL scripts (CREATE TABLE, CREATE INDEX, etc.) for the tables...

I would suggest:

1. Using a Common Table Expression (CTE), get all the values of the table. Utilize the row_number function to assign row numbers to each row, starting at one...

I don't think you need to worry about using SSIS - you can drastically speed this up in T-SQL.

First, make this change to the first 3 functions to quickly create...

I would suggest adding the email addresses to a temp table, then do the update by joining on that.

i.e.

CREATE TABLE #tempEmail (EmailAddress varchar(100))

INSERT INTO #tempEmail

SELECT 'asdf@snarf.com' UNION ALL

SELECT 'qwerty@reddit.com'...

Attn: all User Group presentation coordinators. I've been working on converting my article on Comparing Table Variables with Temporary Tables[/url] into a presentation. If you're interested in having me do...

CirquedeSQLeil (8/17/2010)

---

I find out who did it...

CirquedeSQLeil (8/13/2010)

---

Brandie Tarvin (8/13/2010)

---

CirquedeSQLeil (8/13/2010)

---

Nothing like coming in to work to find out that the server team deployed patches to production boxes, caused an outage, didn't communicate that fact, and...

Gianluca Sartori (8/12/2010)

---

Paul White NZ (8/12/2010)

---

David Benoit (8/12/2010)

---

I haven't had a...

jcrawf02 (8/12/2010)

---

I'm sure that I read someone's blog/article about how table variables can be indexed during the declaration of the variable, and I think it was outside even of a...

You can do this with a single query only if you're...

I thought that to use a configuration file, that you had to specify it in the SSIS package itself? I thought that was how it knew to load it.

You are going through a very rough way of doing this.

I'd not worry about the system databases. Instead, I'd worry about the data in them that is needed to bring...