2017-03-21 (first published: 2017-03-15)
524 reads
2017-03-21 (first published: 2017-03-15)
524 reads
Return values from MongoDB on Linux server with Powershell
2017-03-20 (first published: 2017-03-16)
1,222 reads
This script will show you all the tables that are being published with sizes.
2017-03-16 (first published: 2017-03-13)
3,601 reads
2017-03-08 (first published: 2017-02-16)
2,131 reads
2017-03-07 (first published: 2017-03-01)
1,301 reads
This trigger will send mail notification once a row is written in the suspect pages table
2017-03-03 (first published: 2017-02-21)
546 reads
This script will list all missing indexes with create statements.
2017-03-01 (first published: 2017-02-24)
1,365 reads
2017-02-28 (first published: 2015-06-22)
2,133 reads
This script serves to display the content of the waiting resource. It is divided in two parts. In first one I'm using t-sql, and in second one I accomplished the same task using SQLCRL.
2017-02-27 (first published: 2017-02-21)
1,363 reads
The code works well for an automation process that needs to have xp_cmdhsell turned on.
2017-02-22 (first published: 2017-02-13)
1,752 reads
Recently, in an attempt to thwart leechers (1990s kids will know), I added some...
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...
Jl. Jend. Sudirman No.79-81, Kejuron, Kec. Taman, Kota Madiun, Jawa Timur 63132.. Fungsi Layanan:...
Call Cs 08218200233 Jl. Borobudur No.I, RT.03/RW.07, Mojolangu, Kec. Lowokwaru, Kota Malang, Jawa Timur...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
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