Viewing 15 posts - 45,031 through 45,045 (of 49,571 total)
fixfox8 (8/15/2008)
It is in my question "very large database[/u] file more then 2TB"
Is it a data file (.mdf or .ndf) or a log file (.ldf)
What's the output of the following...
August 15, 2008 at 7:54 am
You can connect to a 2005 server from 2008's management studio. The server remains 2005. I'm not sure if you can debug against a lower version. It's one of the...
August 15, 2008 at 7:46 am
afgone (8/15/2008)
if i uninstall 2008 would i be able to use 2005
You should be able to. In fact, you should be able to use 2005 anyway. 2005 and 2008 can...
August 15, 2008 at 7:43 am
afgone (8/15/2008)
cant remember which one it was. but when starting it says katmai
That would have been one of the CTPs. Any idea how long ago you installed it?
All of the...
August 15, 2008 at 6:34 am
Did you install one of the CTPs or the evaluation version? It should have said what version it was during the installation.
August 15, 2008 at 6:18 am
Take your trace file and look for the queries that overall take the longest and/or have the highest number of reads. Take those queries/procs and see if you can tune...
August 15, 2008 at 2:41 am
Considering that, I will recommend recreating the pk as a nonclustered index, and putting the clustered index on the three columns
[ValidationExceptionId]
[ValuationPoint]
[ValuationPointDate]
Since there are no queries using the PK to filter,...
August 15, 2008 at 2:26 am
Not unless you have an unbroken chain of transaction logs from the time of that full backup up until now.
You can't restore the backup, then switch some of the files...
August 15, 2008 at 1:15 am
Use explorer's search to see if you can find the missing file.
When you deleted the database (step 8) SQL went and deleted all the files that are part of...
August 15, 2008 at 12:19 am
Make sure that you've updated all the statistics on all the tables after the upgrade.
UPDATE STATISTICS < Table Name >
August 15, 2008 at 12:13 am
Don't think so. I think it's just the metadata and some statistics of the index. The DTA's got some undocumented tricks that it uses when it tests queries out.
August 15, 2008 at 12:09 am
As far as I'm aware, they are used by the Database Tuning Advisor to help it estimate the effect that an index would have on a query.
August 14, 2008 at 3:40 pm
Or upgrade to SQL Server 2008. It's built right into management studio.
August 14, 2008 at 3:32 pm
Viewing 15 posts - 45,031 through 45,045 (of 49,571 total)