Create a Tally or Numbers Table
This creates a Tally or Numbers table which is frequently used to replace loops in code and is much faster than most loops.
2011-11-28 (first published: 2008-03-07)
6,533 reads
Advanced SQL
RE: Procedures Related to BackupSet
If you mean details of a backup then kinda, look the following tables in msdb database.backupmediafamily backupmediaset backupsetbut no SPs other than to delete history and I haven't taken time to build any myself.
2004-03-19
2003-08-29
RE: Comparison of Business Intelligence Strategies between SQL and Oracle
Hello Everybody Dinesh has done a good job in pointing the difference betwwen SQL Server and Oracle in favour of Sql Server.Since this place is only for SQL Server everybody will readily accept this but if you this article in an open place(where both Oracle & SQL Server guys can read) we would see a […]
2003-05-19
RE: Orphaned logins in SQL 2000?
I saw sp_change_users_login in SQL 6.5 BOL as well. Are there any pitfalls in using this with SQL 6.5?! I know using SQL 6.5 (now) itself is a pitfall.. Some of the server I handle are still 6.5 because of the business requirements.... Client comes first... huh!!!
2003-05-06
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers