Mastering Index – Index on Computed Columns
This
article is the part of series Mastering Index, in this particular article
we will be exploring Index on computed
columns. Take a look...
2016-11-07
579 reads
This
article is the part of series Mastering Index, in this particular article
we will be exploring Index on computed
columns. Take a look...
2016-11-07
579 reads
If you have created a SQL Database in Azure (PaaS) and need to make a copy of it on the...
2016-11-07
413 reads
Knowledge and ability, they are very inter-related. We born with only survival ability, ability to eat and drink, that’s pretty...
2016-11-07
1,420 reads
Open Source PowerShell is available on several operating systems, that really what’s special about the whole project! To get PowerShell to function on these various systems we need to...
2016-11-07
18 reads
Open Source PowerShell is available on several operating systems, that really what’s special about the whole project! To get PowerShell...
2016-11-07
687 reads
For the years I have been watching the SQLPASS session recording and hearing that it's really a different experience to...
2016-11-06
493 reads
Query Store collects 2 important kinds of data. They are
1) Compile time statistics - Query Plan, Estimated Costs, Estimated number of...
2016-11-06
831 reads
I still remember the first real ETL process I developed. I was working for a hospital at the time, going...
2016-11-04
759 reads
I’m trying to look back at some of the events of the recent Summit, and Game Night was one of...
2016-11-04
558 reads
Join me online on Tuesday, November 15th at 1:00PM as I host a webinar entitled “Managing Data Warehouse Incremental Loads...
2016-11-04
429 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...
WhatsApp:0817819444 Jl. Pemuda No.3 C, Tawangsari, Leteh, Kec. Rembang, Kabupaten Rembang, Jawa Tengah 59217
WhatsApp:0817819444 Jl. Pemuda No.57B, Blora, Tempelan, Kec. Blora, Kabupaten Blora, Jawa Tengah 58211
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