note that index defrag and index rebuild are very very different, the table was badly fragmented, I can't understand why you need to rebuild the table with 80% fill factor...

I think if you're asking this question then you shouldn't be trying to do what you're asking. I'd recommend SQL Diagnostic Manager as a very useful tool for this type...

why and how do you get a 25gb log with a 2gb database, or are the figures a typo?

removing the log with detach is very dangerous and may leave you...

actually I'm not quite sure what you're asking - do you have a sleeping spid causing blocking or just a sleeping spid?

You can see if you have an open transaction...

but why would you want to reduce the reserved size, and if you're just a web developer what are you doing messing around inside sql server ? No offence intended....

A guid makes a lousy clustered index in sql 2000, in sql2005 you have the option of a sequential guid. To improve performance make your guid non clustered and add...

sorry but i'm totally unconvinced of the results and I personally think this is probably a bad article to be published as it may misslead.

Isolation levels are critical to data...

cool! I use the forum to help me learn to troubleshoot and tune. Without the problems, questions and users I'd not have the understanding of this. The articles teach and...

Well I actually think this issue, for SQL Server, pales into total insignificance compared to the basically lousy security within the third party apps that run on SQL Server. (...

std edition is restricted to 2Gb ram.

There seem to be so many posts regarding server running flat out ( I have one such too, but I know the main problem )  it can be quite a...

nah! If a query maxes a box it's usually at fault - unless the server/hardware is totally inadequate for the need.  what sort of box are you running this on?

Do...

You still need to consider stats, indexes and plans, especially if the data is changing in the tables. Having tempdb on a fast drive array seperate to the data array...

there's been an article by Andy Warren with a mass of posts on the subject of cursors. Let's not start another < grin >

I fail to see any real correlation between hardware and this specific question.

Data partitioning is good if it aids aging out of data or if there are distinct reasons...