First, the only way you will learn is to do. If you have problems, ask specific questions.

Second, if you really want help, then please read and follow the instructions...

CirquedeSQLeil (12/15/2009)

---

The Dixie Flatline (12/15/2009)

---

The Thread ebbs and flows, Bru. 🙂

Barry (aka MISTER 10K) made an heroic effort to participate in the final sprint down the stretch and...

I'm wondering if properly indexed temp tables in place of the table variables might not be a solution without converting the cursors? I'd move the creation of the temp...

Also seeing the use of table variables. Do you know on average how many rows of data may be inserted into each of these tables? As the number...

We had a performance issue with our PeopleSoft Finance application when we upgraded from SQL Server 2000 to SQL Server 2005. Long story short, there was a table used...

Ack!! I just looked at the code you posted. Cursors! Have you looked at rewriting the cursor-based code as set-based?

And, no, I haven't starting looking at the code...

Personally, I'd need more specifics regarding your requirements. You indicate that each day the filename changes, but when you say file1 one day then file2 the next, is the...

Are you copying or moving the files. If you are moving the files, they are removed from the source location, so if you run it once in VS (BIDS),...

Or: select * sys.tables

Have you even bothered to read ANYTHING in Books Online? Do you even know what it is? Many of your questions could easily be answered...

Magy (12/15/2009)

---

Well if I do this query:

SELECT machineID, machineType FROM machinema A

LEFT JOIN modelma B ON B.startmachine = A.machineID

WHERE A.modelID = @modelID

ORDER BY startmachine DESC

it is in the order I...

What is the table definition for XMLmodelMap and what indexes are defined?

Also, the only way to ensure order in a query is to include an ORDER BY clause in the...

Another option, you can make your nonclustered indexes covering indexes by including the columns from the table used frequently in the index using the INCLUDE clause of CREATE INDEX.

In this...

Here are the indexes you have:

idx_acct clustered located on PRIMARY acct_id

idx_acct_stub nonclustered located on PRIMARY acct_stub

idx_name nonclustered located on PRIMARY acct_stub, acct_name

First, if most of your queries are like the...

Without capturing the required data at specific points in time for reporting, about the only other suggestion I have is to back out of the data the transactions entered after...

You are getting a key lookup because you are asking for all the columns to be returned in the query. SQL Server is using the nonclustered index idx_name to...