er.mayankshukla (8/20/2014)

---

Thanks,

I have searched a lot but didn't got a proper response.

If specifying Compression option in Create Table statement means an automatic compression in the table, then what will the...

Please don't start new threads for existing questions.

Replies to http://www.sqlservercentral.com/Forums/Topic1605321-391-1.aspx please.

Please post the full and complete, unedited output of that CheckDB command.

DO NOT do anything else at this point. Please note that the advice given in the thread linked above...

Depends whether you specify compression in the rebuild statement.

protix (8/20/2014)

---

About 500/sec long term average and 1500/sec peak, the bigger part reading.

Hardware is on on...

Once you have tested thoroughly and have determined that there is no way to meet performance requirements without denormalising. It's a...

Only if you set it to use 128. I'll repeat part of my previous post.

"As part of creating a database encryption key (for...

Depends on what you set it to.

From Books Online (http://msdn.microsoft.com/en-us/library/bb934049.aspx)

To use TDE, follow these steps.

Create a master key

Create or obtain a certificate...

Escape the quote by doubling it

LEFT(LastName,2) = 'O''' -- That's two single quotes to escape the ', then a third one to close the string

They're probably database owner or sysadmin.

New questions in new thread please.

Depends how much of that existing...

Could be a case of blaming the database for an error without investigating.

Errr.... First time I've heard that.

Could you ask that person for the kb article for that 'confirmed microsoft limitation'?

According to Books Online (http://msdn.microsoft.com/en-us/library/ms188365.aspx)

BULK INSERT (Transact-SQL)

Imports a data file...

smtzac (8/19/2014)

---

The Log file space use always 99% free, so what's the point keeping same size?

Yes it does, some time Transaction log file (backup from Log shipping) is 100+...

Why?

Do you need the space for some other database?...