Why worry about CXPACKET
Many people see CXPACKET at the top of their waits and start trying to fix it. I know this topic’s...
2014-03-11
1,624 reads
Blog Posts
[SQL Snacks Video] The Basics of Joins
This is a special edition for SQL Snacks. It is one (of many hopefully) SQL Snacks that has been recorded...
2014-03-10
926 reads
Bad Ideas: Alert Storming
Fellow DBA: There are so many alerts! It takes me a long time to get through them all. How do...
2014-03-10
680 reads
Issue with sys.dm_db_index_usage_stats in SQL Server 2012
I’d be struggling to remember a week where I hadn’t run a query against the dmv sys.dm_db_index_usage_stats to find unused...
2014-03-10 (first published: 2014-02-27)
3,259 reads
Last Weeks Top “Reading” Links #74
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-03-10
940 reads
Look At The SQLSaturday Orlando Home Page
One of the weaknesses of the current SQLSaturday tool set is that the front page isn’t strong by default. It...
2014-03-10
322 reads
Two Digit Dates in SQL – MM/DD/YYYY
When creating dates or numbers as strings it is sometimes required to have two digit numbers.
For example, instead of...
2014-03-10
393 reads
Two Digit Dates in SQL – MM/DD/YYYY
When creating dates or numbers as strings it is sometimes required to have two digit numbers.
For example, instead of this:...
2014-03-10
1,209 reads
Doing it with the EzAPI
In my last post, I attempted to write a SQL Server Integration Services (SSIS) Package programmatically.
I used the API that...
2014-03-09
4,648 reads
VMware Certification Changes
The last twelve months in my certification world have been rather odd. First, Microsoft has terminated their Microsoft Certified SQL...
2014-03-09
738 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