Who is Bueller?

Why don't you put the file in its own folder, then you don't need to worry about the file name - just look for any file in that...

That's rough. What are non-technical people doing even looking at code, never mind imposing standards for it?

John

Maybe you could get the powers that be to have a look at the article I linked to? If I remember correctly, the thrust of the argument was that...

There was an interesting discussion on comments recently here.

John

I know it's a matter of preference, but I'd rather have any complexity tucked away in the CTE definition than in the body of the query,...

Does this happen every time, or did it just occur once? Do you have any jobs or triggers on Server B that might remove the indexes?

John

Clearly not useless, even if your personal preference is not to use them. And no more or less complicated, in my opinion, than...

Is this repeatable, or did it just happen once? What statement(s) are you using to restore the database, and what statements (if any) do you run after it?

You appear...

Well, it was on the phone, so maybe I just heard what I wanted to...

I've had developers gasp in wonder when I've shown them how to use code similar to Jamsheer's and thus...

Good question, thanks. I'd have liked to have seen in the explanation why the third and fourth options were wrong, something like this:

Option three is not correct because the...

I think what Jeff is getting at, and I agree, is that you shouldn't necessary use the first solution you're given. Mark himself admitted that it's "quick and dirty"...

I've got a feeling the free space only tells you what's in the data file. Have you tried sp_spaceused?

John

The database size in the database properties window includes the log file size.

John

The only thing I can think of is to use the percent_complete column of sys.dm_exec_requests. You'll want to test to find out how accurate and reliable it is.

John