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:

Neither is necessarily better. If you have a view, you can create the view and apply a filter in the WHERE clause that limits data.

Perhaps you should try a few...

May or may not have any impact. Are you using the IPs to connect?

Network changes do not necessarily change anything for SQL Server.