in general terms poorly optimised sql, and views are regular culprits I've found ( not beacuse they are views but often views are written to disguise or simplyfy the underlying...

If you're moving several databases make sure you attach in the correct order to maintain the database id's.

Option 3 is your best bet, especially as you can batch the data transfers to avoid overflow of your transaction log.

When I move data this way I usually put the...

You need to analyse database usage, I suggest you collect statistics for your server so that you can understand how it is performing. Idera Diagnostic Manager is good at doing...

You should be able to return the actual query plan for the proc when it runs - but if you still have problems you can capture the plan in profiler.

Once...

A fundamental part of fault finding and performance tuning is to ensure you test on like for like systems. Might I suggest an investment in a tool such as Redgate's...

It's just worth pointing out that by default how a cursor and while loop work are different from a transaction view point. A while will execute as a complete transaction...

42 ?

It's really a case of housekeeping. ntfs fragmentation is best avoided regardless of raid or memory. If you don't keep on top of fragmentation ( ntfs ) there's always the...

I have to add this, as way of an apology to Jeff, having disagreed with him I have almost as described in sets of tables used in partitioned views -...

If I remember correctly doesn't an update or insert trigger force all data updates to be deferred updates rather than in place updates, thus contributing to page splits and fragmentation?

I've...

Having used Litespeed extensively , on a SAN and DAS, I will happily state that Litespeed did as  claimed and ran very much faster than native. The restores were also...

"and therefore crashes our main server"

Well I used raid 10 for tran logs back in the days of sql server 6.0. Usually you just select, say 4 disks, in the hardware set up and click...

Yup - it just depends - just attended one of Kimberley's indexing events - I don't agree necesscarily with her choices - apps are rarely ideal and often you have...