Distincting an IN subquery
This is going to be a quick one…
I keep seeing forum code (and production code) that includes the DISTINCT in...
2011-01-26
5,455 reads
This is going to be a quick one…
I keep seeing forum code (and production code) that includes the DISTINCT in...
2011-01-26
5,455 reads
"A recent blog entry I read reminded me again that I wanted to rant about an issue in SQL Server for quite some time now. SQL Server 2005 introduced the separation between user and schema. Though schemata already existed before SQL Server 2005, they really became usable with this version, imho. At the same time TRY...CATCH was a new way for structured error handling introduced. And so it finally became possible…"
2011-01-26
2,799 reads
31 Days of SSIS
The last post in the 31 Days of SSIS talked about the use of environmental variables. As...
2011-01-25
1,469 reads
I set up a new instance of MS SQL Server Reporting Services, but I noticed that it starts up very slow and I have to wait for ages to access the site. I also noticed that it is always slow when it has not been used for a certain period of time.
2011-01-25
5,452 reads
Optimizing queries is the most fun when you don’t need to add indexes. There’s nothing quite so nice as finding...
2011-01-25
1,467 reads
2011-01-25 (first published: 2010-12-02)
3,658 reads
This challenge is to parse and evaluate arithmetic expressions using TSQL.
2011-01-24
2,303 reads
Here is another example CPU throttling from someone who had a server running with the default “Balanced” Power Plan in...
2011-01-24
2,725 reads
The BIT data type is an awkward fit for a SQL database. It doesn't have just two values, and it can do unexpected things in expressions. What is worse, it is a flag rather than a predicate, and so its overuse, along with bit masks, is a prime candidate for being listed as a 'SQL Code Smell'. Joe Celko makes the case.
2011-01-24
3,676 reads
Continuing on with my MCM prep, I was listening to the High Availability/DR prep module today and I was once...
2011-01-24
1,427 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