Same reason you can't put two normal clustered indexes on a single table. A clustered index *is* the table. It's either in a row-based format (CREATE [UNIQUE] CLUSTERED INDEX) or...

Error message is very clear, you cannot create more than one clustered index on the same table.

CREATE UNIQUE CLUSTERED INDEX [FactSales_SalesID] ON [dbo].[FactSales] (salesid ASC)

WITH (DATA_COMPRESSION = PAGE)

GO

CREATE CLUSTERED COLUMNSTORE...

No, not without changing the code around it (which may be something worth considering)

Why doesn't this work ?:

SET @TESTTAB = (SELECT * FROM...

If you go that way, keep in mind that you don't connect directly to the async replica, you connect to the AG listener with the Read Only Intent property added...

I'm not looking forward to September. One flight to Cape Town for SQLSaturday Cape Town, one flight to Durban for SQLSaturday Durban (first event in that city), one flight to...

Then it's either EncryptByPassPhrase, which unless you get the password you won't be able to decrypt, or it's encrypted in the application and the encrypted data sent to SQL.

Go...

After the fact, no, probably not.

If you have an app that's still inserting/updating the column with encrypted values, then a server-side trace may show you what function and key is...

SELECT name FROM sys.database_principals WHERE sid = ...

I think he's thinking about the 'you may run the passive server for 30 days before you need to license it' clause, but that applies to a DR failover, not...

Test it out first and see. I can't rmember where, or if maybe I'm misremembering the requirements and I'm not going searching.

As soon as you do anything else on the passive node, it must be fully licensed. It's only under the 'no licence required' while it hosts a passive DB and...

AlwaysOn failover clustering with a 4 node cluster?

AlwaysOn Availability Groups with a principle replica and three secondary replicas?

Or do you really have Availability Groups and failover clustering mixed? The principle...

Possible, yes. However unless those two sets of users make changes to completely different sets of tables or subsets of the data,...

Can't see the image.

Buffer cache hit ratio is a useless counter. Ignore it.

PLE can't be judged from a single value. Use Perfmon, set up a counter trace which will run...

Chris.Hubbard4U (8/17/2015)

---

GilaMonster (8/14/2015)

---

Check the value of log_reuse_wait_desc. It tells you why VLFs couldn't be marked reusable last time SQL tried. There are many reasons why the log might not be...