Viewing 15 posts - 106 through 120 (of 137 total)
My suggestion would be not to start changes indexes yet. If the query was working at one time and has stopped that smells like indexes and\or statistics are...
April 8, 2008 at 8:24 pm
Two more thoughts, check to is if your autogrowing in the database and\tempdb. You could be at max file size and processes are waiting on growth.
April 2, 2008 at 4:25 pm
It is odd that inserts are taking that long but your not seeing any Perfmon counters indicating you are disk bound. I'd start using Sql Profiler and focus...
April 2, 2008 at 4:19 pm
Rich
My two cents in the EM or Management studio is unreliable for shrinking databases. Read the BOL on DBCC Shrinkfile and use that.
One of the smartest DBA's I ever...
October 2, 2007 at 7:58 am
A lot of this is good conversation but this guy seems to be in a tight spot. If I were facing the situation you describe I would:
1....
September 20, 2007 at 8:28 am
It sounds like your only running FULL backups with a full recovery model. This will not clear the transaction log.
You should either add transactional backups to...
September 19, 2007 at 11:32 am
Help about shows:
Microsoft SQL Server Management Studio9.00.3042.00
I think that is the latest ver.
August 24, 2007 at 10:00 am
Fair question, by clunky I mean:
*server connection doesn't persist
*filters such as databaseid, duration doesn't persist.
*the template selection is just a drop down list. I can't save and organize templates on disk. ...
April 12, 2007 at 8:05 pm
Obviously, you can save the output hence the clunky remark.
The point of the question was to see if anyone has found a clever way to make the trace definition...
April 12, 2007 at 10:58 am
Well put Jeff.
I think to help this chap we need the follow:
* the query
* current run time
* desired run time
* the amount of data being returned.
* the output of from...
April 9, 2007 at 10:21 am
Lynn question is very relevant but you should be using the DATEDIFF function to do the math. See Books on line for the details.
April 6, 2007 at 8:41 pm
How many of the 50 columns are you querying for and how many rows are you getting. That combined with your run time will tell us more.
Run this...
April 6, 2007 at 8:31 pm
The quality hasn't been good on Sql2k either. Remember the AWE patch for 8.00.2039? Then the 1st rollup after that got pulled back? If you read...
April 6, 2007 at 8:23 pm
I sent you a PM with my e-mail address. I would double check to make sure AWE was setup properly.
March 22, 2007 at 12:45 pm
Viewing 15 posts - 106 through 120 (of 137 total)