Lamprey13 (6/10/2011)

---

A little late to the part and it sounds like you might have it coverd. But, do the statistis show the correct row count? I've seen them get out...

Reverse the order of "select" and "insert".

INSERT INTO [dbo].CustomerABC

SELECT L.CURRENTABC

FROM [dbo].LIM_ABC_Table L

I recommend listing the column(s) to insert into instead of just leaving that part blank, but...

coronaride (6/10/2011)

---

I see where you're coming from and I agree - however, I don't believe that's what the author was talking about. He specifically mentions names and addresses as...

Compatibility level won't affect that. But, if you want to check it, you can select that from sys.databases.

What did you do to check the index use?

Here's a valid query:

SELECT...

I don't see any reason for this to be dynamic at all.

My first thought was complex search querying, but it seems to be just two input parameters (start and end...

The easiest way is make the query into dynamic SQL, plug in the database name as part of a three-part name for the tables, and execute it that way.

That's certainly a very normal design for that kind of thing. I've seen variations of it many times.

It creates certain performance and management issues, but so does any other...

I see the cursor cycling through the database names, but the query doesn't do anything with that so far as I can tell. You aren't actually switching databases just...

Michael Valentine Jones (6/9/2011)

---

I have seen a table that was 15 GB in size, even thought the rows were narrow, and it only had 200 rows in the table. ...

mtillman-921105 (6/9/2011)

---

GSquared (6/9/2011)

---

The reason I asked about it being a heap in the first place is because that exact behavior is one of the reasons Microsoft recommends against using heaps...

Add "default" as a second parameter:

Select * from fn_trace_gettable('C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\log_255.trc', default)

Tell them about the problem. Also ask why they use global temp tables, since this is generally considered a poor design decision. They might have a solution, or...

Are you talking about querying the XML data so that it reads like table (columns and rows)?

If so, then XQuery is what you need. The functions you'll most likely...

There are lots of numbers like that. Zip codes, credit card numbers, driver's license numbers, SSNs, serial numbers for products, bar-code values, etc.

All of these are good candidates for...

I think you may have copy-and-pasted the wrong string into your post.