no I don't believe the sp_ issue is resolved in sql 2005, haven't tested this for a while but seem to remember you still get a cache miss - no...

the most important point is that most databases and applications are often not well written for any number of reasons. If the performance of the database is bad then fair...

the obvious question is if you should be able to do this or not?

You should talk to the system administrator of the system you want the copy from, protecting the...

I get this with a simple while loop, which I can't post as it's client code, the results display in text but not grid mode - I'd say as I'm...

All of this is dependent upon your database size(s) and the throughput required of course.

grow and shrink will fragment the internal structures inside the database as well as producing ntfs fragmentation .. it's a really bad way to go. Try to fix the sizes...

I agree Andy, I use both methods, there's something I can't just remember about why some of this is so, I've just scanned a 200k row table and get figures...

 a single table select or a join ? A join may still create worktables.

off the top of my head and if this were a super critical query I'd be trying to use covered indexes where I could.

In no particular order these are the...

well I'd take the join hints out for a start. I also have to say that what you're asking is pretty basic and adding MCDBA after your name will probably...

You should make sure you consistantly use one method or the other. Profiler will report the use of worktables which QA will not. In certain circumstances profiler shows the true...

oh and when using profiler you might want to turn off io stats and show plan in QA

inserts really test the disk subsystem. You altered the batching which is why you got the difference. You really want to make sure each insert is a page, your first...

umm no sorry it doesn't make sense to me. If you're asking about index use then it's also down to io cost not just are all the columns in the...

I personally dislike views, except the partitioned and indexed types - however, the main reason is that when views are used within joins to other tables or other views the...