Disk Is Cheap! ORLY?
People often conclude that the cheap price of storage is a license to use as much as possible, but there is a cost.
2013-10-30 (first published: 2010-12-31)
17,728 reads
People often conclude that the cheap price of storage is a license to use as much as possible, but there is a cost.
2013-10-30 (first published: 2010-12-31)
17,728 reads
Changing the structure of a very large table doesn't need to require a maintenance window.
2012-10-05 (first published: 2011-04-26)
22,038 reads
Table partitioning was added in SQL Server 2005 and increases performance in most cases but decreases it in others.
2010-05-04
7,282 reads
SQL CLR Table-Valued Functions can stream data back, but there aren't many examples of the quick and easy method. Solomon Rutzky brings us an article that givse you an example you can extend to your environment.
2009-12-23
12,992 reads
Reduce both time and memory utilization when uploading bulk data to SQL Server 2008 by combining Table-Valued Parameters (TVPs) and the .Net IEnumerable interface.
2009-05-28
14,089 reads
Testing DB code is not fun or easy so it usually gets ignored. But now there’s a super-easy way to test using DBFit.
2008-11-13
11,371 reads
The CLR has not been well-received and most people use it for Regular Expressions and string functions. Here is an example that goes beyond trivial uses.
2008-06-24
5,636 reads
When searching meta-data to find an occurance of a particular string or pattern it is difficult to look everywhere. This procedure helps you find what you are looking for.
2008-05-28
8,626 reads
A look at how constants are used in T-SQL and SQL Server in general along with some suggestions on how better to deal with them.
2007-10-16
7,773 reads
The CLR integration in SQL Server 2005 greatly expands on the capabilities of the SQL Server platform. One new area is the ability to build user-defined types and user-defined aggregates. Solomon Rutzky brings us a way to get around some of the limitations in this area with his SQL# toolkit.
2007-09-18
5,595 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...
Hello everyone, I’ve developed an SSIS process to compare two relatively large tables. When...
Good afternoon, I have an SSIS package which loads raw records into a sheet...
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