You can test connectivity by opening a Windows command line and typing 'sqlplus /nolog'. That will start Oracle's version of 'osql', giving you the ability to connect to your...

Thanks for the replies.

G, I'd like to know a little more about both of those sections.

I've seen excerpts of Kalen's book (it does look excellent), but does it relate to...

Clear, but a little open ended, so I'll throw a bunch of info at you. A couple of real basic tools I use are:

Perfmon (installs with Windows)

ProcessExplorer (in the...

Take SQL Server out of the picture and try and run the same query at the command line, using 'sqlplus'. Does it return data? Can you query other...

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...