Gail Shaw

Forum Replies Created

Viewing 15 posts - 3,796 through 3,810 (of 49,552 total)

RE: My db sql server fix

Year old thread. Probably fixed one way or another by now.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

January 20, 2016 at 2:34 am

#1853057
RE: See the size of tables using t-sql

sp_spaceused 'TableName'
or query sys.dm_db_index_physical_stats
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

January 20, 2016 at 1:56 am

#1853050
RE: Extracting tables from SPs

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....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

January 20, 2016 at 12:48 am

#1853043
RE: Extracting tables from SPs

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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

January 19, 2016 at 2:30 pm

#1852957
RE: Are the posted questions getting worse?

*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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

January 19, 2016 at 2:26 pm

#1852956
RE: Stretch DB question

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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

January 19, 2016 at 2:20 pm

#1852955
RE: AlwaysOn - Read Only Replica's

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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

January 19, 2016 at 1:48 pm

#1852942
RE: AlwaysOn - Read Only Replica's

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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

January 19, 2016 at 1:33 pm

#1852937
RE: Stretch DB question

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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

January 19, 2016 at 1:09 pm

#1852926
RE: AlwaysOn - Read Only Replica's

curious_sqldba (1/19/2016)
GilaMonster (1/19/2016)
curious_sqldba (1/19/2016)
When i connect to listener even using the added option i still connect to primary, i was hoping to connect to secondary.
Are you specifying the database name...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

January 19, 2016 at 12:57 pm

#1852924
RE: AlwaysOn - Read Only Replica's

curious_sqldba (1/19/2016)
When i connect to listener even using the added option i still connect to primary, i was hoping to connect to secondary.
Are you specifying the database name in the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

January 19, 2016 at 12:45 pm

#1852915
RE: AlwaysOn - Read Only Replica's

krypto69 (1/19/2016)
You can execute queries directly to the listener DB.
For example we have three nodes NODEA, NODEB, NODEC. NODEB & NODEC are both listeners.
The listener is not...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

January 19, 2016 at 12:45 pm

#1852914
RE: Slow running query

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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

January 19, 2016 at 10:10 am

#1852839
RE: Slow running query

Sean Lange (1/19/2016)
Can you post the actual execution plan instead of the excel version?
SQL 2000.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

January 19, 2016 at 10:07 am

#1852836
RE: AlwaysOn - Read Only Replica's

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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass

January 19, 2016 at 8:44 am

#1852808

Viewing 15 posts - 3,796 through 3,810 (of 49,552 total)