Edward Pochinski

sp_dba_checkblocked fix for sp_NotifyBlock

Problems with error 512 more than 1 result returned due to the operator outside of the query. Found this when tested with multiple blocks going on at once. It worked fine when there was only 1 block. Depending on the type of server there can be a "whole lot of blocking going on "Replaced with […]

2002-01-01

792 reads

OSQL Process Watcher

These 2 files plus sleep.exe (Resource kit) gives an administrator a good view of important blocking statistics in almost a real time fashion. You can use this with profiler to obtain some unique information very fast on a lead blocker if your gathering the right counters in profiler and dumping them in a table and […]

2001-12-10

487 reads

Script to Search SQL Error Log For a String

This script(sproc)uses xp_cmdshell from sql and FINDSTR from DOS to search the current errorlog for a specific string such as kernel or failed login. Compile this in the master db and if you do not pass an input parameter a example usage will display for you. ex: sp_dba_sqlerrorlog kernel Edward J Pochinski III

4 (1)

2001-08-13

1,842 reads

Blogs

Daily Coping 3 Jun 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...

Lock your Azure SQL Database

By

So you have many databases in Azure, you accidentally deleted one which can happen...

BlitzFileStats custom module available for Inspector V2

By

BlitzFileStats is the latest addition to our custom module collection for reporting on data...

Read the latest Blogs

Forums

Changing Connection Managers with the Configuration Manager

By Thom A

OK, this actually not a question, this is in response to a question I...

SSIS How to split a single string into multiple columns using Derived Column

By sabarishbabu

Hello, In my source Column having comma separated with text qualifier(“), I would need...

Licensing Audit Advice

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Licensing Audit Advice

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers