Getting Over It or: How I Learned to Stop Worrying and Love Speaking
Consider this the outtakes from my previous post about speaking at SQL Saturday.
It took a while for me to build up the courage to finally get up in the...
2015-06-02
23 reads
Monday Morning SQL Break – June 1, 2015
It’s Monday and time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow...
2015-06-01
2,310 reads
Parallelism and Columnstore Indexes
Columnstore indexes are fascinating and really cool. Unfortunately, they’re adding an interesting new wrinkle to an old problem.
What’s the Cost...
2015-06-01
828 reads
Yet one more quick and easy performance tuning setting
I blogged in the past about two simple commands that can be a big help in performance tuning SET STATISTICS...
2015-06-01
643 reads
A Tool for Every Job
I’m a fixer. A tinkerer. As a kid, I would take my toys apart just to see how they worked,...
2015-06-01
1,555 reads
Enabling Instant File Initialization
Found a couple good walkthroughs on enabling instant file initialization. However, I'm becoming more familar with the nuances of various...
2015-06-01
807 reads
What is User Defined function in SQL Server?
User-defined functions encapsulate T-SQL statement and return a table or a scalar value to the caller. UDFs can not be...
2015-06-01
380 reads
2015-05-31
1,259 reads
Sysmail_help_Account_sp – SQL Server Database Mail Stored Procedure – Part 6
Hi friends, in this blog we will learn how to get information about database mail account using stored procedure sysmail_hep_account_sp....
2015-05-30
878 reads
Finding gaps or missing dates in a date range using TSQL
Here’s a quick how-to on returning temporal data set that includes missing dates. Suppose you are tasked to query an...
2015-05-29
16,392 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 Mahendradata Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Mahendradatta Selatan No. 99 AX, Padangsambian, Kec. Denpasar Bar., Kota Denpasar, Bali...
Alamat Telp BCA KCP Sesetan Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Raya Sesetan No.301, Sesetan, Denpasar Selatan, Kota Denpasar, Bali 80223
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