Looking Back: #sqldinner at #sqlsummit 2016
Last week was the 2016 Pass Summit, and this was one of the few times that PASS did not provide...
2016-11-02
584 reads
Live 360–SQL in Orlando
I’ll be at the last big SQL Server conference in the US for 2016 this December. VS Live is a...
2016-11-10 (first published: 2016-11-02)
922 reads
Why is SQL Server scanning the clustered index when I have an index on the column I am filtering on?
*Originally published in our old blog on January 2009
I ran into a very simple SQL Server performance related question the other day. A puzzled DBA was staring at a...
2016-11-02
22 reads
Why is SQL Server scanning the clustered index when I have an index on the column I am filtering on?
*Originally published in our old blog on January 2009
I ran into a very simple SQL Server performance related question the...
2016-11-02
216 reads
A Data Professional’s Story – PASS Summit 2016
This year is different. Why? I’m not sure yet. There is a lot of reflection going on since my return...
2016-11-11 (first published: 2016-11-02)
1,246 reads
Query Store custom SSMS performance dashboard
As most of you might know, I am a big fan of the Query Store feature inside SQL Server 2016....
2016-11-08 (first published: 2016-11-02)
3,328 reads
New indexes, hypothetically
I saw something like this the other day. My first thought was “Hu, never seen that before.” My second thought...
2016-11-02
882 reads
Trick or Treat...Have I got an IT Training treat for you...
It Trick or Treat on Monday...Two days on and I have a treat for you. Learning Tree's Great Value IT...
2016-11-02
497 reads
SQL Server DMA v2.0 – Migration Time
In my last post I showed you how to conduct an assessment using DMA – Database Migration Assessment tool v2.0 This...
2016-11-02
596 reads
SQL : How to Find Unused Indexes details
The Dynamic Management View (DMV) named sys.dm_db_index_usage_stats that track index usage details of the database. This DMV gives an information about...
2016-11-01
641 reads
Blogs
A New Word: Semaphorism
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
SQL Server Linux Container Images Got Smaller: Image Size and Startup Time Across Cumulative Updates
This week I was at PASS Data Community Summit in Seattle, and I attended...
Using AI to Build Semantic Models, Ontologies, and Fabric Data Agents
By James Serra
(This is the third post in a three-part series on how AI is changing...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Layanan BCA KCP Rembang Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Pemuda No.3 C, Tawangsari, Leteh, Kec. Rembang, Kabupaten Rembang, Jawa Tengah 59217
Layanan BCA KCP Blora Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Pemuda No.57B, Blora, Tempelan, Kec. Blora, Kabupaten Blora, Jawa Tengah 58211
Question of the Day
Adding Bits I
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