Viewing 15 posts - 12,226 through 12,240 (of 22,214 total)
Ninja's_RGR'us (6/27/2011)
Grant Fritchey (6/27/2011)
June 27, 2011 at 5:33 am
It really depends on the volatility of the data, the structure of the indexes, and the types of queries run against it. We updated statistics on an insurance system I...
June 27, 2011 at 5:12 am
You're retrieving 261000 rows out of a table that has 268000 unique values (not sure if that's how many rows it has or not). I'm a little surprised that it's...
June 27, 2011 at 5:07 am
Many of the maintenance tasks you're doing can be logged operations. That would explain the increased log backup size.
Why, oh why are you shrinking the database? That is, in the...
June 27, 2011 at 4:54 am
Recovery means it is checking its integrity and rolling back/forward transactions that were open when it was shut down. There's no way to know for sure how long it will...
June 27, 2011 at 4:52 am
pcarroll-626929 (6/24/2011)
- The task manager like graphs at the top of summary values for the...
June 25, 2011 at 4:42 am
This article is for 2005[/url] but it's all applicable to 2008. There are just a few new things you can do in 2008 like compression.
June 24, 2011 at 6:24 am
Moving it to 2008 updated the statistics. Try doing that on your 2000 server and see how that affects the query.
June 24, 2011 at 6:21 am
If you do a little searching around in the Visual Studio documentation, there is a database and set of code specifically designed to use SQL Server for caching data between...
June 24, 2011 at 6:11 am
You can install both on the same server and they'll operate just fine.
But, that's not saying that they won't impact each other. You will see contention for resources.
June 23, 2011 at 9:03 am
Is the table a part of a join? Is it the bottom part of a Loop join perhaps? How many executions are there? Does that equal the number of rows?
June 23, 2011 at 7:27 am
Where'd you get the pictures of my yard?
June 22, 2011 at 12:53 pm
Nope.
That text column is going to be a limiter for you.
June 22, 2011 at 7:38 am
ROLLBACK is used when you have an open transaction to undo the changes for that transaction. It doesn't work after transactions have already been committed. This article [/url]I wrote at...
June 22, 2011 at 4:57 am
No, you could go one more level deep. Have three tables. One for the measure, one for the measure type (height, width, weight), and one for the business measure type...
June 21, 2011 at 2:19 pm
Viewing 15 posts - 12,226 through 12,240 (of 22,214 total)