Helper function to convert binary to decimal and back
In this post you will find two small functions that convert binary value to a decimal one and vice versa.
2018-05-19
448 reads
In this post you will find two small functions that convert binary value to a decimal one and vice versa.
2018-05-19
448 reads
In this article, we shall discuss the importance of understanding the internals of the page restoration for a database administrator. Most...
2018-05-18
378 reads
I’ve started a new series at MSSQLTips.com walking through the various Dynamic Management Objects we have available to us in SQL...
2018-05-18
414 reads
Today's story starts again with a page escalation:
--
We are seeing very high CPU usage on DistServer01. Could you please take...
2018-05-25 (first published: 2018-05-18)
3,159 reads
MySQL is special compare to all the other RDBMs System because of its special architecture, the STORAGE Engine. MySQL has...
2018-05-18
270 reads
This week I had a user come to me asking about how fields were defined on a few tables he was using in writing some reports. Long story short,...
2018-05-18
25 reads
I’ve never spoken in Tennessee. I’ve wanted to visit, but the I’ve only managed to drive through a part of...
2018-05-17
340 reads
So in yesterday’s post we learned that the OpenSSH client is included with the Windows 10, Update 1803! Guess, what else is included in this server, an OpenSSH Server! Yes,...
2018-05-17
38 reads
So in yesterday’s post we learned that the OpenSSH client is included with the Windows 10, Update 1803! Guess, what else...
2018-05-17
2,574 reads
In my last post I covered some basic policy based management examples, in this post I want to cover writing...
2018-05-17
101 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...
This is my late response to T-SQL Tuesday #204. I almost always forget about...
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