• Interests: Fantasy, Science Fiction, Horses, Music

Script to output dbcc inputbuffer adding spid info

The following script will allow the user to get information from all spids that have a program name associated with them. That is event info out of dbcc inputbuffer. Additional columns may be added and used in the table through simple modifications of the script. I just found it useful for troubleshooting and setting up […]

2006-10-19 (first published: )

2,149 reads

Blogs

Viewing the Statistics Objects Used to Create an Execution Plan

By

Use trace flag 8666 to view the statistics objects that the optimizer used to...

A Biography Template for New Presenters

By

Presenting is difficult, and you already know that. It is also incredibly rewarding and...

Goal Progress–Feb 2021

By

I set goals at the beginning of the year, and I’m tracking my progress...

Read the latest Blogs

Forums

Problem with creating quri for alocating amount

By Deimos_farm

good day i came a cross of a problem So i have a quri...

Problem with Logic for new column

By kobinarashid

Hi guys, I have the following table DDL/DML CREATE TABLE #DailyOnHandForecast (Id INT, ItemNo_...

pivot on 2 fields

By Bruin

I'm trying to create a query that pivots on 2 fields(entity,channel) and produce a...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers