Probably no difference at all.

Check the execution plans for two queries like that, see if they're different in any way.

What's wrong with this:

declare @DateFormatted char(8);

select @DateFormatted = CONVERT(CHAR(4), getdate(), 100) + CONVERT(CHAR(4), getdate(), 120);

select @DateFormatted;

Unzip the file I attached here, and try this:

select *

into #T

from openrowset('MSDASQL', 'Driver={Microsoft Text Driver (*.txt; *.csv)};

DefaultDir={path to file, not including file name};Extensions=csv;',

'select * from CSV1_4_Cols.csv') Test;

select *

from #T;

Once it's...

Yeah, indexed views are definitely in the category of "Do not try this at home. Trained professional in a closed database." But, if you know what you're doing,...

What would be the correct format for today's date? (Need a sample of what exactly you want in order to help out here.)

You could use Select ... Into ... and dump the data into a temp table. If you have row names in the first row, you can use those to...

Page count is the one that matters. 13 pages is WAY too small for fragmentation to matter, so SQL is pretty much ignoring you and just doing what it...

Jeff Moden (11/4/2009)

Ummm... not always true, Gus. If...

I'm pretty used to remote desktop through the internet being pretty awefully slow.

I've used Vista for remote desktop locally (same LAN) with no problems, and I've used it from three...

Right-click the database in Management Studio, go to Properties, select Options, and see what the Compatibility Level is set to.

Every time I've tested out various compression schemes for backups, they've sped the process up, not slowed it down. Makes sense - CPU and RAM are faster than disk...

When you say "not accepting", what do you mean? That it gives you an error message, or that it doesn't give you the data you expect?

My first suspicion on...

Is there a reason that you're pulling the data out of the directory instead of out of the msdb backup tables? msdb.dbo.backupset has the file name and the database...

Makes sense.

Can the code from the trigger be moved into the proc?