2012-08-03 (first published: 2008-01-09)
2,335 reads
Scripts
2012-08-01 (first published: 2008-02-15)
3,235 reads
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,391 reads
2012-07-25 (first published: 2012-07-12)
2,529 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,444 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,200 reads
2012-07-17 (first published: 2007-11-21)
2,266 reads
Blogs
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
Forums
Alamat Kantor BCA KCP Fatmawati Telp:0821-8200-203
Telp/WA 62 8218200203 Jl. Komp. Rs. Fatmawati No.1, RT.1/RW.9, Cilandak Bar., Kec. Cilandak, Kota...
Alamat BCA KCP Gatot Subroto Telp:0821-8200-233
Telp/WA 62 8218200233 Centennial Tower, Jl. Gatot Subroto No.Kav 24-25 Lt GF unit C,...
Alamat BCA KCP Warung Buncit Telp:0821-8200-174
Telp/WA 62 8218200174 Gedung Multika, Jl. Mampang Prpt. Raya No.71-73, RT.1/RW.1, Tegal Parang, Kec....
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers