Being quite blunt and straight-forward with this reply. I have seen issues over and over with what you are pursuing:

1) What is your experience with windows clustering and SQL...

mario17 (11/25/2014)

---

Hi,

I'm bit new for this, for now I see that we can do trigger + setup kind of audit table with all content to be backed.

I suspect that it...

TomThomson (9/25/2014)

---

I don't understand it at all. An interesting twist is that...

Because it doesn't. Please find me your documentation that states ORDER BY with your collation will follow ASCII order.

create table testtable2 (n tinyint not null, c varchar(1) not null)

GO

;WITH

L0...

Luis Cazares (11/19/2014)

---

ramana3327 (11/19/2014)

---

That is not related to parameter sniffing.

Why because we are passing 3 input parameters. Those are default parameters. We are not changing either in SP or Report...

Actually that part is simple - I know a guy ... 😎

1) Your metric of 80% fragmented isn't really useful. You can have 5 20GB file chunks for tempdb with 4 of them not being adjacent to each other and...

Brandie Tarvin (11/14/2014)

---

Kevin, thanks for the links. Now I have more questions.

Is Primary Replica the database of origin or just the first replica that was set up?

Per the above...

Based on what you posted, I am not sure if you understand or not. Your post seems to apply when you have SI/RCSI on the PRIMARY.

This is...

The databases are NOT "independent" when you read from an AG secondary. You wind up modifying the PRIMARY records under the covers with the 14-byte row-version pointer. Most...

I will add that you must be on Enterprise (or Developer) Edition of SQL Server to use them at all.

http://technet.microsoft.com/en-us/library/ff878253(v=sql.110).aspx

Search for whitepaper: Offloading Read-Only Workloads to Secondary Replicas

http://blogs.msdn.com/b/sqlserverstorageengine/archive/2011/12/22/alwayson-impact-of-mapping-reporting-workload-to-snapshot-isolation-on-readable-secondary.aspx

Jeff Moden (11/12/2014)

---

SQLJocky (11/12/2014)

---

So I inherited this server that has a ton of UDF's written as simple select statements (at least one incoming parameter like start date and then return...

Hey Brandie!! Please do make sure you REALLY know what your objectives/needs are and that you are doing things correctly to get you there. There are SOOO many...

Be careful. Recursive CTEs can be DREADFULLY poor performers!!