Script out the CREATE TABLE from management studio, along with all indexes and constraints. Use SELECT INTO to put the data into a temp table. Drop or rename the table...

Suggestions for what?

That is serious overkill. It's extremely unlikely that you need to rebuild all indexes every time. Look up Ola Hallengren's index maintenance script (or go to http://ola.hallengren.com/) and use that.

You...

https://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

https://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

Be specific. What exactly is wrong? Wrong results? If so, where and what should the results be? Throws an error? If so, then...

Hugo Kornelis (6/26/2016)

---

I like the sentiment, but I don't think there is any realistic chance of this having any effect. The votes have been counted; the results are in. Accept...

Kinda true. It's got its own scheduler...

If you're talking about situations where there's no sysadmin login, or the only one is sa and the password has been forgotten, then you don't need the DAC at all....

That's why I think you're connecting to something other than what you expect.

This is what...

Sean Lange (6/24/2016)

---

Ugh....just needing to share this unbelievably ridiculous mess I just stumbled across.

create view [dbo].[getNewID] as select newid() as new_id;

Really? A view to get a guid???

But wait...it gets even...

Ed Wagner (6/24/2016)

---

GilaMonster (6/24/2016)

---

Yes, for a change we do. Our High Court has ruled that the...

DNS redirects? Ask your network admin for help, it does sound like the connection's going to a different instance somewhere.

Also, check you haven't made a spelling mistake in the server...

Yes, for a change we do. Our High Court has ruled that the appeal against the...

Ed Wagner (6/23/2016)

---

Phil Parkin (6/23/2016)

---

Jeff Moden (6/23/2016)

---

On the "Brexit" thing, the folks in GB really need to consider the ramifications to their automotive industries. The EU has a 10%...

True by implication,...