Notes from the February 2012 MagicPASS Meeting
I was back at MagicPASS last week to do a presentation, my first time with the group at the new...
2012-03-06
570 reads
I was back at MagicPASS last week to do a presentation, my first time with the group at the new...
2012-03-06
570 reads
Today, I am following up on a topic I mentioned in an earlier post. In case you haven’t read the post on finding your linked servers, you can read...
2012-03-06
9 reads
Today, I am following up on a topic I mentioned in an earlier post. In case you haven’t read the...
2012-03-06
687 reads
In this short post, I’ll discuss NoRowsMessage property. When there is no data for a data region, the message you...
2012-03-06
1,858 reads
When you try to log on to a remote server on emergency to perform some task , it may throw an...
2012-03-06
8,236 reads
All, wanted to immediately share the news today from Microsoft regarding SQL Server: This just in from the MVP/MS Newsroom. I'm...
2012-03-06
1,641 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-06
1,233 reads
1) SQL Server 2008 R2 Reporting Services doesn’t support Windows 2003 (or R2) Itanium based servers
2) SQL-DMO support is stopped...
2012-03-06
1,184 reads
This post is a continuation of a series started to help you understand each of the Microsoft presentation layer tools...
2012-03-06
2,008 reads
One dimension you can be positive will always make it’s way into your data warehouse is the Date dimension. Over...
2012-03-06
4,185 reads
Once upon a time I had a series about some cool stuff in Snowflake:...
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
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