Back to basics: What is a HEAP table?
Understanding the fundamentals is key for success, with everything you do. These days SQL Server has expanded into much more...
2018-05-24 (first published: 2018-05-16)
5,785 reads
Understanding the fundamentals is key for success, with everything you do. These days SQL Server has expanded into much more...
2018-05-24 (first published: 2018-05-16)
5,785 reads
One of the things that you will no doubt end up experiencing as a DBA is that you will see...
2018-05-16
2,075 reads
Cosmos DB is one of the fastest growing Azure services in 2018. As its popularity grows, data professionals are faced...
2018-05-24 (first published: 2018-05-16)
2,876 reads
Previously we looked at four built-in functions to get the current date and time in SQL Server and Azure SQL...
2018-05-23 (first published: 2018-05-16)
3,898 reads
About 3 weeks ago I presented a free webinar for Pragmatic Works where I talked about Azure Data Factory V2. You can watch the recording here if you missed...
2018-05-16
29 reads
About 3 weeks ago I presented a free webinar for Pragmatic Works where I talked about Azure Data Factory V2....
2018-05-16
389 reads
We had an AMAZING talk with Kalen Delaney – wait, you do know who Kalen is, don’t you? Rightfully, @SQLQueen on Twitter. Over 30 years...
2018-05-16
366 reads
Impersonation is a highly useful tool in your toolbox. With the EXECUTE AS clause you can allow your stored procedure...
2018-05-16
403 reads
MySQL user format it as ‘User_name’@’hostname’ To create the user account use following syntax: CREATE USER ‘User_name’@’Host_name’ IDENTIFIED BY <Pwd>;...
2018-05-16
231 reads
Statistics are a vital part of SQL Server database engine, these are used for the query optimizer to create query...
2018-05-16
145 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