Viewing 15 posts - 16 through 30 (of 112 total)
dbcc sqlperf(logspace)
this will tell you how big the log files are and what % the log file is using ...
This will give you an indication of what you could...
MCITP: Database Administrator 2005
MCTS SQL Server 2008
MCP SQL 2012/2014
MCSA SQL Server 2012/2014
MCSE Data Management and Analytics
July 4, 2012 at 8:03 am
(/3GB reduces the kernal memory to 1 GB and increases the user memory to 3 GB (instead of the normal 2 and 2).
/PAE enables the windowing memory functions so that...
MCITP: Database Administrator 2005
MCTS SQL Server 2008
MCP SQL 2012/2014
MCSA SQL Server 2012/2014
MCSE Data Management and Analytics
May 16, 2012 at 6:44 am
:blink: will read up thanks
MCITP: Database Administrator 2005
MCTS SQL Server 2008
MCP SQL 2012/2014
MCSA SQL Server 2012/2014
MCSE Data Management and Analytics
April 25, 2012 at 12:48 am
switch from simple to bulk-logged recovery mode ...
MCITP: Database Administrator 2005
MCTS SQL Server 2008
MCP SQL 2012/2014
MCSA SQL Server 2012/2014
MCSE Data Management and Analytics
April 23, 2012 at 8:49 am
+1 Thanks for all the hints/tips
MCITP: Database Administrator 2005
MCTS SQL Server 2008
MCP SQL 2012/2014
MCSA SQL Server 2012/2014
MCSE Data Management and Analytics
April 16, 2012 at 4:27 am
Thanks Enrico, SSIS and SSRS is what I physically did and SSAS is what I have read/learned about hence I know what they can do/there for ...
So far I'm not...
MCITP: Database Administrator 2005
MCTS SQL Server 2008
MCP SQL 2012/2014
MCSA SQL Server 2012/2014
MCSE Data Management and Analytics
April 13, 2012 at 12:47 am
I've been out of the DBA realm for a year +- now ...
Been pulled in SAP BW and it's just not for me :pinch:
Busy studying to upgrade my MCITP 2005...
MCITP: Database Administrator 2005
MCTS SQL Server 2008
MCP SQL 2012/2014
MCSA SQL Server 2012/2014
MCSE Data Management and Analytics
April 12, 2012 at 8:19 am
Setting max server memory to the minimum value can severely reduce SQL Server performance and even prevent it from starting.
http://msdn.microsoft.com/en-us/library/ms178067.aspx
with a server with 12Gb of memory is not not...
MCITP: Database Administrator 2005
MCTS SQL Server 2008
MCP SQL 2012/2014
MCSA SQL Server 2012/2014
MCSE Data Management and Analytics
March 19, 2012 at 7:56 am
there are functions within SSIS that can do this as well ...
MCITP: Database Administrator 2005
MCTS SQL Server 2008
MCP SQL 2012/2014
MCSA SQL Server 2012/2014
MCSE Data Management and Analytics
October 25, 2011 at 6:17 am
Hi have a look @ this http://www.sqlservercentral.com/articles/Monitoring/69650/
I have been using it and it monitors all the sql servers on an entire domain for me ...
saves a lot of time ......
MCITP: Database Administrator 2005
MCTS SQL Server 2008
MCP SQL 2012/2014
MCSA SQL Server 2012/2014
MCSE Data Management and Analytics
October 25, 2011 at 5:01 am
until you add that extra 4GB of RAM to the server you can enable the 3GB switch ...
once the extra 4GB RAM is in the server you can enable AWE...
MCITP: Database Administrator 2005
MCTS SQL Server 2008
MCP SQL 2012/2014
MCSA SQL Server 2012/2014
MCSE Data Management and Analytics
September 28, 2011 at 4:31 am
Brandie Tarvin (6/23/2011)
3) Move the data from the old file/filegroups to the new files. This can be achieved by removing the tables' clustered indexes and recreating them on the new...
MCITP: Database Administrator 2005
MCTS SQL Server 2008
MCP SQL 2012/2014
MCSA SQL Server 2012/2014
MCSE Data Management and Analytics
June 29, 2011 at 7:27 am
from the 4 datafiles on 4 filegroups and 4 drives we would like to migrate to a new server
6 datafiles, 1 filegroup (defined filegroup) 6 drives
will not partition the tables
MCITP: Database Administrator 2005
MCTS SQL Server 2008
MCP SQL 2012/2014
MCSA SQL Server 2012/2014
MCSE Data Management and Analytics
June 23, 2011 at 7:41 am
Fixed it :-P:-P
there was a mail stuck in the queue which I removed via
Use MSDB
ALTER QUEUE ExternalMailQueue WITH STATUS = ON
set nocount on
declare @Conversation_handle uniqueidentifier;
declare @message_type nvarchar(256);
declare @counter bigint;
declare @counter2...
MCITP: Database Administrator 2005
MCTS SQL Server 2008
MCP SQL 2012/2014
MCSA SQL Server 2012/2014
MCSE Data Management and Analytics
January 18, 2011 at 5:55 am
Viewing 15 posts - 16 through 30 (of 112 total)