It won't change the IDs on a reboot, no.

It sounds like you have a corrupt database. Do you regularly run DBCC CHECKDB on your databases? If not, I'd strongly suggest...

Maintenance plans are there so that you do actually maintain your databases, which must be done. But, as you get more sophisticated, yes, you're probably going to stop using maintenance...

Is the connection issue to Azure? That could be network latency because you're going out to the cloud.

If it's just local... I'm not sure. I'd suggest using standard troubleshooting approaches,...

I think this is down to clarity of code versus actual functional differences. I'd go with the ISNULL and/or COALESCE over a CASE statement.

But, as with anything, test it yourself....

I'm going to be at SQL Rally at the end of February. I'll fly from there to SQLBits on Wednesday. I'm presenting two sessions at Bits. I'll also be at...

I like Ola's scripts and Michele's. I recommended them both in my book.

There is another option to look into. Minion Reindex by Sean & Jen McCown. I wrote a review...

Just so you're clear on terminology.

A backup is a page-by-page copy of the database including all the database objects and the data inside the database.

You're asking for a script for...

From the sounds of things, I'd probably keep the databases separate. It's not a question of whether or not there's a need for data between the two systems. It's more...

sm_iransoftware (1/31/2015)

---

I read It.

the most important and repeatedly Advise is :

Dont use Repair option. because ....

The impression from this recommendation can be

1- I must run only DBCC checkDB...

Peter Schott (1/28/2015)

---

Grant, I appreciate the detail in reviewing Minion Reindex. It's great to have an impartial third party look at something like this and give their thoughts on how...

Michael Valentine Jones (1/28/2015)

---

Does it have the option of generating and displaying the rebuild or reorg commands without actually executing them? I guess I would call this a preview...

You're welcome.

I'm unimpressed by their responsiveness because I expected nothing less. 😛

Nah, I figured they...

I think they stack up quite well. In fact, there's some degree...

Brandie Tarvin (1/27/2015)

---

Oh, hey! Let's all go to Russia in the middle of a war!

Dear SQLSaturday Speakers,

This is a one-time system message for SQLSaturday #398. SQLSaturday #398 is coming...

Since the days of SQL Server 7.0, if I've seen backups impacting a system in a way that affected performance, it was because there were already a bunch of other...