Viewing 15 posts - 5,101 through 5,115 (of 6,679 total)
Ken Simmons (5/27/2009)
If you don't need to update your statistics with full scan - then you should use the procedure sp_updatestats which will only select statistics that need to be...
May 28, 2009 at 9:11 am
That is the whole purpose of SSIS - I would recommend using BOL and http://www.sqlis.com to get you started.
May 27, 2009 at 8:25 pm
Lynn Pettis (5/27/2009)
May 27, 2009 at 4:00 pm
Why are you trying to make this dynamic? If you are extracting data from one system and loading it into another (ETL process), you really need to have a...
May 27, 2009 at 2:51 pm
That depends on when you are scheduling them. If they are part of the daily maintenance, then it would come after the integrity check. If they are scheduled...
May 27, 2009 at 2:46 pm
As Steve has stated - the commands are what I stated. Definitely review books online for further information for all of the commands.
I really don't have a script available,...
May 27, 2009 at 2:41 pm
Are you now backing up the transaction log on a regular basis?
Verify the recovery model of the database. Is it full recovery or simple?
If simple recovery model, shrink the...
May 27, 2009 at 10:58 am
What have you tried so far? Have you taken the time to read the article I link to in my signature? Have you taken the time to read...
May 27, 2009 at 10:50 am
I would recommend using synonyms for this. You have to define each object that you are going to reference, but it is very easy to create and modify later...
May 27, 2009 at 10:33 am
As others have stated, lookup row_number() in books online and also read the article in my signature. It will show you how to post your questions in a way...
May 27, 2009 at 10:10 am
Pradyothana Shastry (5/27/2009)
use the followingBackup log with truncate_only
dbcc SHRINKFILE(DBNAME,0,Truncateonly)
This is very bad advice to give, unless you want to break the log chain and destroy your ability to recover...
May 27, 2009 at 10:04 am
For database mirroring, yes you have a full copy of the database on the other server that is unavailable because it is recovering transactions. However, with Enterprise Edition you...
May 27, 2009 at 9:55 am
You need to update the usage on that database. I would bet anything the database was upgraded from SQL Server 2000 and you have never run an update usage.
May 27, 2009 at 9:19 am
Grant Fritchey (5/27/2009)
AShehzad (5/26/2009)
Statistics will be updated automatically after index rebuild. There is no requirement to separately configure this task.Are you sure? 😉
Yes, statistics are updated after rebuilding the index...
May 27, 2009 at 9:11 am
You are running into the double-hop problem. If you require Windows Authentication to work you are going to need to setup and configure kerberos for the service line account(s)...
May 27, 2009 at 9:00 am
Viewing 15 posts - 5,101 through 5,115 (of 6,679 total)