Quick SQL connection and process details with current SQL - Version2
Quick check SQL connection and process details with current SQL text
2018-12-06 (first published: 2018-11-27)
1,011 reads
Quick check SQL connection and process details with current SQL text
2018-12-06 (first published: 2018-11-27)
1,011 reads
Get backup status email daily to your inbox in HTML format.
2013-03-27 (first published: 2013-03-14)
2,429 reads
This script will be useful to quickly check incase of any blocking or log wait occurs
2011-12-30 (first published: 2011-12-05)
1,550 reads
This script can be used to generate alter column length of any string data type column(s) in a database.
2011-12-27 (first published: 2011-11-22)
1,281 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