Year old thread. Probably fixed one way or another by now.

sp_spaceused 'TableName'

or query sys.dm_db_index_physical_stats

spaghettidba (1/19/2016)

---

GilaMonster (1/19/2016)

---

dm_sql_referenced_entities is 2008 and above. sys.sql_dependencies can be inaccurate, as procedures can be created before the tables they reference, if they are the dependency info won't be there....

dm_sql_referenced_entities is 2008 and above. sys.sql_dependencies can be inaccurate, as procedures can be created before the tables they reference, if they are the dependency info won't be there. No good...

*sigh* All but one comment on a blog post are of the form 'Did you try X?' 'Have you compared Y?' 'Probably should have a test with Z'

*NO. If I...

Partitioning. Stretch is kinda 'automatic partitioning', so you can partition the table, switch out older data (partition at a time) into a standalone table. Once it's not in the main...

Perry Whittle (1/19/2016)

---

An availability group may have multiple databases, you need to specify the listener name, database name and readonly intent option, then (if routing is correctly configured) you'll be...

I'm going to assume the answer to the question you keep ignoring is 'No', in which case Perry explained above why you're not seeing the read-only routing

Are you specifying the...

I highly doubt it, and besides, there wouldn't be much point.

Stretch is so that you can move older (less used) rows out to cloud storage to reduce the storage you...

curious_sqldba (1/19/2016)

---

GilaMonster (1/19/2016)

---

Are you specifying the database name...

Are you specifying the database name in the...

The listener is not...

EasyBoy (1/19/2016)

---

Sean Lange (1/19/2016)

---

Can you post the actual execution plan instead of the excel version? It shows a lot more detail which helps with the insight as to what can...

SQL 2000.

The only queries which go to read only replicas are ones that are run on connections which were made with the ReadOnlyIntent option in the connection string. If you do...