Be careful when shrinking a data file. You'll potentially introduce heavy fragmentation.

Any time you shrink a data file you'll want to either rebuild or reorg any fragmented...

Also with the stored procedure did you try...

CREATE PROCEDURE xxx @date datetime AS

DECLARE @xdate datetime

SET @xdate = @date

SELECT yyy FROM zzz WHERE aaa = @xdate

I mentioned that as the last...

Yep. There's no easy answers really.

Just out of curiosity, why are you using a partitioned view instead of a partitioned table with a partition scheme and function? I...

Oh, and I almost forgot. You probably have clustered indexes on those tables that follow a natural ascending order (i.e. datetime field or IDENTITY). In this case, when...

Its more likely because of the parameterization of the query. You should generally try to avoid using a local variable in a query predicate. The optimizer doesn't do...

Looks like its not your log file size. I'd look for any maintenance plans that do index rebuilds or reorgs and dont have the SORT IN TEMPDB option set....

Its been my experience that this is not possible without reconfiguring the publication, distributor, and subscribers.

You can script out the current configuration, but be careful! The script...

Awesome book, got it right here on my desk. 🙂

dweil (8/7/2008)

---

On this subject we are hoping to install sql server 2005 standard on a two node 64 bit cluster in the near future.

Is windows 2008 mature enough to run...

Any time you create a temporary table within a stored procedure, you increase the likelihood that you will force a recompile of that procedure.

Try creating a permanant "work" table for...

Just like the song says. "The answer, my friend is blowin' in the query plan". Ok, maybe not quite...

In all seriousness, I bet the query plan for the "combined" query...

Without knowing the specifics of your database design, lets make some "dangerous" design assumptions. Let me know if I'm off in left field here.

1. The table being queried...

Furthermore, I just took a look at the other questions you've posted today and its clear that these are lifted directly from a technical pre-screening quiz that I wrote for...

Ok, sure. I've always wondered about this anyway so using your code I ran the little test. Here are my results...

fragmentation_in_percent value before clustered index

26.0869565217391

fragmentation_in_percent value during clustered...

One thing you can possibly do is to make sure you have good statistics on the columns involved in the referential integrity on the large referenced tables. SQL Server...