Junk dimensions
Junk dimensions are dimensions that contain miscellaneous data such as flags and indicators. When designing a data warehouse, you might...
2011-12-19
1,395 reads
Junk dimensions are dimensions that contain miscellaneous data such as flags and indicators. When designing a data warehouse, you might...
2011-12-19
1,395 reads
If you fill the jar with pebbles first, you'll never have room for the big rocks.
I’m sure you’ve heard the...
2011-12-19
1,229 reads
I just ran across this in a piece of code (that I didn’t write):
… WHERE Thing >GETDATE()- 30
Aaaand it works....
2011-12-19
1,244 reads
I say it all the time because it’s worth repeating, feedback is a gift. Good, bad or indifferent (well, not...
2011-12-19
1,738 reads
As the name indicates, CONCAT() will concatenate two or more strings. This is one of the two string functions introduced in...
2011-12-22 (first published: 2011-12-19)
4,013 reads
While some people may consider this topic off limits the fact remains that more and more companies are adopting Apple...
2011-12-19
718 reads
This post is about a contracting in UK. Some of terms mentioned here will not mean a great deal to...
2011-12-19
1,212 reads
Here’s a great post from Karla Landrum about her trip (with husband Rodney) to Brazil for the milestone making #100....
2011-12-19
737 reads
Using Dynamic Values in XMLA
XMLA
A question was raised on Twitter today via the #sqlhelp hash tag about passing parameter values...
2011-12-18
1,945 reads
In the spirit of Robert Davis's (blog | @SQLSoldier) blog post: Undocumented Gotchas of Transactional Replication, I decided to contribute an...
2011-12-18
1,365 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