Key Discovery III
Recursively traverse system views to build a Hierarchical Perspective into the database.
Related Posts:
T-SQL Tuesday Participation Over the Years December 19, 2018
T-SQL Tuesday #104: Just Can't Cut That Cord...
2010-02-02
2 reads
Jason Brimhall
Indexes Out the Window II
In Part I, I discussed some of the peculiarities and troubleshooting done in relation to a peculiar execution plan. In...
2010-01-26
839 reads
SQLFool IDX Defrag Scripts
I just found out that Michelle Ufford (@sqlfool) has updated her Index Defrag scripts. Right now she is looking for...
2010-01-26
919 reads
Tweeting – I took the Dive.
In a previous post, I questioned how much Twitter could really do for me. After some comments made, and some...
2010-01-26
601 reads
Indexes Out the Window
I ran into a peculiarly puzzling situation with a query I have been tuning of late. The query runs some...
2010-01-26
1,290 reads
Indexes Out the Window
I ran into a peculiarly puzzling situation with a query I have been tuning of late. The query runs some...
2010-01-23
1,075 reads
PayPeriod Matching
Recently I was asked to alter a report to pull different more meaningful data. The particular report was pulling data...
2010-01-21
992 reads
Tweet, Tweet, Tweetilly Deet
In a day and age when information abounds and social networking is the only way to communicate (a bit of...
2010-01-19
521 reads
Leaving on a Jet Plane
Ok, so it’s not until November – but I am leaving on a Jet Plane nonetheless. It will have been four...
2010-01-18
551 reads
Presentations – Lessons Learned
This will be a very short entry. I just wanted to share a few things I learned very quickly while...
2010-01-15
863 reads
Blogs
How to Run Databases on Kubernetes: An 8-Step Guide
In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...
Episode 11 of Simple Talks: Oracle
By Steve Jones
The 11th episode is now live, recorded a few weeks ago at the PASS...
A New Word: Mornden
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
Forums
What is the best index strategy for a table that gets truncated?
Hi everyone My SSIS package does a bulk insert of csv files into a...
Blob Storage automated downloads
Dipping my toes into the waters of Azure and of course before I get...
Announcing SQL Server 2025
Comments posted to this topic are about the item Announcing SQL Server 2025
Question of the Day
Running Steve's Code
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc]
AS
SELECT Consumer_ID ,
Trend_Category ,
Bit_Trace
FROM NewWorldDB.dbo.MarketTrend;
GO See possible answers