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

794 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

498 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,856 reads

Blogs

Daily Coping 14 May 2021

By

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

WIT Mental Health and Wellness Videos Posted

By

I was honored to speak at the WIT Mental Health and Wellness day last...

Daily Coping 13 May 2021

By

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

Read the latest Blogs

Forums

unable to deploy package unable integration service catalog

By atulyan.aries

Hi I get teh following error while deploying package .NET Framework error occurred during...

Limit database restores to specific drive locations

By DrJogalog

As there isn't an option to use a DDL trigger on a RESTORE query,...

VLOOKUP Equivalent in SQL

By Sarah1997

Hi there I have two tables, one with an ID and Amount (Table 1)...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Container Logs

See possible answers