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...

Probably no real way to prevent it while using MERGE then. It just doesn't have much flexibility. You'd need to have a read in place to prevent the insert, and,...

It's a pretty good rule to not RDP into production servers unless you absolutely have to. Most of the SQL Server and database administration can be done remotely from SSMS.

tcronin...

Are there external processes running on the server like virus software? Do you have a minimum for memory? Assuming an external process started using up either CPU or memory, your...

Make sure you have a unique constraint to prevent getting duplicate values.

Eric Prévost (4/8/2015)

---

OP's job calls a procedure part of Ola Hallengren's SQL Server maintenance plan.

Using sqlcmd.exe is recommanded for proper error handling (From https://ola.hallengren.com/frequently-asked-questions.html):

Do the stored procedures need to be...

Researching which tools to use is, depending on the size of the organization, an architecture role. Usually that's filled by people with a lot more than 2.5 years of experience....

Pretty sure it's because sqlcmd expects it all to be on a single line. Since you're calling this through Agent, couldn't you skip using sqlcmd? Just asking.