2018-12-13
1,048 reads
2018-12-13
1,048 reads
How to identify backup tables within production databases that can be removed.
2018-10-05 (first published: 2018-09-28)
551 reads
2016-09-01
1,494 reads
'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
2014-04-11
2,216 reads
2013-06-25
2,908 reads
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
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)
60,988 reads
Understanding the types of tables available in SQL Server can greatly enhance your database development experience.
2008-04-02
27,733 reads
By Steve Jones
One of the things that I’ve been asked in every operations situation is what...
By Brian Kelley
If you are an introvert like me, events like the PASS Summit can call...
By kleegeek
On October 2nd and 3rd, I took part in an amazing event called AI...
Good Morning, I have built an SSIS package which produces Excel File Output. In...
Comments posted to this topic are about the item Comparing Images
Comments posted to this topic are about the item Time to Change Your Team
I am building an ETL process between these tables in SQL Server 2022 set to 160 compatibility level:
CREATE TABLE Image_Staging ( imageid INT NOT NULL CONSTRAINT Image_StagingPK PRIMARY KEY , imagestatus TINYINT , imagebinary IMAGE); GO CREATE TABLE Images ( imageid INT NOT NULL CONSTRAINT ImagesPK PRIMARY KEY , imagestatus TINYINT , imagemodified DATETIME , imagebinary IMAGE); GOI want to run this query to check if the images already loaded exist. This will help me decide if I need to insert or update an image. What happens with this query?
SELECT i.imageid FROM dbo.Image_Staging AS ist INNER JOIN dbo.Images AS i ON ist.imagebinary = i.imagebinary;See possible answers