Yes, I've been through that pain too. I actually had it working for a while (pretty much using the steps Phil has mentioned) but at one point it all fell...

A year already? When searching for SQL answers I still get hits on his articles. It does make me pause for...

I wrote a small series on isolation levels a while back, so I could understand how they worked.

Start at http://wp.me/p3Vxvi-8R and see if they help.

Is the numeric part always in the same place (i.e. end of the forename/start of surname or suchlike)?

If so, it might be worth stripping the numeric section off into a...

Luis Cazares (11/2/2016)

---

I'm not looking for a job, but I take a look at offers from LinkedIn every now and then just to see what's being offered/requested.

That said, can anyone...

I knew you were going to ask that...

Have a look at Redgate's SQL Data Compare. It's available as a fully functioning trial version, so you can decide if it is suitable.

sqlserverDBA2016 (10/24/2016)

---

is it always better to add database features like analysis services and integration tools and reporting services

when installing sql server instance, and it wont complicate and cause issues on...

sqlserverDBA2016 (10/24/2016)

---

i'm gonna be using ssms to run the export and import.

but i'm just asking if whether after the installation of sql server 2014 , is there a backward compatibility...

sqlserverDBA2016 (10/24/2016)

---

do I have to install backward compatibility after installing SQL server 2014.

And what is backward compatibility used for.

And Can I restore databases back to a 2008 instance from...

I assume you meant which is better - adding the clustered index before inserting data, or after inserting data?

The answer is of course 'it depends'.

At a previous job we dealt...

Even 20 years ago! Even? I was 13 years into my IT career 20 years ago - it wasn't that far back!

Last week some staff...

As wonderful as that B&N bookshop is, if you ever get the chance...

Cakes are in the tent.

After three months of begging, whining, nagging and the occasional bout of holding my breath until I went purple, I now have Redgate's Toolbelt.

I've never worked...

Thank you for the replies, people. They have helped enormously and shown me that what I was trying to do was ridiculously complex - which is what I thought.

And there...