This script is for the Generating a code block that makes it easier to grant various permissions on a group of objects qualified by specific Criteria.
2008-10-08 (first published: 2008-07-23)
1,330 reads
It is very common to want to drop a table, if it exists, before creating it. This script does so, and it works well with temp tables (where the system views are harder to query).
2008-10-06
2,722 reads
All of us have problems with Duplicate rows, here is a simple and efficient way of removing duplicate rows
2008-10-03 (first published: 2008-07-18)
1,690 reads
How to use DDL triggers and Query the Data with minimum performance impact.
2008-10-02
1,837 reads
2008-10-01 (first published: 2008-07-24)
2,717 reads
2008-09-30 (first published: 2008-07-24)
894 reads
A short script you can incorporate into any 2005/2008 code to get the full schema.table.
2008-09-29
667 reads
Script to return Rows count from table using sp_ExecuteSQL
2008-09-26 (first published: 2008-07-20)
1,548 reads
When a value is changed that causes an error, finding what caused the error can be tricky. Here an application was truncating a column. The trigger helped to identify the culprit.
2008-09-25 (first published: 2008-07-17)
1,405 reads
A quick script to check for fragmentation in a database and generate a list of defrag statments you can run.
2008-09-24
2,483 reads
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Comments posted to this topic are about the item Squared Values
Comments posted to this topic are about the item I Don't Want To Do...
Comments posted to this topic are about the item Managing Feature Flags with GET_BIT()...
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers