It can't be restored, but it can be opened in a hex editor and read raw. Won't be easy, but string data won't be that hard to get out. Numbers...

Luis Cazares (9/24/2015)

---

If Gender is a non nullable column, it will work.

I'd usually go for something like this:

Delete T

FROM Event_Temp_Lead_Screen T

WHERE NOT EXISTS( SELECT 1 FROM member M...

It's not an object that's damaged, it's an allocation page, meaning SQL can't tell what should be in a 4GB chunk of the data file.

Restore from a clean backup, this...

Kristen-173977 (9/23/2015)

---

GilaMonster (9/23/2015)

---

Functions in the select execute once per row, and they have an overhead. Data-accessing scalar functions in the select are essentially a hidden cursor inside a select and...

robinwilson (9/23/2015)

---

Thanks all for the information and detailed responses which is all really useful.

Heaps

I was told this by the software supplier:

I accept that clustered indexes do seem like a simple...

No it's not OK, and...

Though profiler, XE and the various dm_exec DMVs will still contain and show the plain text of the executed statement.

Interestingly, in...

robinwilson (9/23/2015)

---

Primary Key vs Clustered Index

Would a clustered index or a primary key (which seems to always create a clustered index anyway) be the better option generally in terms of...

Why?

Then once you're restarted in single user mode, use the DAC to connect. Connections made via the DAC don't fire login triggers.

Start SQL in single user mode to get a...

In that case, it's not the login trigger that's your problem, as a non-sysadmin account can't create a sysadmin login.

Restart SQL in single user mode and connect with a windows...

No.

SQL's not aware of physical fragmentation, of how the files are placed on the drives. Which is why I...

All the sysadmin logins? Or all the SQL authentication ones?

No it doesn't. It requires a sysadmin login, SQL or Windows.