I think they don't matter as much. In '97 or '98, you could get an MCSE and be assured of a job (almost) making $50k. A lot in those days....

That's something I point out in interviews.

I don't know everything, but I usually know where to find it. Either a resource online or a person I can ask.

I'd start with a variable,

declare @start datetime.

Set that to be the "date" of a year ago using Dateadd. Use months, -12.

Then in your WHERE clause, use the variable.

OK, attempted to correct the answers to include A and B. The old style question and new interface make this an iffy proposition.

Everyone awarded points for this one.

What happens on the way down? I think I'm glad you're not building them either,...

User

----

ID

Name

IsVendor

IsCustomer

IsEmp

Not the best solution, but it works.

Or you have

User

------

ID

Name

UserLink

--------

ID

IsVendor

IsCustomer

IsEmp

Sorry, I meant internal, meaning you don't need variables that you use in the SELECT. Guess it could apply for interval variables.

You could use a CTE if it makes things...

I've heard good things about NetApp products, but haven't really worked with them, so no firsthand experience.

The vendor wants to sell the thing. They'll always say performance isn't a problem,...

What's the provider and what were you doing? Not sure either, but looking for more clues.

Don't think there's a Red Gate tool to do this. Not sure you want to script server settings (sp_configure) to new servers. Maybe, but there are differences between servers you...

xp_cmdshell opens a shell, or command prompt, from inside SQL Server. You can't see it, and it can't need user input, but it works like a batch file, allowing you...

But wouldn't some transactions in merge be applied if they committed? It wouldn't necessarily roll back everything because the network dropped. My understanding is that merge is transactional two-way, but...

I think you might need to loop here, and you need to be sure that there's an order that ensures that records that could be duplicated appear together so you...

I would avoid storing formatting. Things often change, people don't enter them the same way, and it's easier to strip formatting to ensure consistency than add it in later. Phone...

Also, if you have more than one subscriber, the commands don't go down until ALL subscribers have gotten them.