What doesn't make sense? There's nothing wrong with the check table output and without any more info on what you mean by 'can't Drop Table, Select or create a PK...

er.mayankshukla (8/6/2014)

---

Thanks Gail,

So if I am correct for parameterized proc. SQL creates a plan depending on table size as parameter values are not known till compile time.

Since in my case...

There's no estimated completion for queries, that's for things like backups.

No way to tell how long the query will take other than to run it and see.

It means exactly that. At compile time, the...

You cannot encrypt master!

TDE has never been about preventing people from accessing the DB. It protects the files at rest and the backups of the user databases, that is all....

To be honest, recommend that they get someone experienced with HA/DR in to do the design at the very least.

Otherwise, start with this:http://www.amazon.com/Server-2005-Availability-Experts-Voice/dp/159059780X/

and tell your boss that you'll need...

See Part 1 linked above.

It's parameter sniffing, more correctly the lack thereof (see part 2 linked above)

Can't give you any advice since I have no idea which of those indexes are on what columns.

Why...

Look up ROW_NUMBER()

And?

If that's not what you want (which is not at all clear), you need to debug and fix whatever's wrong.

sqlvogel (8/6/2014)

---

Very easily, you just need to ensure that the non-trivial determinants of every non-key...

Last time CheckDB ran *successfully*

Yes, absolutely, 100% certain

Below is an extract from a SQL Server log at the time a database was recovered from a Restoring state....

You need to remove the variables, remove the select from inserted, do whatever calculation of addressid and contact ID in the insert statements and use the INSERT ... SELECT form...

Because your trigger assumes there will be one row in inserted. There won't, there will be one row for each row inserted.

Discard the variables, remove the SELECT @var = ......