2014-07-01
4,795 reads
kill
Killing User Connection(session) connected to the Database.
The script will be helpful to kill all the user sessions before performing the refresh of the database.
2011-04-08 (first published: 2011-03-29)
2,527 reads
Blogs
Daily Coping 18 Sep 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Optimize for Unknown for Inline Table-Valued Functions
I had a curious performance issue today. An inline table-valued function (iTVF) was performing...
Daily Coping 17 Sep 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Number weeks from April to September for every year
I want to number weeks from April to September for every year, such that...
Index Fragmentation
I am looking into fragmentation in one of my databases and ran across these...
SSIS package with Multiple Streams
I have a package with has multiple streams and calls the same SP. Why...
Ask SSC