2011-12-14
386 reads
2011-12-14
386 reads
This terse script shows an easy (but "dirty" - so not advisable for production environments - rather for personal use) way to select data from stored procedure.
2011-12-14 (first published: 2008-03-04)
4,233 reads
This script will generate a restore statement with supporting MOVE operations to a new directory structure.
2011-12-13 (first published: 2008-05-29)
3,939 reads
Reports permissions to three levels: database, schema and table -- in three formats: readable, structured, scripted.
2011-12-12 (first published: 2008-02-22)
3,993 reads
The procedure below deletes all records from the specified database's(except master, model, msdb and tempdb) tables (except those from the schema 'sys').
2011-12-09 (first published: 2008-01-31)
4,274 reads
2011-12-08 (first published: 2011-11-23)
1,170 reads
This script validates the sufficient disk space per drive.
When you'll reach a minimum on a diskdrive, the script will mail all recipients.
2011-12-06 (first published: 2011-10-28)
4,110 reads
2011-12-01 (first published: 2011-11-09)
1,311 reads
This command is the equivalent of the LEFT() function (cumbersome but effective)
2011-11-29 (first published: 2011-11-14)
1,193 reads
ntext, text, and image (Transact-SQL). This script will alter the data type from image to
varbinary(max) which is very much required as the data type is out
of support.
2011-11-28 (first published: 2011-11-14)
895 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