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)
15,230 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,703 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,663 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,136 reads
Blogs
PASS Data Community Summit 2026
By Steve Jones
Yesterday was the first day of sessions at the PASS Data Community Summit (after...
T-SQLTuesday 204: Are blogs still relevant?
This month’s blogging party is hosted by Jeff Ianucci – his challenge is to...
Are Blogs Still Relevant? I Think They Still Are.
As for me, I'll keep writing whenever time permits. I don't expect every post...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Switching Schemas I
Comments posted to this topic are about the item Switching Schemas I
Enforcing Unique Customer Emails When Duplicates Already Exist
Comments posted to this topic are about the item Enforcing Unique Customer Emails When...
Question of the Day
Switching Schemas I
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get one row back for an object named dbo.beer. There is an ETL schema and both of these are nonpartitioned tables. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers