I had this problem where I worked previously.

They had McAfee installed and there was an option in the settings you had to untick (something like "don't allow worms to send...

I've been there and done something similar to what you need to do.

I used Access and created a linked table to the spreadsheet and another linked table to the staging...

I'd love to work in such an environment.

Too many times I've seen people promoted because "their face fit" rather than because of their ability to do the job.

Once that starts,...

Thanks for that, I'll have a look at that as well.

It wasn't unfortunately.

I managed to dig out my old code, etc to track running queries.

This looks very useful as well so thanks for that.

Thanks Sean

Looks like the splitter was what I needed so I'm sorted.

Thanks for your help.

Hi Sean

What I'm trying to do is use some sort of variable in the where clause instead of a huge list of employee IDs (I'm open to suggestions).

One of the...

Just to add in my 2p-worth (after running into similar issues), if you're doing the insert/update/delete as separate transactions, have you considered using a MERGE statement to do everything in...

I've got a spreadsheet which reads a few tables I've set which tracks CPU usage (for now).

I haven't got it set to read disc I/O or anything else at the...

Please ignore my last post. Missed a bit when checking the fill factor.

Morning all

I'm just woring through this and I've found a database where all the indexes have a fill factor of 0 (yup, zero).

Here's the output from the fill-factor query in...

Thanks for the input folks.

Looks like it's off to the bean-counters again. :crying:

Anthony - thanks for that, I'll give it a try and see what happens.

Just one quick question, why have you ignored master, model, msdb and tempdb in your code?

John -...

Will that do all the log files in one go then?

Or will I have to loop through like I was doing originally?

We are swiftly running out of space on the drive(s) so this does need to be done.

The indexes will be rebuilt afterwards where necessary as a separate job step.

If that's...