There are tons of people here more knowledgeable about indexing than I on here, but a couple things spring immediately to mind:

Are you doing something really nuts like SHRINKDB() all...

I did it a different way than Brian did...  the SELECT queries are always nice to make sure you're affecting only the records you intend to... (better safe than sorry!)

I think this works... <g> Oh right... the DATEADD stuff is just to confirm that it's actually a date at that point. It is. <g>

use tempdb;
go

DECLARE @FileString...

• This reply was modified 4 years, 6 months ago by pietlinden.
• This reply was modified 4 years, 6 months ago by pietlinden. Reason: me mordio la estupidez!

Following on from what Steve suggested, if all the Excel files have the same structure, you can use a folder source in PowerBI (or Excel) and it will append all...

Why not model like a regular invoice/invoice detail ? You're making this way harder than it has to be.

Once you understand how normalization works and how to apply it, this...

SELECT TOP (n) ID

FROM MyTable

ORDER BY NewID()

then build the insert from that. ORDER BY NEWID()

Basic totals query. Give it a try. Not like you can break anything.

Not sure who told you to put NO LOCK in all your queries, but don't unless you like...

(Maybe the OP should watch Grant Fritchey's videos on backup and restore on Youtube).

Seriously, though... if you don't understand how backups and restores and log files are related, you're in...

If you want people on here to do your work for you, are you willing to send your paycheck to them?

I can't see your data, so it's hard to tell. Can you post some sample data... CREATE TABLE script, INSERTS... so we have some idea what your data looks like?

Because someone who shouldn't have had rights to execute his own SQL statements instead of being limited to existing, properly written stored procedures etc?

Pretty sure you can tell Steve is joking when he says "Power BI".

(That said, I guess that explains why there's no section here for it)...

Forget about loops for a minute. What are you actually trying to accomplish? Please explain.

How to Resize tempdb — DatabaseJournal.com

Okay, I'm super confused. If your data is already in a tabular model, don't you use DAX (or maybe MDX) to query it? If the issue is DAX, read Rob...