Temporary Tables and Stored Procedures
- QotD Question
How to identify backup tables within production databases that can be removed.
2018-10-05 (first published: 2018-09-28)
'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.
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.
This articles brings a comparison of temporary tables with table variables from SQL Server author, Wayne Sheffield. In includes an in-depth look at the differences between them.
2012-06-08 (first published: 2009-06-10)
Understanding the types of tables available in SQL Server can greatly enhance your database development experience.
This is part of a series of new job blog posts. You can find...
By Will Assaf
SQL Server 2022 Administration Inside Out is now available for pre-order from Microsoft Press. This...
Back in December 2019, I started presenting my session on mental health with lots...
I am having Below Table i want to get Result as shown in the...
what I want is to apply some filter patterns to search the data. For...
Hi All, Using Tsql query I want to know currently running sql agent jobs...
SQL Server Q&A from the SQLServerCentral communityGet answers