Exporting Stored Procedure Results to a Table
A quick trick from Pamela Mooney for getting results from a proc into a table.
2020-11-26 (first published: 2019-06-24)
14,219 reads
Pamela Mooney
Let’s Start with Architecture
In this article, we look at the conceptual design for gathering information about your servers to better understand how they are performing.
2019-08-22
3,654 reads
How Often Do You Give Your Server a Physical?
The start of a new series that looks at examining your servers and keeping track of their health.
2019-08-15
2,593 reads
How to Unclog SQL Server
In this article, learn how one DBA solved a query timeout issue with an application by examining the effects that different temporary objects have on query performance.
2019-08-01
11,073 reads
Blogs
Understanding Zonal Redundancy in Azure SQL MI
By Arun Sirpal
Do you know what happens when you enable zonal redundancy for your SQL managed...
SQL Server Database Compatibility Levels
By Kevin3NF
Why You Shouldn’t Overlook This Quiet but Critical SQL Server Setting If you’ve...
The PASS Summit on Tour in the Netherlands
By Steve Jones
The PASS Summit goes on tour this year, with the final date the first...
Forums
How a Legacy Logic Choked SQL Server in a 30-Year-Old Factory
Comments posted to this topic are about the item How a Legacy Logic Choked...
Top Quality Boomerang Booth Rental for Corporate Events
Make your corporate events more engaging with a fun twist. Our booths capture energetic...
How do I make this one row per id
I've written this code, but it is showing right now as 2 rows per...
Question of the Day
The Updated Columns List
I have this table in SQL Server 2022:
CREATE TABLE CustomerLarge (CustomerID INT NOT NULL IDENTITY(1, 1) CONSTRAINT CustomerLargePK PRIMARY KEY CLUSTERED , CustomerName VARCHAR(20) , CustomerContactFirstName VARCHAR(40) , CustomerContactLastName VARCHAR(40) , Address VARCHAR(20) , Address2 VARCHAR(20) , City VARCHAR(20) , CountryCode CHAR(3) , Postal VARCHAR(20) ) GOIf I check the columns_updated() function return in a trigger, what is the data returned? See possible answers