SQL Bloggers, Make Yourself Known
Are you an active SQL Server blogger? Do you blog regularly about the greatest database technology available? If so, you...
2009-08-04
633 reads
Are you an active SQL Server blogger? Do you blog regularly about the greatest database technology available? If so, you...
2009-08-04
633 reads
After a long weekend of travel and speaking, I’m finally able to put my feet up and get a little...
2009-08-03
999 reads
… and by government data, I mean the mountain of data recently made available by the G-Men on Data.gov. This site...
2009-07-28
1,347 reads
Like many SQL Server (and other technology) people, I utilize several social networking vehicles to stay in touch with others in the SQL community. Some of those who don’t use Facebook and Twitter (among others) have expressed skepticism of the real value of social networking. Does it work? Does it provide any value beyond entertainment? Can it actually help your career? I believe the answer to all of these queries is Yes.
2009-07-24
1,698 reads
Like many SQL Server (and other technology) people, I utilize several social networking vehicles to stay in touch with others...
2009-07-20
1,865 reads
We are in the early stages of planning a SQL Saturday event in the Dallas area for January or February...
2009-07-19
1,082 reads
I read a post on Brent Ozar’s blog last week that discussed employers’ expectations when hiring new team members. Though the story was specific to database professionals, the same principles apply to almost any hiring situation. The moral of Brent’s story...
2009-07-16
1,541 reads
I read a post on Brent Ozar’s blog last week that discussed employers’ expectations when hiring new team members. Though...
2009-07-13
614 reads
I like my main laptop. It’s big and wide and bright, with lots of power and all of the bells...
2009-07-11
1,401 reads
Have you ever noticed unexpected gaps in sequences in IDENTITY columns? Even though you’ve got transactions set up for your inserts and a no-deletion policy, you find that there are missing values in what should be an unbroken sequence of numbers. The problem could be partially related to transaction rollbacks.
2009-07-09
4,586 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