Function to display integer as binary string
This function converts an integer to its binary representation. e.g. 15 is converted to '00001111'
2015-04-29 (first published: 2014-02-24)
844 reads
This function converts an integer to its binary representation. e.g. 15 is converted to '00001111'
2015-04-29 (first published: 2014-02-24)
844 reads
This function counts the number of 1's in the binary representation of an integer.
2015-04-28 (first published: 2014-02-24)
1,002 reads
Extract default & Named Instance from @@servername.
Print all characters before and after \ to find default and named instance name.
2015-04-27 (first published: 2015-04-15)
1,174 reads
2015-04-24 (first published: 2015-04-15)
1,226 reads
Check Status of a database. It will loop through all databases and will print message if the db is present.
2015-04-21 (first published: 2015-04-10)
1,346 reads
READ Data from default Trace to know when the objects are altered. If no database name is provided, it will run through all the databases.
2015-04-17 (first published: 2015-04-08)
1,443 reads
This script helps to identify which database/log takes most of the disk space and how much is free.
2015-04-15 (first published: 2013-06-18)
3,031 reads
Sometimes running DBCC CHECKDB WITH DATA_PURITY returns thousands of affected columns. This script automates the identification of those columns.
2015-04-13 (first published: 2013-07-04)
2,461 reads
Find any code objects that interact with a given table/view, or call another given code object.
2015-04-10 (first published: 2013-07-05)
4,657 reads
A stored procedure that will parse (shred) the contents of any well-formed XML document into a SQL table.
2015-04-08 (first published: 2013-07-09)
5,263 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...
Komplek Ruko Roxy Mas, Jl. Kh Hasyim Ashari No.6 Blok C.5 No, RT.6/RW.8, Cideng,...
Jl. Gajah Mada No.203 205, RW.207, Benua Melayu Darat, Kec. Pontianak Sel., Kota Pontianak,...
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