I don't think anyone's tried this or knows, but I'll ask a few people.

From my understanding, you can't run two clusters as you're trying. If you have two machines, you'd...

Nice example, Jeremy and it doesn't work because of an implicit conversion of the answer to int, the data types of the inputs.

There is no reason to design the columns in any order. As far as I know, it's not a best practice to make them alphabetical, or any other order.

There's no...

The notmatched rows come from your initial CTE (or SELECT) from what I understand.

My understanding was that you write a SELECT, which is the input into MERGE. The MERGE then...

Are you backing up the log regularly? Maybe try right before the reindex?

The reindex should use 1.5-2x the data space and it's logged, so there's movement, but I wouldn't expect...

Sorry typo in the gas savings. It should have been $2125. I'm not blinded either. I am comparing it to the last van we had, 2004 Honda that said 25,...

If you're starting out, I think a BS/BA helps. It shows you can complete a long project and get work done. Doesn't help you to learn SQL Server, and no...

this is a connection error; are you getting this when you try to connect or when you start the service?

http://www.sqlservercentral.com/articles/Advanced+Querying/tamethosestringspart7/390/

FYI, be careful of using triggers for this. You might cause lots of unnecessary work and this will have to run for every insert/update. You might want to set up...

You are not setting up a maintenance plan if you right click the database. While that might make sense, what you are setting up is an ad hoc backup.

go to...

Please post a question that makes sense. Do not use the subject line as your question and give details about what specifically you are concerned about.

Karl has a pretty good summary of what to worry about and what advice I'd give.

Votes matter on Connect, so I'd actually suggest a few things.

1. Post on Connect

2. Make a post in the appropriate forum here and state your care, and link to the...

Interesting answers, and with these new Mission-Impossible-3D printers, I think I'd avoid biometric data as well.

Here in the US, there are starting to be some devices that work off fingerprints,...

Thanks :blush: