Special Index - XML Index
I will be writing this series of articles for the Special Indexes in SQL Server. In this series we will...
2016-11-11
534 reads
I will be writing this series of articles for the Special Indexes in SQL Server. In this series we will...
2016-11-11
534 reads
This post is about the importance of a right index to a query. The following simple query was considered.<?query --SELECT [GroupBy1].[A1]...
2016-11-11
342 reads
It’s Friday so no releases to Production today (ha!) which means in-between my code reviews, server audits and other tasks...
2016-11-11
307 reads
Problem
When creating Linked Servers, security often gets overlooked. This can lead to accounts on one instance having access, sometimes with...
2016-11-11
22,449 reads
WOW!!! The next great update to Execution Plans is a way to watch the processing of rows through iterators while...
2016-11-15 (first published: 2016-11-10)
2,068 reads
With Windows Server 2016 just been released, now is the perfect time to build an Azure VM with SQL Server...
2016-11-10
1,043 reads
One of the topics I forgot to mention from the Roundtable was a swell of dissatisfaction with the GAP. Not...
2016-11-10
403 reads
First I guess we had best start with definitions right? The permission Administer Bulk Operations and the role bulkadmin are...
2016-11-14 (first published: 2016-11-10)
2,363 reads
If you’re a DBA or database developer, chances are you will have to write or rewrite queries from time to...
2016-11-14 (first published: 2016-11-10)
5,726 reads
I am in the middle of some research regarding CHECKDB and learnt something new. From SQL Server 2014 onwards the...
2016-11-10
470 reads
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
By James Serra
(This is the third post in a three-part series on how AI is changing...
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
Comments posted to this topic are about the item Pay for Performance, which is...
Jl. PB.Sudirman No.40, Tekoan, Tanggul Kulon, Kec. Tanggul, Kabupaten Jember, Jawa Timur 68155
Jl. YOS Sudarso No.49, Dusun Kp. Baru, Jajag, Kec. Gambiran, Kabupaten Banyuwangi, Jawa Timur...
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