Viewing 15 posts - 796 through 810 (of 822 total)
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...
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
November 18, 2009 at 8:13 am
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...
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
November 4, 2009 at 2:20 pm
Back to this...any ideas why the fragmentation remained at +50% when I did a rebuild on the index?
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
November 4, 2009 at 8:57 am
Yeah, I'm a jughead, just realized my FILLFACTOR is 90 and the space used is only 88%.
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
November 3, 2009 at 3:16 pm
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,...
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
November 3, 2009 at 2:29 pm
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'...
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
October 15, 2009 at 9:41 am
Would this work?
BULK INSERT CSVTest
FROM 'c:\csvtest.csv'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = ''
)
GO
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
October 14, 2009 at 12:03 pm
Try this:
http://teamtutorials.com/windows-tutorials/how-to-add-users-in-windows-vista
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
September 18, 2009 at 3:33 pm
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 plugging away...
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
September 16, 2009 at 3:01 pm
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...
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
September 9, 2009 at 9:47 am
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...
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
September 3, 2009 at 1:34 pm
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...
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
September 2, 2009 at 12:08 pm
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.
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
September 2, 2009 at 11:21 am
Thanks Steve, that makes sense.
So next newb question: has someone done this with Powershell/VBScript?
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
September 1, 2009 at 8:39 am
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.
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
August 27, 2009 at 12:36 pm
Viewing 15 posts - 796 through 810 (of 822 total)