Return Query Text Along With sp_who2 Using Dynamic Management Views
This article describes how to generate the sp_who2 results including the query text for the spid.
2008-06-26
23,127 reads
Articles
SQL Know How
Training in the UK this fall from a variety of SQL Server experts. If you are in the area, I'd recommend one of these classes.
2008-06-26 (first published: 2008-06-19)
2,639 reads
Check your SQL Server using Windows PowerShell – Part 1
This new series examines methods and procedures to check the status of the Operating system, SQL Server instances and databases, using Windows PowerShell. Part One illustrates how to create a PowerShell script to ping the host machine and how to source the PowerShell function and call the function.
2008-06-26
4,215 reads
The Multiple Instance Dilemna
SQL Servers seem to proliferate in many companies, making management a headache for DBAs. Steve Jones asks a Friday poll about how you handle all those service account.
2008-06-26
44 reads
The Multiple Instance Dilemna
SQL Servers seem to proliferate in many companies, making management a headache for DBAs. Steve Jones asks a Friday poll about how you handle all those service account.
2008-06-26
42 reads
The Multiple Instance Dilemna
SQL Servers seem to proliferate in many companies, making management a headache for DBAs. Steve Jones asks a Friday poll about how you handle all those service account.
2008-06-26
50 reads
Email reports directly to the hands of your Executives
Generate formatted reports specifically for executives using PDA devices.
2008-06-25
8,861 reads
Create a computed column in SQL Server using XML data
Create a computed column in SQL Server using XML data and optimize SQL queries. Learn how to create a function for XQuery and use it within the computed column formula.
2008-06-25
3,199 reads
Taming Trees: B-Trees
Learn how to build a B-tree similar to those used by databases to implement indexes.
2008-06-25
3,117 reads
2008-06-25
42 reads
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
How do I connect to a SQL Server database on my ISP?
I've got a web application for my side business. I've added a SQL Server...
Looking for New Blood
Comments posted to this topic are about the item Looking for New Blood
Server-Level Row Counts for Tables and Views
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers