You have to set up permissions between the domains. No other way to do it since the security is through your local domain. Another option would be to post the...

Smendle (5/12/2016)

---

TheSQLGuru (5/12/2016)

---

My...

ganapathy.arvindan (5/12/2016)

---

Yes Dates would be easier but 01012016shift 01012016shifttype looks not pretty..for the understanding i need all the d1shift d1shifttype d2shift d2shifttype......d30shift d30shifttype..if i deosn't have value then it should...

Try capturing the segmentation elimination with this extended event. It might prove more informative than the execution plan in this situation.

If you have the time to completely shut down transactions prior to the backup, yes, that sounds like an adequate process and you won't have to worry about the transaction...

The shortest possible answer to your question is, yes, Availability Groups can substitute for Failover Clusters. However, as Kevin says, we really don't know enough about your situation to make...

BLOB_EATER (5/12/2016)

---

Is it wrong that I no longer have the desire to do SQL certification exams? Do I need to look in the mirror and slap myself very hard?

Don't...

I'm with Jacob. The best approach is to use a plan guide. Either use the guide to pass a hint for the query, or, use plan forcing to pick the...

Eirikur Eiriksson (5/11/2016)

---

Grant Fritchey (5/11/2016)

---

Without seeing the execution plans, I'd just be guessing.

My guess is, you may have hit some bad parameter sniffing on the query that was running fast...

Without seeing the execution plans, I'd just be guessing.

My guess is, you may have hit some bad parameter sniffing on the query that was running fast previous to the addition...

Instead of moving all the data into the temporary table, then running the processing against it, I'd suggest you put a WHERE clause on the Bulk copy so you don't...

check the wait statistics for those queries while they are running to understand where the slowdown is occurring. It's possible it's the memory, cpu or I/O of your local system....

Just be clear, Redgate isn't a source control management system. It's a way of integrating with TFS or Git or Mercurial or Subversion. Pick the source control system that your...

You should take another look at the syntax for the UPDATE statement.

As Lynn says, you're missing quite a bit there. Your statement should look something more like:

UPDATE dbo.MyTable

SET Column1...

And it was a pleasure.

Loved Bits....