Multiple Windows Groups with different default databases
A question came up at work the other day, mostly as a mind game, but you never know it might...
2015-06-08 (first published: 2015-05-28)
1,867 reads
A question came up at work the other day, mostly as a mind game, but you never know it might...
2015-06-08 (first published: 2015-05-28)
1,867 reads
By David Postlethwaite
On the Database Scale page we can decide on the performance level that we want our database to...
2015-05-28
1,040 reads
For those who haven’t noticed already:
SQL Server 2016 CTP2 (or Preview as some call it) has just been released!
This means...
2015-06-01 (first published: 2015-05-28)
3,291 reads
Hi friends, today we will continue with database mail stored procedure and will learn how to create database mail account...
2015-05-28
981 reads
Azure SQL Database Elastic Scale Part 3 - Setting up and Querying the Shards
MAY 28, 2015
For those of you who have been following along with this series of posts,...
2015-05-28
118 reads
Azure SQL Database Elastic Scale Part 3 - Setting up and Querying the ShardsMAY 28, 2015
For those of you who have...
2015-06-05 (first published: 2015-05-28)
4,149 reads
By Steve Bolton
…………The same rules that applied to my amateur mistutorial series on A Rickety Stairway to SQL Server Data...
2015-05-28
2,375 reads
I was reading Dwain Camps’ article on Time Slots and thought it was a very interesting solution to a problem...
2015-05-27
921 reads
Continuation from the previous 53 parts, the whole series can be found at http://www.nikoport.com/columnstore/
This is a not very deep technical...
2015-05-27
959 reads
Massive parallel processing (MPP) is the future for data warehousing.
So what is MPP? SQL Server is a Symmetric Multiprocessing (SMP) solution, which...
2015-05-27
815 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