January Question: What feature(s) of SQL Server would you like to learn more about?
Although SQL Server 2012 coming out this year, I think some of us are still trying to catch up with...
2012-01-04
699 reads
Although SQL Server 2012 coming out this year, I think some of us are still trying to catch up with...
2012-01-04
699 reads
Somewhat unnoticed during the holiday season, HP has submitted a new TPC-E benchmark for the DL385 G7 two socket database...
2012-01-04
1,656 reads
This past year, I spoke at the PASS Summit for the second time. The first time was a couple years...
2012-01-04
781 reads
I’m stepping out of blogging-break mode for a few minutes to share that I’ll be presenting Building Your Professional Development...
2012-01-04
710 reads
Restoring a SharePoint site collection can be a pretty easy task. If your interested in how to do that check...
2012-01-04
1,596 reads
I will be presenting on SQL Server security on January 19th in Charleston, SC. You can find the details at...
2012-01-04
863 reads
I am excited to announce that I will be giving a virtual presentation to the Knoxville SQL Server User Group. ...
2012-01-04
1,004 reads
I read a blog post this morning on SQLServerCentral by Tim Radney about SQL Server Error Logs. Tim talks about...
2012-01-04
1,109 reads
Use the script below to rebuild an index on a table
ALTER INDEX MY_INDEX_NAME on MY_TABLE_NAME REBUILD ;
Check SQL Server...
2012-01-04
1,054 reads
Do you know there are hundreds of additional tasks, tools, and components for SSIS, many which are free? Why re-invent...
2012-01-04 (first published: 2011-12-30)
3,098 reads
Recently, in an attempt to thwart leechers (1990s kids will know), I added some...
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