Thanks for your replies, G. Dunno if this is what you're asking:

avg_frag_in_percent - 53.84615385

fragment_count - 8

avg_frag_size_in_pages - 1.625

page_count - 13

avg_page_space_used_in_percent - 88.87305411

record_count - 1559

I couldn't find a size in...

Back to this...any ideas why the fragmentation remained at +50% when I did a rebuild on the index?

Yeah, I'm a jughead, just realized my FILLFACTOR is 90 and the space used is only 88%.

Yeah, I think so. But it was done with a REBUILD...again, I'm fuzzy on the fragmentation understanding:

Day 1:

-- Processing STANDARD table dbo.FOCUSRequests, STANDARD index [Name], -- partition 1,...

Definitely not elegant, but works. I used a DOS command line and the 'osql' utility:

FOR /F %s in (serverlist.txt) do osql -S %s -E -h-1 -Q "SELECT @@SERVERNAME"

Obviously, 'serverlist.txt'...

Would this work?

BULK INSERT CSVTest

FROM 'c:\csvtest.csv'

WITH

(

FIELDTERMINATOR = ',',

ROWTERMINATOR = ''

)

GO

Try this:

http://teamtutorials.com/windows-tutorials/how-to-add-users-in-windows-vista

KD,

Take a look here, there was a similar situation:

http://www.sqlservercentral.com/Forums/Topic771547-1291-1.aspx#bm772038

The book that I suggest there has some real basic stuff that might help. In my experience, just keep...

Seems file creation/FTP is the old school way of doing things (but probably still the fastest). From a SQL Server standpoint:

1. What recovery type is your SQL Server...

For each plan there are individual tasks, right click and choose 'Edit' or double click one of those tasks (they are the boxes in the plans that have arrows coming...

Sorry, I should have been more clear =)

Go to the maintenance plan, right click and choose 'Modify'. I was looking at one of my backup plans, so I chose...

Dump the SQL from the job, it should allow to 'View T-SQL'. It'll give you more info, we can then start down the sys.databases path.

Thanks Steve, that makes sense.

So next newb question: has someone done this with Powershell/VBScript?

Try putting brackets around the database name:

select name from [QA_WSS_Search_NSAB-SS82-SPF-N].dbo.sysfiles;

go

SQL no likey the dash, probably sees it as a minus sign.

Congrats on the new position, I found myself in similar circumstances. I went thru this book:

http://www.microsoft.com/learning/en/us/book.aspx?ID=9364&locale=en-us

and was able to pass the test on the first try. ...