Viewing 11 posts - 76 through 86 (of 86 total)
How correct are the statistics?
Microsoft recommends that you "Use the sp_updatestats stored procedure to update statistics in user-defined tables in SQL Server 2005 databases." (http://msdn2.microsoft.com/en-us/library/ms144267.aspx)
September 18, 2007 at 12:10 am
"(Not overly concerned because also have SharePoint site b/u’s that will restore...."
Did you run checkdb on these backups and if so was it OK?
September 13, 2007 at 1:01 am
Does this have to be a stored proc? If you use a function then you could query it -
CREATE
FUNCTION fn_foo()
September 5, 2007 at 12:31 am
Do you include the login column in the profile trace?
If so, the tuning log may be using this login ...
http://www.eggheadcafe.com/aspnet_answers/SQLServertools/Jun2006/post27098374.asp
September 5, 2007 at 12:25 am
If you get any errors from a DBCC then BOL says to restore from a backup (see DBCC CHECKDB (Transact-SQL) ).
If this is not possible could you...
August 30, 2007 at 12:37 am
Sorry - not totally sure what you are asking.
Why not invoke the stored proc from SSMS first -
EXEC sp_someproc @param1=1 ....
this should help define exactly where the error...
August 3, 2007 at 1:34 am
Agree with the above post.
The current log is ErrorLog.
August 2, 2007 at 3:23 am
I'd definately prefer to backup the SQL2000 then restore in SQL2005. This should allow better testing and planning. I used SSIS to copy logins, messages etc. Don't forget to run the upgrade advisor...
July 30, 2007 at 6:46 am
The autoincrement will be unique (unless you are turning off the identity in your import).
Creating a unique index on one (or all) of your other columns will prevent duplicates in...
July 30, 2007 at 4:05 am
Hiya
thanks for this - I've decided that its probably not worth worrying about.
I moved that database to SQL2005 and saw the ratio start to move, so it may be...
July 27, 2007 at 7:46 am
Why not use triggers? The DDL triggers are designed for this.
If you switch c2 audit on then you will hit most requiements and get a lot more besides. Problem with...
July 10, 2007 at 12:17 am
Viewing 11 posts - 76 through 86 (of 86 total)