I don't think it can be treated as a full outer join because your WHERE clause doesn't allow for TOTALPROM to be null. the optimizer would then "override" your...

Glad it helped!

Michael (4/10/2008)

---

One more question if you don't mind... What is the purpose of the WITH (tablock, INDEX(pk_tempfiles)) statement? I know that it's a table hint but I don't...

GilaMonster (4/10/2008)

---

At my current place we start with the technical interview. Since we're curently looking for people to do performance tuning and monitoring, I'll usually start with a very simple...

A few specifics:

- The group numbers reset when you go from one filename to another. so every filename should have a groupnum 1. That's just to make sure...

I remembered reading that as well... Of course - it is worded as "strongly recommended that you uninstall and reinstall", so I suppose you upgrade directly.

Not having any direct...

absolutely true - if you want just the public views and...

you went and changed the specs on me! Sorry to say - by having to do range checks - it gets a little uglier. You unfortunately lose a...

John (4/9/2008)

---

Gents -- Thank you for your 3-replies -- I learned a lot from your answers. I understand the server-concepts and I am much clearer on things -- and...

If you want to go freeware/shareware, you might consider taking a look at Crimson Editor. It has a customizable markup language (so it knows what to highlight, keywords, etc...)....

As to what you should do now:

- put the johnxxx.mdf files back where you found them.

- start SQL Server Management Studio, and connect to your instance (machinename\SQLEXPRESS)

-...

wow...lots to work with.

Let's see if we can start with a few:

SQL Server is just the name of a product family. In the 2005 version of those products, the...

Raghu (4/9/2008)

---

Hi Mahesh, Bob,

First, I appreciate replying to this post. The reason for different databases are:

1. This is a product which an organization who decide to use will select a...

Keith - A few options to look at:

- start by looking at the advanced properties of your source file definition. You will see definitions/assumptions as to how long...

Can't say I've tried that yet, however - as far as I know - updating the client is no different than upgrading the entire server. download SP2 from Microsoft's...