Viewing 15 posts - 481 through 495 (of 501 total)
Here is the Best Practices Analyzer which may guide you as well.
April 3, 2007 at 12:37 pm
Is it possible some of your job steps had run as user: domain\sam instead of (self)?
March 29, 2007 at 11:56 am
Microsoft offers a migration tool also.
http://www.microsoft.com/sql/solutions/migration/oracle/default.mspx
March 13, 2007 at 4:56 pm
I found the upgrade advisor useful. It let me know what syntax needed to be changed in order for our sprocs to work with 2005.
March 9, 2007 at 4:11 pm
Check the version of ReportingServicesService.exe. It is located: Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\bin
SP1 - 9.0.2153
SP2 - 9.0.3042
RTM - 9.0.1399
March 1, 2007 at 2:33 pm
Stop SQL Server Agent as it may be using the connection.
March 1, 2007 at 2:20 pm
A fill factor of 0 is the default which will fill the pages 100% This is great for static tables as it conserves disk space and reduces I/O. However, on...
March 1, 2007 at 2:18 pm
To change default db and log file locations:
In Enterprise MGR right click the server, select properties, click database settings, at the bottom you can change your default locations.
Then...
February 28, 2007 at 12:10 pm
The reason for the DST change is the Energy Policy act of 2005.
http://en.wikipedia.org/wiki/Energy_Policy_Act_of_2005#Change_to_daylight_saving_time
February 28, 2007 at 12:00 pm
I have seen queries time out because the log file could not grow fast enough.
In general, you should allow your log file to grow to accommodate the busiest day...
February 23, 2007 at 12:35 pm
For your second question, you can use DBCC SHRINKFILE with EMPTYFILE to combine the tran logs into one and ALTER DATABASE to reomve the empty transaction log. See BOL for...
February 22, 2007 at 11:27 am
You can use performance monitor to find I/O stats.
February 21, 2007 at 11:01 am
Thanks Scott. I didn't think there was an easy way to find this.
February 7, 2007 at 9:30 am
You can have an alert trigger a job by right clicking on the alert, going to properties, click the response tab, check the execute job box, select the job, and then...
February 1, 2007 at 12:58 pm
Viewing 15 posts - 481 through 495 (of 501 total)