Viewing 15 posts - 16 through 30 (of 30 total)
Are you running any sort of index rebuilds during the night? This will cause the ldf to bloat if you are. Look for a script which rebuilds / reorganises based...
June 2, 2011 at 4:43 am
I know sharepoint has it's own index crawl which is I believe is scheduled to run after the app pool is recycled but not sure if this would effect the...
May 19, 2011 at 8:35 am
Just as another option the attached script kills all connections to a DB but single user mode would work as well.
May 18, 2011 at 7:05 am
Sounds like you are using the local system account to run the SQL agent but first lets check. Open the job from the SQL agent, rc properties, go to steps,...
November 12, 2010 at 9:09 am
With it being 32bit you will need AWE enabled for SQL to address more then 3GB of memory without that your not using all the memory available also you should...
September 2, 2010 at 6:39 am
I use this script for moving logins, first one creates a sp in the db and the next executes it with the passwords and user permissions.
When you get the...
September 1, 2010 at 9:32 am
Just for information the "There is insufficient system memory to run this query." error can also occur if you are running a query remotely from SSMS and it goes on...
September 1, 2010 at 8:51 am
Hi,
If you look at the link below it gives a good explanation into the error, basically your trying to insert a string that can't fit into the column due...
September 1, 2010 at 7:50 am
Simple answer no but whats the reason behind the question? Some sort of corruption?
February 24, 2010 at 9:43 am
From looking at other posts about that error message (not had it before myself) it looks as if there is a issue with the data you are trying to import,...
February 24, 2010 at 6:49 am
Check the connection SQL Server Configuration on both servers and check named pipes is enabled and the other connection protocols are ok. Below link might help you as well
February 24, 2010 at 6:33 am
If you have SQL already installed the best way to install SSIS after is going into Add or Remove programs, find SQL Server 2005 and then select change. When the...
February 24, 2010 at 6:28 am
A good script that will give you all the account details of a database
http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31889/
February 18, 2010 at 7:41 am
Rebuilding all the index on a DB probably isn't helping with the PLE. Have a look at the link below as this rebuilds indexes on fragmentation criteria.
February 16, 2010 at 9:58 am
Viewing 15 posts - 16 through 30 (of 30 total)