Viewing 15 posts - 5,086 through 5,100 (of 6,679 total)
What you could be seeing is two different cached plans based upon different connection options. I would verify that the connection options in SSMS match the connection options from...
May 28, 2009 at 4:16 pm
I am not sure if this can be done with Litespeed, haven't tried it myself. I don't know if that option is available.
May 28, 2009 at 4:12 pm
Don't forget sp_help_revlogin - if you need to create the logins on a new server.
May 28, 2009 at 4:09 pm
All of the _WA_% indexes are system generated and shouldn't be a problem. I would run the following to make sure there are no additional problems with the database....
May 28, 2009 at 1:34 pm
GilaMonster (5/28/2009)
I hate dogs. Little ones I just dislike, big ones actually scare me.
We have two dogs, the daughter has a cat that thinks its a dog and the sister...
May 28, 2009 at 1:29 pm
Instead of looking at the history of the job - view the history of the maintenance plan (Open the Maintenance Plan folder, right-click on the maintenance plan and select View...
May 28, 2009 at 1:14 pm
Here is a thought - create a report in Reporting Services. Schedule the report to be run and delivered every day by email in HTML format.
You can either have...
May 28, 2009 at 1:04 pm
You know, I keep hearing about the number of post on The Thread. It is an impressive and truly astounding number.
But, has anybody checked out the number of views?...
May 28, 2009 at 1:01 pm
Ken - yep, it is one of the 'it depends' type of things. It really should be something that is tested and accounted for on each system you support.
There...
May 28, 2009 at 12:17 pm
A couple of options:
1) Dynamic SQL - build a sql string and execute the string.
DECLARE @sqlCommand varchar(max);
Set @sqlCommand = '';
SELECT @sqlCommand = @sqlCommand + ' SELECT {columns} FROM ' +...
May 28, 2009 at 11:57 am
Well - this is one of those 'it depends' type of questions. There is no problem in SQL Server 2005 with multiple tools performing full backups.
The problems occur when...
May 28, 2009 at 11:40 am
It probably makes sense to stagger the start times of each type of backup. At least, between the differentials and the transaction logs. Starting the transactions logs on...
May 28, 2009 at 10:08 am
Nicholas Cain (5/28/2009)
SQL could just be choking down on the OS causing the lock ups...
May 28, 2009 at 10:03 am
Direct from books online's help about SQLCMD:
[ -q "cmdline query" ] [ -Q "cmdline query" and exit ]
Which one do you think you should use?
May 28, 2009 at 9:53 am
Lookup the topic SET IMPLICIT_TRANSACTIONS in Books Online. You can set this for the connections, or set it for all new connections in SSMS.
May 28, 2009 at 9:46 am
Viewing 15 posts - 5,086 through 5,100 (of 6,679 total)