Viewing 15 posts - 46 through 60 (of 111 total)
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...
---------------------------------------
It is by caffeine alone I set my mind in motion.
It is by the Beans of Java that thoughts acquire speed,
the hands acquire shaking, the shaking becomes a warning.
It is by caffeine alone I set my mind in motion.
January 6, 2009 at 3:16 am
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!
---------------------------------------
It is by caffeine alone I set my mind in motion.
It is by the Beans of Java that thoughts acquire speed,
the hands acquire shaking, the shaking becomes a warning.
It is by caffeine alone I set my mind in motion.
September 24, 2007 at 2:50 am
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...
---------------------------------------
It is by caffeine alone I set my mind in motion.
It is by the Beans of Java that thoughts acquire speed,
the hands acquire shaking, the shaking becomes a warning.
It is by caffeine alone I set my mind in motion.
September 24, 2007 at 2:48 am
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...
---------------------------------------
It is by caffeine alone I set my mind in motion.
It is by the Beans of Java that thoughts acquire speed,
the hands acquire shaking, the shaking becomes a warning.
It is by caffeine alone I set my mind in motion.
August 10, 2007 at 2:23 am
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...
---------------------------------------
It is by caffeine alone I set my mind in motion.
It is by the Beans of Java that thoughts acquire speed,
the hands acquire shaking, the shaking becomes a warning.
It is by caffeine alone I set my mind in motion.
November 14, 2006 at 1:41 am
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...
---------------------------------------
It is by caffeine alone I set my mind in motion.
It is by the Beans of Java that thoughts acquire speed,
the hands acquire shaking, the shaking becomes a warning.
It is by caffeine alone I set my mind in motion.
September 15, 2005 at 6:25 am
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...
---------------------------------------
It is by caffeine alone I set my mind in motion.
It is by the Beans of Java that thoughts acquire speed,
the hands acquire shaking, the shaking becomes a warning.
It is by caffeine alone I set my mind in motion.
July 4, 2005 at 9:23 am
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...
---------------------------------------
It is by caffeine alone I set my mind in motion.
It is by the Beans of Java that thoughts acquire speed,
the hands acquire shaking, the shaking becomes a warning.
It is by caffeine alone I set my mind in motion.
June 8, 2005 at 3:26 am
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...
---------------------------------------
It is by caffeine alone I set my mind in motion.
It is by the Beans of Java that thoughts acquire speed,
the hands acquire shaking, the shaking becomes a warning.
It is by caffeine alone I set my mind in motion.
June 1, 2005 at 1:48 am
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...
---------------------------------------
It is by caffeine alone I set my mind in motion.
It is by the Beans of Java that thoughts acquire speed,
the hands acquire shaking, the shaking becomes a warning.
It is by caffeine alone I set my mind in motion.
May 25, 2005 at 1:53 am
I had a horrible feeling this was the case.
Masny thanks.
---------------------------------------
It is by caffeine alone I set my mind in motion.
It is by the Beans of Java that thoughts acquire speed,
the hands acquire shaking, the shaking becomes a warning.
It is by caffeine alone I set my mind in motion.
October 4, 2004 at 1:47 am
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...
---------------------------------------
It is by caffeine alone I set my mind in motion.
It is by the Beans of Java that thoughts acquire speed,
the hands acquire shaking, the shaking becomes a warning.
It is by caffeine alone I set my mind in motion.
July 28, 2004 at 4:19 am
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...
---------------------------------------
It is by caffeine alone I set my mind in motion.
It is by the Beans of Java that thoughts acquire speed,
the hands acquire shaking, the shaking becomes a warning.
It is by caffeine alone I set my mind in motion.
July 27, 2004 at 8:41 am
![]()
![]()
![]()
OOPS!
You are in fact correct, they have got the answer the wrong way...
---------------------------------------
It is by caffeine alone I set my mind in motion.
It is by the Beans of Java that thoughts acquire speed,
the hands acquire shaking, the shaking becomes a warning.
It is by caffeine alone I set my mind in motion.
July 27, 2004 at 7:40 am
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...
---------------------------------------
It is by caffeine alone I set my mind in motion.
It is by the Beans of Java that thoughts acquire speed,
the hands acquire shaking, the shaking becomes a warning.
It is by caffeine alone I set my mind in motion.
July 27, 2004 at 7:21 am
Viewing 15 posts - 46 through 60 (of 111 total)