Other choices include using SQL Server Integration Services (SSIS), bulk insert, linked servers and regular t-sql, or just use a programming or scripting language to connect to both servers. You...

A trigger is probably a good choice (depending on what the job does). Another approach would be to have the job run on a regular basis, once a minute or...

It could be cumulative from a series of transactions. Is your database in full recovery? If so, are you running log backups? If not, that could be the issue right...

No disagreements that full backups are easier, but the whole purpose of having the filegroup backup is the situation you're in. As the size and complexity of your database setup...

I'm going to pile on with Jeff and strongly suggest you grab a couple of books and get the fundamentals more firmly entrenched in your head. Clustered and non-clustered indexes...

Validate that the two systems are the same in every possible way because even small differences could lead to major performance changes. But, I suspect it's probably related to statistics...

The best way to do this would be to use extended events. You can add an action to any event to capture the program name. But, that has to be...

TomThomson (9/5/2014)

---

cphite (9/5/2014)

---

jcrawf02 (9/4/2014)

---

Ed Wagner (9/4/2014)

---

Koen Verbeeck (9/4/2014)

---

andrew gothard (9/4/2014)

---

You know...

Nope. The dropped the Windows name from Azure. They don't want...

You can't go below the initial size, so you'll have to set that initial size lower. Here is an article from Microsoft that discusses most of the details. There's also...

I did a quick search online and couldn't identify what DCS Service is either.

In general, yes, you can rebuild indexes while the system is in use. You will see some...

So, Eirikur, if you used DATE instead of DATETIME would that also solve the issue? Just asking. I don't know MySQL from MyElbow.

Yep, that's a Performance Monitor counter.

Side note, since you're in SQL Server 2012, I strongly suggest you toss Profiler and go with Extended Events. They're much more light weight, there...

Sean Lange (9/4/2014)

---

Grant Fritchey (9/4/2014)

---

Koen Verbeeck (9/4/2014)

---

Roy Ernest (9/4/2014)

---

Thx guys..

There was not SQL Saturday this year. We will have one during memorial day weekend next year.

Jack, hopefully we...

Koen Verbeeck (9/4/2014)

---

Roy Ernest (9/4/2014)

---

Thx guys..

There was not SQL Saturday this year. We will have one during memorial day weekend next year.

Jack, hopefully we can meet each other...