The default instance has a name
The default instance actually has an instance name. It’s MSSQLSERVER. This is probably familiar to a lot of you but...
2015-09-07 (first published: 2015-08-31)
3,289 reads
The default instance actually has an instance name. It’s MSSQLSERVER. This is probably familiar to a lot of you but...
2015-09-07 (first published: 2015-08-31)
3,289 reads
This weekend I was invited over at SQLSaturday Oslo to speak about SQL Server Indexing. I ran into Boris Hristov...
2015-08-31
920 reads
Let’s take a closer look at how we can speed up the system’s performance using the Buffer Pool Extension. For...
2015-08-31
2,043 reads
Attended SQL Server Geeks Annual Summit 2015 on last Wednesday (26/8) at Bangalore, India. Due to few urgent responsibilities at...
2015-08-31
1,299 reads
What happens when you create a table?
Have you ever give it a thought, how sql server actually managing your table?...
2015-08-30
718 reads
What happens when you create a table?
Have you ever give it a thought, how sql server actually managing your table?...
2015-08-30
862 reads
Hi Folks,
Comments play an important part in writing any code. Especially when somebody else reads your code. So the other...
2015-08-30
1,330 reads
I am super excited to announce that I have recently been accepted as an author for Pluralsight.
My audition was on Monitoring AlwaysOn Availability Groups and was accepted on the...
2015-08-29
15 reads
I am super excited to announce that I have recently been accepted as an author for Pluralsight.
My audition was on...
2015-08-29
1,272 reads
After a couple months of fun with Power BI, I’ve picked up a few little tricks along the way that...
2015-09-04 (first published: 2015-08-29)
4,446 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