Viewing 15 posts - 796 through 810 (of 823 total)
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...
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
December 1, 2009 at 10:41 am
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
Viewing 15 posts - 796 through 810 (of 823 total)