SQL Server Transactions and Locking (Part 1)
In many situations, data modification requires several steps. For example, you may need to change the values ??in two separate...
2013-05-22
599 reads
In many situations, data modification requires several steps. For example, you may need to change the values ??in two separate...
2013-05-22
599 reads
The well-designed online analytical processing (OLAP) solution is fundamental to organizations analysis capabilities. That is why, when designing the OLAP...
2013-05-22
880 reads
With the release of SQL Server 2005 and later releases, Microsoft introduced set of new dynamic management view and function...
2013-05-22
572 reads
The following table lists all builds of SQL Server 2012 known hotfixes, service packs and KB articles that have been...
2013-05-08
1,605 reads
The following table lists all builds of SQL Server 2008 R2 known hotfixes, service packs and KB articles that have...
2013-05-08
21,144 reads
The following table lists all builds of SQL Server 2008 known hotfixes, service packs and KB articles that have been...
2013-05-08
1,320 reads
The following table lists all builds of SQL Server 2005 known hotfixes, service packs and KB articles that have been...
2013-05-08
2,551 reads
The following table lists all builds of SQL Server 2000 known hotfixes, service packs and KB articles that have been...
2013-05-08
2,280 reads
The following table lists all builds of SQL Server 7.0 known hotfixes, service packs and KB articles that have been...
2013-05-08
1,125 reads
Like other mainstream commercial database systems, Microsoft SQL Server allows you to create multiple indexes on the same column of...
2013-05-07
1,192 reads
I wanted to figure out how big (or approximately how big) my dump file...
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Comments posted to this topic are about the item Announcing SQL Server 2025
Comments posted to this topic are about the item Running Steve's Code
Comments posted to this topic are about the item New SQL Server 2022 Functions
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc] AS SELECT Consumer_ID , Trend_Category , Bit_Trace FROM NewWorldDB.dbo.MarketTrend; GOSee possible answers