How to Extract last name or first name(s) from a combined field
Extracting pieces of information from a string can be a daunting task. This is an example of a REVERSE technique.
The...
2018-05-19
1,383 reads
Extracting pieces of information from a string can be a daunting task. This is an example of a REVERSE technique.
The...
2018-05-19
1,383 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,160 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
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...
Telp/Wa 62817825533 Jl. Cempaka No.17, Sukorejo, Kec. Sukorejo, Kota Blitar, Jawa Timur 66111
Telp/Wa 628217555651 Jl. Gajah Mada No.14-18, Kelurahan Jember Kidu, Jember Kidul, Kec. Kaliwates, Kabupaten...
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