Paginating a SQL query result set
How to Paginate a query result set to keep from pulling the whole result set to the client side
2015-11-02 (first published: 2014-05-05)
3,725 reads
Scripts
Security Queries: Database-level
A set of queries which attempt to gather as much security-related information on a single database as possible.
2015-10-30 (first published: 2013-10-24)
5,727 reads
List of Stored Procedures modified in past 7 days
Provide list of Stored Procedures that have been changed in past 7 days.
2015-10-29 (first published: 2013-04-11)
3,594 reads
2015-10-27 (first published: 2014-07-08)
4,408 reads
2015-10-23 (first published: 2014-05-13)
3,743 reads
Calculating Working Hours
Calculating working hours can be painful due to all the variances that they imply. This function will calculate working hours between 2 dates which might include time. There's an option to use a holidays table that will vary in each environment.
2015-10-22 (first published: 2014-05-22)
3,752 reads
2015-10-21 (first published: 2013-12-26)
4,067 reads
What's changed recently?
Often when tracking down problems, you need to know if anything has changed recently, this script will tell you...
2015-10-20 (first published: 2013-05-30)
3,944 reads
2015-10-19 (first published: 2013-08-30)
4,395 reads
2015-10-16 (first published: 2013-05-30)
5,749 reads
Blogs
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Forums
BCA KCU PANTAI INDAH KAPUK 083178278662?
ALAMAT WHATSAPP:083178278662 Jl. Pantai Indah Kapuk Utara I Blok F, RT.6/RW.2, Kamal Muara, Kecamatan...
Kontak BCA KCP Citra Raya [083178278662]
ALAMAT : Perumahan Citra Raya Blok KD.02 No. 10, 15, RW.Mardigrass, Mekar Bakti, Kec....
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers