SQL Query Experiment - "WHERE" & "ON"
Sometimes the mistakes you make in the coding lead you to a better understanding of a particular concept.
This happened recently...
2017-11-14 (first published: 2017-11-02)
4,833 reads
Sometimes the mistakes you make in the coding lead you to a better understanding of a particular concept.
This happened recently...
2017-11-14 (first published: 2017-11-02)
4,833 reads
Today's post is in regards a feature that was released with SQL Server 2012, it hasn't gotten the attention or used that it deserves even when it helps solving...
2017-11-02
50 reads
Today's post is in regards a feature that was released with SQL Server 2012, it hasn't gotten the attention or...
2017-11-01
560 reads
I’m a big fan of using queries based on the dynamic management view sys.dm_exec_query_stats to capture the most resource hungry...
2017-11-13 (first published: 2017-11-01)
5,297 reads
SQLCMD variables can be a useful way of having changeable parameters for your SQL scripts, allowing you to specify the...
2017-11-01
10,682 reads
External USB drives should be safely detached from Windows instead of just unplugging them from the computer. Most of us...
2017-11-01
418 reads
Whee! It’s the first day of the main SQL PASS Summit conference and I made it to the keynote early for the first time ever. The hype says we’re going...
2017-11-01
29 reads
I have a favourite new feature of SQL Server Management Studio 17.3 (SSMS), and that’s XE Profiler, which allows you to...
2017-11-01
504 reads
In this module you will learn how to use the Enlighten Stack Shuffle Custom Visual. The Enlighten Stack Shuffle is...
2017-11-14 (first published: 2017-11-01)
1,984 reads
I used to be on the fence regarding whether or not Automatic Tuning should be on as the default when...
2017-11-01
393 reads
By James Serra
(This is the third post in a three-part series on how AI is changing...
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
Comments posted to this topic are about the item Pay for Performance, which is...
Jl. A. Yani No.25 B, Dusun Onggoprayan, Kepolorejo, Kec. Magetan, Kabupaten Magetan, Jawa Timur...
9G9F+FFC, Jl. Jend. Sudirman No.79-81, Kejuron, Kec. Taman, Kota Madiun, Jawa Timur 63132
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