An inline table-valued function (iTVF) that will produce a virtual tally table on-the-fly. The function creates a tally table of any size with user-defined lower and upper bounds.
2014-09-08 (first published: 2013-06-28)
2,278 reads
Calculate gregorian easter sunday using a table valued function.
2014-09-03 (first published: 2014-08-22)
697 reads
PowerShell script to check last full backup, transaction log backup date for SQL Server databases.
2014-09-02 (first published: 2014-08-22)
1,811 reads
Generate Script All Table and Specific Table By Using SMO C#
2014-09-01 (first published: 2014-08-07)
5,766 reads
a script to import all database sizes from a list of servers into a table using powershell for trending purposes
YOU MUST DOWNLOAD CODEPLEX SQL SERVER MODULE FOR THIS TO WORK.
2014-08-29 (first published: 2012-05-23)
3,304 reads
This Powershell script calls a stored procedure and exports the results to a CSV file
2014-08-28 (first published: 2013-01-03)
5,097 reads
PowerShell script to SlipStream SQL Server 2008 installer with SPx patch.
2014-08-27 (first published: 2013-04-18)
1,212 reads
Find all storage including mount points and show' free and used available. Needs powershell.
2014-08-25 (first published: 2011-12-15)
1,408 reads
Script to restore the entire databases from the backup directory just by passing the backup directory.
2014-08-22 (first published: 2014-02-25)
3,330 reads
I was having a hard time to reading the Windows 2012 R2 Failover cluster log from my live server. That is why I just wrote a simple PowerShell script to get the job done for me.
2014-08-21 (first published: 2014-07-29)
1,758 reads
By Steve Jones
I use ConEmu for my terminal interface. I’m still on Windows 10 at home,...
Creating a Fabric workspace takes about 30 seconds. Restructuring workspaces after people have built...
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
Comments posted to this topic are about the item Adding new column with DEFAULT...
Comments posted to this topic are about the item Advanced Deployment Scenarios: Stairway to...
Comments posted to this topic are about the item You Need a DBA Pipeline
Which number did the two COUNT(*) return:
DROP TABLE IF EXISTS #tmp CREATE TABLE #tmp (id INT NOT NULL) INSERT INTO #tmp (id) SELECT gs.value FROM GENERATE_SERIES(1, 5) AS gs ALTER TABLE #tmp ADD my_value INT NOT NULL CONSTRAINT df_tmp_my_value DEFAULT 1 SELECT COUNT(*) FROM #tmp AS t WHERE my_value = 1 ALTER TABLE #tmp DROP CONSTRAINT df_tmp_my_value ALTER TABLE #tmp ADD CONSTRAINT df_tmp_my_value DEFAULT 2 FOR my_value SELECT COUNT(*) FROM #tmp AS t WHERE my_value = 1See possible answers