2017-01-31 (first published: 2017-01-30)
832 reads
2017-01-31 (first published: 2017-01-30)
832 reads
2017-01-30 (first published: 2017-01-26)
19,916 reads
TEMPDB doesn't have to be a black box. Know what objects and processes are causing it to bloat in size.
2017-01-30 (first published: 2016-12-29)
2,302 reads
This script will help you to find out whether a particular id (SQL or Windows ID) is present in the SQL Server
2017-01-26 (first published: 2017-01-24)
674 reads
Decryption Timer to let you know when the removal of encryption for a TDE encrypted database has completed to perform a backup of the data after masking.
2017-01-24 (first published: 2017-01-18)
503 reads
A script to be used as part of development deployments where new databases are required, so as to provide standardisation.
2017-01-23 (first published: 2017-01-18)
525 reads
Use this script to backup databases based on their role in an availability group
2017-01-12 (first published: 2017-01-07)
709 reads
This script will perfrom following tasks :
1. BackUp DB
2. Restore DB from BackUp File
3. Restore DB from DB
4. Create a new DB from Existing Db
It takes care of all the possible failures during these operations, while done manually.
2017-01-11 (first published: 2017-01-09)
1,815 reads
2017-01-10 (first published: 2017-01-05)
979 reads
Finding characters/string before and after some character or pattern
2017-01-06 (first published: 2015-11-09)
267,141 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