Viewing 15 posts - 15,511 through 15,525 (of 19,564 total)
PaulB-TheOneAndOnly (4/2/2010)
in short, hire a senior DBA with proven experience in data modeling and physical implementation 🙂
Superb Idea
April 2, 2010 at 8:32 am
Gianluca Sartori (4/2/2010)
TheSQLGuru (3/26/2010)
Will you be iteratively (and by iteratively I mean 5+ perhaps) hitting the temp table?
I have found in some cases that taking off a copy to...
April 2, 2010 at 8:31 am
Paul White NZ (4/2/2010)
CirquedeSQLeil (4/1/2010)
Often times the database will be fine on a SQL 2005 box while running under 2000 compatibility. Testing is necessary though.
Yes. Compatibility levels are...
April 2, 2010 at 8:23 am
Paul White NZ (4/2/2010)
chrismat (4/1/2010)[hrApparently the entire query window becomes the SP and doesn't stop at the END; statement at the end of the CREATE PROCEDURE... I didn't realize...
April 2, 2010 at 8:21 am
gmamata7 (4/1/2010)
exec sp_import_errorlog
@log_name =errorlog,
@log_number = 0,
@overwrite = 0
but getting the below error:
Msg 213, Level 16, State 7,...
April 2, 2010 at 8:19 am
GilaMonster (4/2/2010)
Mani-584606 (4/1/2010)
So is that normal to have low PLE while running DBCC CHECKDB?
Absolutely. CheckDB reads every allocated page in the entire database, hence you're going to have a...
April 2, 2010 at 8:17 am
Paul White NZ (4/1/2010)
CirquedeSQLeil (4/1/2010)
Thanks for the links Paul.Actually, my advice is to read everything Craig F has ever written!
Thanks - I will look into more of his stuff.
April 2, 2010 at 8:16 am
Since a CHeckDB also performs a checktable (which checks all of the pages in the database), it would seem that it should drop the PLE very low. Somebody else...
April 1, 2010 at 7:44 pm
See how this really isn't just a simple question?
April 1, 2010 at 7:34 pm
Lynn Pettis (4/1/2010)
CirquedeSQLeil (4/1/2010)
April 1, 2010 at 7:31 pm
Definitely add logging to the package.
http://msdn.microsoft.com/en-us/library/ms167456.aspx
This package ends and terminates properly when run from bids?
April 1, 2010 at 6:46 pm
JC-3113 (4/1/2010)
what is SQL RNNR ?Jim
My blog and twitter handle.
April 1, 2010 at 6:35 pm
JC-3113 (4/1/2010)
Hi Steveall my databases are on a Windows 2003 servere running SQl Server 2005 though
Jim
Which means you would have to update to SQL 2008. Steve recommended that you...
April 1, 2010 at 6:35 pm
Leon, I would recommend you follow the advice by Toby. Though User connections will take a nominal amount of memory, you need to scale for the application and...
April 1, 2010 at 6:26 pm
This means that a database is working correctly on SQL 2008.
You should do this in a dev environment first, then a UAT environment and test all of your applications.
Once you...
April 1, 2010 at 6:01 pm
Viewing 15 posts - 15,511 through 15,525 (of 19,564 total)