This will show the fragmentation and stats before and after a reindex of a specified table. Run in the context for the db that holds the table the proc will get passed and re-index. Complile in master since the master is checked first for any SP that is prefixed with SP_ and you can call […]
2001-08-13
3,944 reads
By Angela-Henry
In this month’s (October 2019) release of Power BI Desktop, they have added a...
By Devin-Knight
In this month’s Power BI Digest with Manuel Quintana [Blog | Twitter] and I...
If you’ve been reading these Database Fundamentals posts, you’ve already seen the WHERE clause...
Comments posted to this topic are about the item More Network Restrictions, which is...
No much activity on the server and CPU usage is not dropping to normal...
Ask SSC