Get Set For Speed
Loops are common in application code, but set-based solutions are the way to go with SQL.
2018-02-23 (first published: 2015-12-29)
6,187 reads
Tom Staab
Temporary exclusive database access
This simple script disconnects any other session that is connected to the specified database by temporarily switching the database to single user.
2015-11-20 (first published: 2015-10-25)
876 reads
Blogs
[PowerShell Newbie] Using Start-Transcript
By gbargsley
This week we are going to launch a blog series geared towards folks that...
My Experience on Geeks on Screen with Coffee
Last week on appeared on Geeks on Screen with Coffee which broadcast on YouTube...
Captioning Options for Your Online Conference
Many conferences have moved online this year due to the pandemic, and many attendees...
Forums
Variable Based on Variable in Paginated Report w/ Native Oracle Connection
I have an SSRS paginated report where users need the ability to pick and...
IndicatorsPool events causing memory pressure?
Hi, We are running a system on SQLServer 2017 Enterprise (RTM-CU22) with 839GB of...
Sql Server Specs Question
Hi, I have two different servers that I do a bulk insert on the...
Ask SSC