You can also use DBCC FREEPROCCACHE and pass it the plan handle of the plan you want removed from cache.

NOTE: If you don't pass it a plan handle, you...

There's not much on the detailed internals of the in-memory indexes yet. The non-clustered index is still a b-tree, sort of. They also call it a bw-tree. The bw stands...

Lempster (9/10/2014)

---

polkadot (9/5/2014)

---

Grant, thanks for feedback on second part of question. I dug around for more info and found I can find a query's plan handle and remove it...

GilaMonster (9/10/2014)

---

Shall we try for Bits next...

I agree with everything but the tough part.

Don't listen to Gail. We're actually just one person and you are the first to notice.

Thanks for the kind words. I'm glad the session was helpful.

I'd love to present...

Or, implement full recovery. Depending on the type of data, that might be a good idea anyway. It sure makes disaster recovery easier. Well, not easier really, but more effective.

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