A Script A Day - Day 7 - Memory Queries
Today's script is a collection of a few memory queries I've collected from various sources over the years. These queries are by no...
2012-02-07
2,349 reads
Today's script is a collection of a few memory queries I've collected from various sources over the years. These queries are by no...
2012-02-07
2,349 reads
Today's Script will drop all database snapshots and create a database snapshot for all online read writeable user databases. I...
2012-02-06
3,909 reads
Today's script will list all principals with membership in the db_owner fixed database role.
/* ----------------------------------------------------------------- Database Owner Permissions ----------------------------------------------------------------- For more SQL resources, check...
2012-02-05
1,141 reads
Today's script allows you to keep track of how long left a statement has before it completes. I find this useful...
2012-02-04
496 reads
Today's script is a template I use for the occasions when a data edit is required to be run against...
2012-02-03
577 reads
Today's script is a collection of simple queries I have saved for a time when I need to troubleshoot database...
2012-02-02
494 reads
Today is the 1st February 2012 and as promised here is the first of script in my "A Script A Day"...
2012-02-01
590 reads
I had an interesting phone call this morning from our professional services team. They are carrying out what I can...
2012-01-26
622 reads
We as DBA’s face an ever growing list of things to do and services to support. We work in high...
2012-01-25
601 reads
In February I will be starting a series of Blog Posts I'm calling a "A Script a Day". Each day...
2012-01-24
627 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