*it's somewhere in the OpenXML statement*

:pinch:

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

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

:blink: will read up thanks

switch from simple to bulk-logged recovery mode ...

+1 Thanks for all the hints/tips

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

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

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

there are functions within SSIS that can do this as well ...

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

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

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

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

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