Adding INCLUDE columns to a nonclustered index doesn't affect the clustered index, it's use or maintenance. They only affect the nonclustered indexes.

And here's the problem with NULL values. An absolute unknown can't equal an absolute unknown. Also, running functions on both columns like that will absolutely destroy performance. I'd strongly suggest...

You'll restore the logs using STOPAT. This is a little older, but it's still a good article on how to do a point in time restore[/url]. I have an article...

Plus, it's evaluation, test it. Worst thing happens, you need to set it up again. It's not your production server.

Start with the backups, as you've already done. But, talk to the business about Recovery Point Objectives and Recovery Time Objectives to ensure your backups meet those requirements. Also, make...

Check Database Integrity

Database Backups

Log Backups

Backup Testing

Statistics Maintenance

Index Maintenance

Those are the basics I think.

Fill factor is a matter of experimentation, not size. If it's fragmenting fast, you might want to set it to 70 and see how that goes. Just remember, the smaller...

How many pages do those indexes consist of? If it's less than 8 pages, you shouldn't even bother trying to defragment them at all because it usually won't work. If...

I'll make a suggestion now, cheat and use Minion Reindex[/url] instead...

TomThomson (4/8/2015)

---

Grant Fritchey (4/8/2015)

---

Koen Verbeeck (4/8/2015)

---

Grant Fritchey (4/8/2015)

---

Probably get in a little trouble for this, but since I know that many of you are both SF fans and, let's just...

One the left side you can see those IFCode Shortcuts. One is ". I just highlight the T-SQL and then click on the value on the left.

From what you pasted you need to uncomment the variable declaration and set a value.

But I tested this code and it worked just fine:

DECLARE @specificDB VARCHAR(100);

SET @specificDB = 'AdventureWorks2014';

DECLARE @dbid...

You can't go down with the backups. 2014 has a different file structure than 2012 which has a different one from 2008R2, etc.

As Luis said, some functionality will work from...

If you installed it and got it failing over on your first try, you're probably already head & shoulders above most people.

The expert on clusters is Allan Hirt. He has...

I don't suppose you have before and after wait statistics on the server? It'd be good to know specifically what was causing stuff to run slow.

sp_whoisactive didn't point out anything...