An Informal Look at Database Performance
A review on the basic steps to correct a poorly performing query
2010-09-08
12,474 reads
Timothy A Wiseman
- Interests: SQL Server, Python, Go, Mathematics, Legal Issues
Going From Many Schemas To One Schema
A Technique to deal with moving data from multiple schemas into one table
2010-08-09
6,395 reads
Undocumented Extended and Stored Procedures
Some useful undocumented extended and stored procedures in SQL Server 2005
2009-11-20 (first published: 2008-05-09)
33,407 reads
2009-01-17 (first published: 2008-05-28)
4,199 reads
2008-12-02
9,120 reads
2008-10-23 (first published: 2008-08-24)
1,912 reads
2008-09-09
12,781 reads
CTEs in Report Creation
A discussion on using CTEs to speed the development and maintenance of reports and enhance readability.
2008-03-31
6,156 reads
Reading Ad Hoc Text Files with OpenDataSource
Discusses the techniques and reasons to use opendatasource for reading text files in SQL Server 2005.
2007-12-13
10,366 reads
Blogs
More fun with Git: git restore
The setup My day job involves babysitting a lot of Git repositories hosted on...
When the Internet Stumbles: Lessons from Cloudflare & Azure Front Door Outages
By John
Recently, the world was reminded of just how fragile the internet can be. Two...
Prepping for Certification, Part 4 of 4
By Brian Kelley
In Parts 1-3, I covered how I prepare for a certification exam. In this...
Forums
Catalog max connection pool size: 100
Seeing this message repeated every 10 seconds in the RSHostingService_yyyy_mm_dd_hh_mm_ss.log file. Can anyone advise:...
CAST datetimeoffset(7) as a datetime in UK format
I have a view where I am casting a datetimeoffset(7) field to smalldatetime or...
what are the downsides of TDE not running vs running?
hi for the 2 years i've been here I believe we've had "encryption" turned...
Question of the Day
Putting the Player with the Number
In SQL Server 2025, what does this return?
DECLARE @player varchar(20) = 'Bo Nix', @num VARCHAR = '10' SELECT @player || @numSee possible answers