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
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
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