🙁 I used an old copy of BOL for 2008 which had a set of instructions for moving the Resource Database. Man... burned!

I've found that converting the varchar to a varbinary in the orderby works. Since I don't need the order very often, I think that will be a satisfactory (but...

Another tool to put in your belt is EXCEPT:SELECT * FROM table1

EXCEPT

SELECT * FROM table2

will give you all the records in table1 that do not exactly match a record in...

Maybe that's what I need to do - keep looking at different collations until I find one that works how I want it to. Latin1_General_CI_AS does take care of...

I encourage you to study Vadim Tropashko's ideas in this area. Although I ran into some limitations for my application that rendered the solution unsatisfactory for my problem, it may...

Hey Steve - here's a thought for the QOD for tomorrow... or another time. I noticed you swapped out an undisclosed part of the SSC logo for a present...

Alright, I dug up my old research and refreshed all the terms in memory. Yes, this is kind of an adaptation of the adjacency model with the advantage of...

I also had a hard time picking between another snapshot and no backup. I did have one thought in favor of the answer specified though (although I thought about...

My question would be that you've already (understandably) underestimated the number of positions you needed once... you sure that 46K is going to be enough for future scalability? If...

Thanks for the reply!

If you don't mind, help me understand the advantage of having it stored in a binary format, but converted for readability. I'm going to use the same...

Alright, if there are no opinions on the issue, how about suggestions on the question? Too long? Not enough detail? Boring title? Too complex? Too...

Jamie, are you saying the monitor server in logshipping actually initiates the failover? I thought it just monitored the current health. I haven't used log shipping since 2000,...

Dr. Diana Dee (11/23/2008)

However, in my experiments, with a SQL Server login having only CHECK_POLICY in effect (but not CHECK_EXPIRATION), when minimum age was set, I could not change the...

Check boxes mean that there are possibly more than 1 correct answer and you need to select all of them. It's no better or worse than Microsoft certifications with...

It's kind of tough without a little more information. Can you tell us how the query plan changes? Does it use different indexes or change from a seek...