2013-03-26 (first published: 2013-03-15)
837 reads
2013-03-26 (first published: 2013-03-15)
837 reads
Check which transactions are running, query text, percent complete , query_plan, wait_type, and how long they have been running etc. - with one command.
2013-03-25 (first published: 2013-03-15)
2,335 reads
This script is an improvement from my original script entitled "Powershell - Query SQL Servers Operating system details".
2013-03-22 (first published: 2013-02-27)
2,439 reads
2013-03-21 (first published: 2013-02-27)
1,289 reads
2013-03-19 (first published: 2013-03-01)
1,096 reads
This script will allow you to get maximum date associated with tables that contain a certain column.
2013-03-18 (first published: 2013-02-22)
1,204 reads
2013-03-15 (first published: 2013-02-21)
7,948 reads
2013-03-11 (first published: 2013-02-20)
2,227 reads
2013-03-08 (first published: 2009-10-02)
3,422 reads
This script will produce a report on the status of the Always On replication.
2013-03-05 (first published: 2013-02-08)
4,121 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