2012-02-02 (first published: 2012-01-20)
3,955 reads
2012-02-02 (first published: 2012-01-20)
3,955 reads
2012-02-01 (first published: 2012-01-20)
2,229 reads
2012-01-30 (first published: 2011-12-23)
898 reads
Use this script to calculate MAX memory setting on a dedicated SQL server.
2012-01-27 (first published: 2011-12-14)
3,525 reads
2012-01-25 (first published: 2011-12-15)
1,222 reads
find and replace text in a text file using tsql
2012-01-23 (first published: 2011-12-16)
3,158 reads
2012-01-20 (first published: 2011-12-16)
1,040 reads
will create jobs script for backup or DR purposes to install on another server.
2012-01-18 (first published: 2011-12-15)
2,203 reads
This script will backup your files that have changed only. old files will not be copied just newer ones.
2012-01-17 (first published: 2011-09-20)
748 reads
Do you know what happens if a holiday falls on a weekend? This script will help you.
2012-01-16 (first published: 2011-12-14)
3,122 reads
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