Innerise (7/8/2015)

---

Perry - those links suggest that making the latest statistics available on a readable secondary (via the secondary replica creating and maintaining temporary statistics for secondary databases in tempdb)...

http://www.sqlservercentral.com/articles/Tally+Table/72993/

Innerise (7/7/2015)

---

Hi All

We have a 2-node SQL Server 2012 AlwaysOn setup, in synchronous mode with readable replica databases. We have a particular reporting query that we're running against one of...

Her process is patently ridiculous. Period. She should be working to find/correct the "cause" of the "huge" tlogs. But if they get large for a given reason that is valid...

a4apple (7/6/2015)

---

Hello everyone,

I have a stored procedure which is nested. I have local variables defined to avoid parameter sniffing in both the procedures too.

Proc A calls PROC B, PROC C,...

Check the table trigger(s)

We will be much more willing to help you if you script create table statements and inserts for us that set the data up the way you show it. That...

You have functions around columns in the WHERE clause. No matter what else, you can't efficient until those are removed.

Very odd situation, but this script will create login scripts from existing logins in ACTUAL master. The only question is can you access the tables the script hits from a...

A secondary cannot possibly have a 14-byte pointer for reading data (NULL or populated) without the primary first having such alteration made to the row. The primary MUST reflect the...

snuthalapati (6/10/2015)

---

What are the advantages of AO over Mirroring.I know high availability, more replicas and backup can be taken in secondary as well.

If we have more than 100 databases on...

I think you missed a VERY important type of test in your examples: 1M row inserts at a time, in discreet transactions. Please try that (primarily for the insert to...

sql_novice_2007 (6/8/2015)

---

Hi,

I have a delete trigger on one table. When I delete a single row in this table that deleted record will be recorded to a history table.

But sometimes my...

Glad you liked...

Jason A. Long (6/1/2015)

---

No problem. Thanks for kicking me in the back side to get it done... With the data partition and the select output. 😀

When...