Kill SPIDs through automated job(while restore)
Here's a script, for killing a SPIDs against a particular database, here am using BIN as the database.
2016-12-02 (first published: 2008-07-17)
1,807 reads
Here's a script, for killing a SPIDs against a particular database, here am using BIN as the database.
2016-12-02 (first published: 2008-07-17)
1,807 reads
We have a new author at SQLServerCentral.com, Muthusamy Anantha Kumar AKA The MAK, who starts a new series on the basics that a DBA needs to know. This installment walks over basic backup and restore.
2008-07-15
13,182 reads
To find a list of Tables (User or System tables)according to their size.
2013-01-02 (first published: 2008-07-10)
4,305 reads
2009-05-26 (first published: 2008-07-09)
838 reads
Find every object in every database owned by a particular Login.
2011-09-27 (first published: 2008-07-07)
11,335 reads
2008-08-27 (first published: 2008-07-03)
2,189 reads
2008-07-02
5,331 reads
This article describes how to generate the sp_who2 results including the query text for the spid.
2008-06-26
23,027 reads
2008-06-25
4,174 reads
2008-06-24
4,225 reads
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
By ChrisJenkins
Have you been thinking about migrating your reporting to Microsoft Fabric or Snowflake but...
The Joyful Craftsmen has become the new owner of Revolt BI. The merger creates...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
WhatsApp:0821-8154-398 Area Street Festival, Ruko No 1 & 1A, CBD, Jl. Galuh Mas Raya,...
WhatsApp:0821-8154-398 Wisma BCA Pd. Indah, Jl. Metro Pondok Indah No.10, RT.3/RW.17, Pd. Pinang, Kec....
I have this code on SQL Server 2022. What happens when it runs all at once?
DROP TABLE IF EXISTS dbo.Commission GO CREATE TABLE dbo.Commission (id INT NOT NULL IDENTITY(1,1) CONSTRAINT CommissionPK PRIMARY KEY , salesperson VARCHAR(20) , commission VARCHAR(20) ) GO INSERT dbo.Commission ( salesperson, commission) VALUES ( 'Brian', 12 ), ( 'Brian', 'None' ) GOSee possible answers