We just went live this past Monday with a migration from SQL 2000 to SQL 2008. This migration also included new servers, new OS (Win2008), Failover Clustering, Virtual Servers (Hyper...

Chris,

I agree with Jeff. You can not use any sort of castings or Coalesces within the Where Clause. You should only use actual field names, more specifically, fileds that are...

Jeff,

How I determined my problem was by viewing the execution plan for the queries that were giving me the problems. In the Execution plan it displayed everything twice. The...

I found my issue that was causing my slow running queries. It appears the Coalesce statements we use to encapsulate the sub-queries would cause the Optimizer to run the query...

I attached the Query Plan and the Query itself. This is a very large Query Plan and it is hard to read.

This query had many previous versions with each causing...

Thanks for the fast replies.

The SQL 2008 server is a major upgrade from the 2000 Server. It is a Dell PowerEdge 2950 2 QuadCode X5450 3 Ghz Processors with 16GB...

Thanks steveb,

That was it. I went through all of that a 100 times and did not see it. Thanks again...Frank

I think we all have bosses like that!:)

I have a couple...One day after having neck surgery (bone fusion) I was back to work programming strapped into my favorite recliner, neck brace, and laptop.

The other example I...

Here is another hypothetical question. If I were to buy one of those chairs GSquared was selling and I liked it so much that I decided to make one myself....

Not to defend the RIAA but is it not the same when buying software designed for one OS and having to purchase another version ported to a different OS?

The...

I did not receive your news letter either. However, I currently use their software and have no complaints with it.

3 is better than 2!

I use 3x19" monitors at work. The ability to read multiple program code across multiple screens makes software development much easier than just using one monitor. My...

You may want to look at Fortinet's product Fortigate 200A. It is inexpensive, handles firewall, vpn, virus protection and a whole lot more. It comes with a 10 user license....

Cowboy Fan!

I knew there was another reason why I enjoy reading your articles aside from the SQL insights.

Go Cowboys!