I'm using the SQL2008 SSMS and have the same problem. I've found these keys and sure enough they list all of the valid servers I've connected to, but where I've...

And having made the first post - the forums are way better.

Just keep that "Supreme Being" title under my avatar and you've won brownie points forever!

Woo hoo!

I've always wanted to be the first to post a reply to a topic :w00t:

Just a quick comment to say that at first impressions, I'm very impressed!  Gone are...

As a DBA myself, and as part of a company than has very sensitive data, I do believe that a high level of trust has to be assigned to a...

Excellent news guys, and good luck for the future.

This site has saved my neck on a couple of occassions, always insightful, always informative, and sometimes great for a bloody good...

The problem is with SQL "parameter sniffing"

Not often this occurs, but when it does, the performance of a stored procedure can degrade quite dramatically.

You can usually tell when this occurs...

I think this is something of an unfair question!

Indicating that fact that SQL Server is better than mySQL on the basis of the presence of this (somewhat superb, informative, amusing, feature...

Just for reference to anyone reading this.  We cracked it, but not without some interesting repercussions.

It appeared that the link between the NT groups and SRS's interpretation of them had...

This wasn't a bad one at all.

Every disaster recovery plan should have off-site storage.  What happens if there is a fire in the datacentre, a (heaven forbid - fire the...

Oh I dunno, I could imagine Microsoft turning off the support at the end of 2005 and releasing the product in 2006!

Incidentally, when are the banners on this post page...

I had a horrible feeling this was the case.

Masny thanks.

Jamie, I have to admit, after the revelations from this QoD, I think it would make a very interesting article to compare Oracle, ANSI, SQL and the extensions Microsoft have...

Michael, the alias is referenced, but not until absolutely necessary.

In SQL Statement A the Order By alias is used. The column is not found in the results, so SQL...

OOPS!

You are in fact correct, they have got the answer the wrong way...

Nope, the question is correct

With query 1

SQL extracts a dataset using the Select statement

This consists of

ORDER_NOITEM_NOUNIQUEID

RON11

RON21

RON31

RON41

BILL12

BILL22

BILL32

BILL42

FRED13

FRED23

FRED33

FRED43

SQL is the asked to order the resultset by myIT.Unique_ID desc

SQL will first ignore the...