2005 Online Index Rebuild using DMV
Identifies indexes with average logical fragmentation >= 30% using the DM available in MSSQL 2005. Please refer to script for more information.
2012-07-31 (first published: 2007-10-09)
4,388 reads
Scripts
2012-07-25 (first published: 2012-07-12)
2,527 reads
Finding Unused Database Roles
This is a data quality script that locates unused Database Roles for maintenance purposes
2012-07-24 (first published: 2012-07-05)
1,442 reads
BusinessDaysToCalendarDays (For Unusual Business Weeks)
Tells how many calendar days are needed to complete a number of bussines days starting in a defined day of the week.
2012-07-23 (first published: 2012-07-04)
758 reads
BussinesDaysToCalendarDays
Tells how many calendar days are needed to complete a number of bussines days starting in a specified week day. Any comments? Let me know =D.
2012-07-20 (first published: 2012-07-04)
853 reads
get all values separated by commas
How to get all values separated by commas, with only a SELECT query and a variable.
2012-07-19 (first published: 2012-07-03)
2,255 reads
2012-07-18 (first published: 2008-01-25)
2,198 reads
2012-07-17 (first published: 2007-11-21)
2,266 reads
Function to Split Multivalued Parameter
This Function is written to split Multivalued Parameter passed by Reporting Services 2005.
2012-07-16 (first published: 2007-08-01)
2,808 reads
2012-07-13 (first published: 2008-03-20)
2,226 reads
Blogs
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers