2004-10-21
2,262 reads
T-SQL
2004-10-19
2,565 reads
2004-10-14
2,618 reads
Cursors with SQL 2000 Part 1
This series of articles will examine the purposes, uses, and optimization of cursors in SQL 2000.
2004-10-14
3,331 reads
Utility proc for updating (sub) sequence columns
This is a utility proc that I use a lot for datawarehouse transformation/load processing. This is a generic proc for resequencing an integer column in sorted order within a given key combination.Note that 'key' is used here in a general context and not specific, that is there doesn't have to be any keys or indexes […]
2004-10-12
88 reads
2004-10-12
2,324 reads
Delete All
Here is a simpler version of the Delete All Script that was posted on 2004-10-07.Be careful it does what it is supposed to do delete all tables from the current database
2004-10-07
106 reads
2004-10-05
2,348 reads
Count rows in all tables in a database
Quick way to counts rows in all tables in a database without using Count(*).
2004-10-04
123 reads
SQL SCRIPT to grant DBC_Execute to all user SP
SQL SCRIPT to grant DBC_Execute to all user defined Stored Procs.This SQL SCRIPT is handy specially after Stored Procs are DROPPED & CREATED; often users dont mention the SQL to grant DBC_Execute permission to the Store Procs.This SQL SCRIPT will grant execute permission to DBC_Execute for all user defined Stored Procs. The SCRIPT can be […]
2004-10-03
187 reads
Blogs
Monday Monitor Tips: A New Analysis Page
By Steve Jones
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard...
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers