Designing relational tables with subtypes
Relational tables often describe more than one type of real world entity. In this tip, Bob Watkins covers some things to think about when designing such tables.
2006-11-13
3,890 reads
Relational tables often describe more than one type of real world entity. In this tip, Bob Watkins covers some things to think about when designing such tables.
2006-11-13
3,890 reads
The same ANSI Standard SQL query can run against identical data on SQL Server and Oracle and return different results. So just because your application issues ANSI standard SQL, don't assume it's portable.
2006-11-09
2,041 reads
This video sample shows how the clustering algorithm can be used to automatically validate data.
2006-11-08
2,184 reads
SQL Server 2005 replication agents are configured optimally out of the box, but occasionally you might need to alter the default behavior by tweaking the agent's parameters. SQL Server 2005 exposes some parameters through graphical interface that were available only from command line or through agent job steps in previous releases. Baya Pavliashvili encourages you to learn the new options available with each replication agent and how to fine-tune these options for your applications.
2006-11-07
2,281 reads
Working with a new piece of technology can be intimidating. Not having the technology installed correctly can only lead to more difficultly. This guide outlines steps to properly install SQL Server 2005 Reporting Services and the current service pack to get you going in the right direction.
2006-11-06
3,793 reads
You may find this shocking, but some IT people lie on their CV. Richard Morris offers a rare glimpse into the dark underworld of the people tasked with rooting out the CV fraudsters.
2006-11-03
3,591 reads
If you create functions or stored procedures from SQL Server 2005 Management Studio, you will notice that the new window is filled with a template. In general, you get a skeleton interspersed with markers. This article discusses how you can use templates.
2006-11-02
2,522 reads
DW/BI professionals are often tasked with making evolutionary upgrades and improvements to minimize cost and upheaval in the current analytic environment. We explore four upgrades that can breathe new life into legacy data warehouses.
2006-10-31
2,682 reads
If your SQL Server app is suffering from poor performance and you suspect a missing index, then read on
2006-10-30
2,990 reads
Damon Armstrong learned the hard way about the consequences of not having a clearly defined project scope or work contract
2006-10-27
3,089 reads
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...
Telp/Wa 62817825533 Jl. Cempaka No.17, Sukorejo, Kec. Sukorejo, Kota Blitar, Jawa Timur 66111
Telp/Wa 628217555651 Jl. Gajah Mada No.14-18, Kelurahan Jember Kidu, Jember Kidul, Kec. Kaliwates, Kabupaten...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
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