print_mug (7/15/2015)

---

Hi everyone. I am quite new to this so please be kind! 🙂

I have been given a project to centralise all our databases onto one DB server. Currently in...

Use SQL's native backup compression.

Personally, to make it clear(er) that EXISTS doesn't care what the columns are.

And 1/0 works, but something like LOG(-1) doesn't. I suspect the latter is a parse-time error.

He's not.

The table inside the subquery is aliased as t and the binding order for columns...

As I said above, the MCSE exams have been updated to include the 2014 material. There's only one set of MCSE exams.

Fixed

Mark the subscription for reinitialisation.

Please note you don't need to reinit a subscription unless something has occurred to change the subscriber or it's been offline for longer than the retention...

Please post new questions in a new thread. Thank you.

This.

Enforce it by using different windows logins for the two servers. Then one instance of SSMS is run as...

No, it's not a good solution. By updating the stats you're likely forcing all plans to recompile. It's probably only one or two queries which are causing the problem and...

How long is a piece of string?

I've got 20 million row tables in my test DB. I've seen tables with billions of rows in them. I've seen systems where no...

Bear in mind that it's not just a case of whether you can install it, but also whether you should, whether the server have spare capacity for the workload that...

RTaylor2208 (7/14/2015)

---

If all you want to know is when was a row changed are you able to add a new column to the table called something like DateModified and have...

Depending what your data looks like and what data types are involved, that query could aggregate to the day, to the minute or to the millisecond. Can't tell.

To return only...

CAST (SomeColumn AS VARCHAR(Max))

CAST (SomeColumn AS VARBINARY(MAX))