Command Prompt connectivity –U option
When you try to connect to sql server using isql/osql or sqlcmd there are two authentication you can use windows...
2012-03-13
543 reads
When you try to connect to sql server using isql/osql or sqlcmd there are two authentication you can use windows...
2012-03-13
543 reads
It's T-SQL Tuesday again, and this month Argenis Fernandez (@DBArgenis/Blog) is hosting with the topic of "Jack of All Trades,...
2012-03-13
957 reads
Last week the internet went crazy with the news of super cool new stuff for techies to play with.
If you’re...
2012-03-13
899 reads
SQL Server 2012 was released to manufacturing last week, you can download it from MSDN if you have subscription or...
2012-03-13
2,189 reads
If I wasn't, would I have proposed the following topic for several speaking chances, including SQLRally?
Being a specialist means you're...
2012-03-13
1,472 reads
Specialise or a generalise? It all depends on how you define these terms.
A SQL Server DBA may be considered to...
2012-03-13
759 reads
The MultiDimensional eXpressions, or MDX, language is used to query the data in a multidimensional in an OLAP database. In the...
2012-03-12
1,449 reads
The MultiDimensional eXpressions, or MDX, language is used to query the data in a multidimensional in an OLAP database. In the...
2012-03-12
2,274 reads
Even though SQL Server Database Mirroring is deprecated in SQL Server 2012, it is still a very useful HA/DR technique...
2012-03-16 (first published: 2012-03-12)
6,707 reads
What is the best methodology to use when creating a data warehouse? Well, first off, let’s discuss some of the reasons why...
2012-03-15 (first published: 2012-03-12)
9,537 reads
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
This is my late response to T-SQL Tuesday #204. I almost always forget about...
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
Comments posted to this topic are about the item Adding Bits II
Comments posted to this topic are about the item An Unlimited Token Budget
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