Killing A Service Broker SPID
Killing a SPID shouldn’t be complicated. Execute the command KILL [SPID] and that should kill the session. But there are situations...
2018-03-06 (first published: 2018-02-20)
6,096 reads
Killing a SPID shouldn’t be complicated. Execute the command KILL [SPID] and that should kill the session. But there are situations...
2018-03-06 (first published: 2018-02-20)
6,096 reads
Productivity is hard to measure when your work has no definite structure like a typical office job. You may operate...
2018-02-27
458 reads
Database maintenance does not have to be expensive. There are free tools out there that will make your life easier. Of...
2018-02-22 (first published: 2018-02-13)
3,160 reads
Waiting tasks quickly shows you where to look for the bottlenecks. This is only one of the many times that I...
2018-02-14 (first published: 2018-02-06)
2,737 reads
Performance tuning is one of those things that is hard to get right when you do not have an established...
2018-02-08 (first published: 2018-01-30)
3,518 reads
SQL Prompt from Redgate Software is one of the tools that I cannot live without. Well, that’s probably an exaggeration...
2018-02-02 (first published: 2018-01-23)
3,094 reads
Table partitions can bring a lot of benefits to the manageability and performance of your SQL Server – that is if...
2018-01-16
946 reads
My bold learning goals call for adequate preparation and proportionate action. Before plunging into the challenge, I need to get...
2018-01-12 (first published: 2018-01-02)
1,789 reads
Microsoft as a company has entered a new phase of innovation under the leadership of their CEO Satya Nadella. In...
2018-01-09
562 reads
A couple of weeks ago, the SQL Server community had their last T-SQL Tuesday of the year – 97th since 2009...
2017-12-26
746 reads
By Steve Jones
Train employees well enough that they could get another job but treat them well...
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
By Kevin3NF
It’s Not Just Backup / Restore At some point every company faces it: the...
Comments posted to this topic are about the item Create an HTML Report on...
Hi when i think of server hops , i think of how kerberos assists...
Comments posted to this topic are about the item Can/Can't Do/Don't
When I run this code, how many rows are returned?
DECLARE @meals NVARCHAR(1000) = N'夕食昼食朝食' DECLARE @s NVARCHAR(1) = N'食' SELECT value FROM STRING_SPLIT(@meals, @s) GOSee possible answers