In this sequel to his first "Hierarchies on Steroids" article, SQL Server MVP Jeff Moden shows us how to build a pre-aggregated table that will answer most of the questions that you could ask of a typical hierarchy. Any bets on whether Santa is packin’ a Tally Table in his bag or not?
2012-11-15
15,365 reads
SQL Server MVP Jeff Moden shows us a new very high performance method to convert an "Adjacency List" to “Nested Sets” on a million node hierarchy in less than a minute and 100,000 nodes in just seconds. Not surprisingly, the "steroids" come in a bottle labeled "Tally Table".
2014-09-19 (first published: 2012-11-13)
32,396 reads
chris's idea is probably the simplest. Not sure this will get you what you want (multiple result sets), but there isn't an easy way to do that. Could insert the values into a temp table and then select them all out of there at the end.create table #mytemp( tablename, id, datumarchief)exec sp_msforeachtable 'insert #mytemp select […]
2004-01-13
Write a script to delete the account or change to deny access in 10 days and schedule it.
2004-01-13
Yes there is a way to create a stored from from an another SP create proc sp1 as declare @str varchar(1000) set @str = 'create proc sp2 as select * from t' exec (@str) go
2004-01-11
1 reads
Thanks for your postingWe have corrected the errors noticed K. Brian Kelley. We hope, that the given site will be useful not only to Russian-speaking users.Oleg V. Lysenko
2004-01-11
1 reads
Thanks Thomas, I couldn't find syjobexecute, but I succesfully used:linkedserver.Master.dbo.sp_ExecuteSQL N'EXEC msdb.dbo.sp_start_job @job_name = "Test Job"'Andy
2004-01-08
2 reads
As a Software Engineer, I would like to replicate a copy of my database...
I have heard about many interesting things about programming in Rust and I decided...
A recent Microsoft outage caused by a bad patch pushed out to Windows instances...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers