and other pointless query rewrites
In a similar vein to last week’s blog post… I heard an interesting comment recently. “Change that Column != 2 to...
2016-02-09
162 reads
In a similar vein to last week’s blog post… I heard an interesting comment recently. “Change that Column != 2 to...
2016-02-09
162 reads
In a similar vein to last week’s blog post… I heard an interesting comment recently. “Change that Column != 2 to...
2016-02-17 (first published: 2016-02-09)
1,939 reads
Update: For the KPI version of this report, please check Power BI KPI Report: Hospital Charge Data
How much hospitals charge...
2016-02-16 (first published: 2016-02-09)
2,224 reads
Just a short post for a Tuesday to let you that I will delivering Learning Tree’s 534 Developing SQL Queries...
2016-02-09
482 reads
Until now we have seen the windows memory addressing concepts.
http://sqlandmorewithkruti.blogspot.in/2016/01/memory-fundamentals-for-sql-server.htmlhttp://sqlandmorewithkruti.blogspot.in/2016/02/memory-fundamentals-for-sql-server-awe.html
So how exactly are user applications like SQL server assigned to...
2016-02-09
2,684 reads
Hi friends, in this blog we will discussed another limitation of In-Memory OLTP that seed and increment value other than...
2016-02-09
535 reads
Wow, Power BI is making a tidal wave in the BI industry. New features are being released regularly and blog posts...
2016-02-08
961 reads
It’s Monday time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me...
2016-02-08
350 reads
There has been much talk recently in the SQL Server community about writing introductory level blog posts. Posts that a...
2016-02-08
896 reads
In this blog I will explain and demonstrate how to leverage a new feature in SQL Server 2016, Row Level...
2016-02-15 (first published: 2016-02-08)
9,115 reads
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
This week I was at PASS Data Community Summit in Seattle, and I attended...
By James Serra
(This is the third post in a three-part series on how AI is changing...
Comments posted to this topic are about the item Pay for Performance, which is...
Comments posted to this topic are about the item Helping an English Student with...
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