Temporary Tables

External Article

Self-maintaining, Contiguous Effective Dates in Temporal Tables

  • Article

'Temporal' tables contain facts that are valid for a period of time. When they are used for financial information they have to be very well constrained to prevent errors getting in and causing incorrect reporting. This makes them more difficult to maintain. Is it possible to have both the stringent constraints and simple CRUD operations? Well, yes. Dwain Camps patiently explains the whole process.

2015-03-26

9,819 reads

External Article

Temporary Tables in SQL Server

  • Article

Temporary tables are used by every DB developer, but they're not likely to be too adventurous with their use, or exploit all their advantages. They can improve your code's performance and maintainability, but can be the source of grief to both developer and DBA if things go wrong and a process grinds away inexorably slowly. We asked Phil Factor for advice, thinking that it would be a simple explanation.

2011-09-22

6,511 reads

Blogs

Future Data Driven 2023 is This Week

By

The Future Data Driven 2023 virtual conference is coming on Wednesday, September 27. Register...

Opening the SQL Prompt Command Palette

By

A few years ago SQL Prompt added a command palette to let you search...

Common Mistakes in SQL Server – Part 2

By

The  Identity property creates an incremental value for the specified column automatically, which is...

Read the latest Blogs

Forums

Identifying the process that is backing the databases to virtual device

By ramana3327

We have about 20 SQL Servers. We use Net backup or Native backup for...

SQL Migration - Identifying Connections - Best approach

By ramana3327

I have one SQL Database server which is old version and planning to migrate...

Restore With Standby; A Review and A Lesson Learned

By Andy Warren

Comments posted to this topic are about the item Restore With Standby; A Review...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers