Find Invalid Objects in SQL Server
This article shows how you can find which objects in your database might not be valid after schema changes.
2023-03-13
21,541 reads
Database objects
Associating Data Directly with SQL Server Database Objects.
It is easy to attach details and documentation to a SQL Server database using extended properties. In fact, you can add a number of items of information to any database objects such as tables, views, procedures or users.
2019-11-19
Painless Refactoring of SQL Server Database Objects
Refactoring a database object can often cause unexpected behavior in the code that accesses that object. In this article, adapted from his excellent book, Defensive Database Programming with SQL Server, Alex Kuznetsov discusses several techniques that will harden your code, so that it will not break, or behave unpredictably, as a result such changes.
2015-04-08
11,414 reads
Blogs
Teaching at the SC Statewide Audit Conference
By Brian Kelley
Instead of teaching the CISA exam prep course, I'm teaching in the IT track....
Upgrading SQL Server in a Container
By Steve Jones
I decided to update software on my laptop recently during a trip. I’m loathe...
SQL Server Editions: What’s the Difference and Why It Matters
By Kevin3NF
Understanding the Limits Before You Hit Them If you’re responsible for a SQL Server...
Forums
is there a reorg available in sql server?
hi i have a 67 million row fact table that needs about 30 million...
The Technical Debt Anchor
Comments posted to this topic are about the item The Technical Debt Anchor
Getting the Updated Column List
Comments posted to this topic are about the item Getting the Updated Column List
Question of the Day
Getting the Updated Column List
What happens when I run this code in SQL Server 2022?
UPDATE dbo.CustomerLarge SET CustomerContactFirstName = 'Andy' WHERE CustomerID = 1 SELECT COLUMNS_UPDATED()See possible answers