A Sub-Query Does Not Hurt Performance
The things you read on the internet, for example, “don’t use a sub-query because that hurts performance.”
Truly?
Where do people get...
2016-10-24
1,539 reads
Power BI Custom Visuals Class (Module 22 – Force-Directed Graph)
In this module you will learn how to use the Force-Directed Graph Power BI Custom Visual. The Force-Directed Graph allows...
2016-10-24
876 reads
Monday Night Networking Dinner Tonight
If you are attending the PASS Summit, or even in the Seattle area, we have a SQL Server pro networking...
2016-10-24
492 reads
Synchronous vs Asynchronous
You’ll hear these terms thrown around in programming all the time, but what do they mean and why do we...
2016-10-24
798 reads
Reading a SharePoint 2007 List from SSIS 2016
It's been a while, but since I now get to play with SQL 2016 full time, I have new things to talk about! One of major difficulties that any technology...
2016-10-24
54 reads
Reading a SharePoint 2007 List from SSIS 2016
It's been a while, but since I now get to play with SQL 2016 full time, I have new things...
2016-10-24
746 reads
Seattle SQL Pro Workshop 2016
Free workshop on SQL Server leading up to Summit 2016 that will provide attendees an alternate means to increase affordable learning opportunities during the week.
Related Posts:
Seattle SQL Pro Workshop...
2016-10-24
14 reads
Seattle SQL Pro Workshop 2016
Seattle SQL Pro Workshop 2016
You may be aware of an event that some friends and I are putting together during...
2016-10-24
559 reads
Query Store – Part 2 - Configuration Settings
Introduction to Query Store covered here.
Now for the second part on “How to Configure?”
Query Store is configured at the...
2016-10-24
990 reads
Master Data Services error – Cannot read configuration file due to insufficient permissions
In preparation of my upcoming webinar on the new features of Master Data Services 2016, I installed MDS on my...
2016-10-23
2,339 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