Raw Materials - Alternative Energy
Revenge is a dish best served cold, but body temperature's OK, too.
2011-08-09 (first published: 2009-07-22)
9,373 reads
Revenge is a dish best served cold, but body temperature's OK, too.
2011-08-09 (first published: 2009-07-22)
9,373 reads
This article demonstrates how to manage the development of complex queries by building them in stages with temporary tables, table variables and common table expressions.
2011-08-09
10,411 reads
This article looks to provide a method that you can use to collect the author's top 10 SQL Server performance metrics automatically over time.
2011-08-09
4,684 reads
"Counting" is essential to many high performance code techniques. SQL Server MVP, Jeff Moden, shows us how to make sure that we're "Counting" and not "Crippling" our trick-code.
2011-08-08
23,441 reads
Read the input string and break each sentence into groups of 5 words. A row may contain more than one sentence. Each sentence in the input should start a new group.
2011-08-08
1,240 reads
Script tasks are a great way of extending SSIS functionality, when none of the built-in components are quite right for the task you need to perform. But how to go about creating a script task? No worries, once again Robert Sheldon is on hand to provide easy instructions on how to do it.
2011-08-08
3,543 reads
Read more about how you can get a free two user license from SourceGear and Red Gate Software.
2011-08-05 (first published: 2011-07-05)
3,335 reads
Find out what you need to learn for the SQL Server 2008 Administration certification exams.
2011-08-05
9,094 reads
SQL Server ships with the tablediff utility which can be used to compare the data in two tables. Read this article to learn it step-by-step:
2011-08-05
5,504 reads
2011-08-04 (first published: 2009-07-15)
10,143 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