2018-05-30 (first published: 2018-01-03)
2,556 reads
2018-05-30 (first published: 2018-01-03)
2,556 reads
2018-05-02 (first published: 2018-04-17)
1,086 reads
2018-05-01 (first published: 2018-04-20)
1,232 reads
Code to create a handy date calendar cross-reference table with a ton of pre-populated, slice-and-dice data field variations to aid in complex date parameterization / selection criteria.
2018-04-26 (first published: 2009-10-06)
17,084 reads
Script out EXISTING database mail profile settings
2018-04-25 (first published: 2018-04-23)
36,342 reads
Generate large sample data for your performance and other uses
2018-04-24 (first published: 2018-04-18)
3,139 reads
Update the statistics starting from most accessed and modified ones, with a time limit. Procedure will exit when @MaxExecutionTime parameter is greater than the current execution time.
2018-04-19 (first published: 2018-04-16)
551 reads
2018-04-18 (first published: 2018-04-12)
4,406 reads
This script is used to Find out the table name and column name where a specific string has been used
2018-04-17 (first published: 2018-04-13)
2,374 reads
Script powershell/SMO que gera os scripts de DROP/CREATE para cada JOB existente na instância
2018-04-16 (first published: 2018-04-13)
665 reads
Recently, in an attempt to thwart leechers (1990s kids will know), I added some...
Once upon a time I had a series about some cool stuff in Snowflake:...
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
Comments posted to this topic are about the item Adding Bits II
Comments posted to this topic are about the item An Unlimited Token Budget
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, true)
GO
See possible answers