Its been a big hit for me. I'm able to drastically reduce operating costs, and provide the same level of service availability and performace. Of course, testing and...

Not being a Microsoft support rep, and looking at that log file, my educated guess would be either

1. Windows Installer is messed up and needs to be reinstalled.

You...

Michael Earl (8/8/2008)

---

I would be VERY careful with any structural changes. Even adding an index could violate a licensing/maintenance agreement. It could also cause blocking or slow something...

For most orgaizations, the determination is cost more than anything. It has less to do with a "technology" decision and more of a "business" decision.

Consider the costs of increasing...

Yes basically the deal with auto update stats is that as your table gets bigger, the number of column changes required to trigger the auto update gets larger as well....

The index spooling you saw was the query processor creating an in-process index in tempdb for the LIKE comparison operations. If you look at Query 2, it does the...

Hey Grant, do you have a general value you apply or do you use some kind of formula based on counters? Just curious.

That's changed recently. There's a lot of info available now that AWE has an impact on...

Looking at the two query plans, for Query1 I see that it decided to parallelize the entire plan. Query2's plan does not. See the following for a basic...

These combinations are not the only ones possible but they represent the common scenarios. Did you notice that the /3GB boot.ini switch is not recommended over a certain memory size?...

Two things...

1. Make sure the lock pages in memory local group policy is enabled for the SQL Server service account.

2. AWE still has an effect in the 64...

Sounds strangely familiar. You probably have a clustered index on an ascending value (datetime or identity or whatever). On a large table, stats on these indexes are flagged...

Just a question. What's the source of these 10 million records? You will want to bulk-load the table while the database is in bulk-logged mode or the thing...

Wow, that sucks. Well, hopefully you can use this scenario to help change their minds. Seems to me like an excellent business case for the upgrade.

You could go...

What you're looking for is a "sliding window" scenario for dealing with partitioned data. Check out the following article...

http://msdn.microsoft.com/en-us/library/aa964122.aspx

Optionally you can get creative and manage it like the following...

http://blogs.msdn.com/menzos/archive/2008/06/30/table-partitioning-sliding-window-case.aspx

The...