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)
12,261 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,549 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,571 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,021 reads
Blogs
Daily Coping 27 Jan 2023
By Steve Jones
Today’s coping tip is to try something new to get out of your comfort...
Things to look out for while TDE is encrypting existing data
Monitoring for Problems The encryption of your existing data occurs as a background process...
Daily Coping 26 Jan 2023
By Steve Jones
Today’s coping tip is to focus on what’s good, even if today feels tough....
Forums
View Or Stored Procedure
Please see my DDL. I would like to create: a) Dimensional table that tracks Primary...
Context_Info across databases
I have a stored procedure that works across databases. So the "integration" database will...
Interview Question
Hi Team , Today i had an interview call. there was a question asked...
Ask SSC