2008-04-19 (first published: 2008-02-22)
3,869 reads
Scripts
Show all database's tables' columns' collations.
Created view displays all text columns' collations in the current database with the information whether
the collation is different from the database's one.
2008-04-04 (first published: 2008-01-22)
1,735 reads
Generating combinations 'm elements from n-element set'
This procedure generates a dataset with combinations of elements_to_select taken from number_of_values element set. It prints also the prepared query.
2008-04-01 (first published: 2008-01-21)
1,214 reads
2005 Blocking Locks RDL for Management Studio
RDL for use in MSSSQL 2005's Management Studio (custom reports).
2008-03-28 (first published: 2008-01-18)
1,194 reads
2008-03-19 (first published: 2008-01-24)
3,570 reads
Generating permutations - procedure
This procedure prepares a query for generating permutations of n-numbers set and executes it.
2008-03-18 (first published: 2008-02-04)
962 reads
2008-03-14 (first published: 2008-01-29)
1,274 reads
Trim Trailing Blanks in SQL Queries
Reformats the text output of queries to trim trailing blanks in wide varchar columns for easy copy-and-paste.
2008-03-10 (first published: 2008-01-09)
2,939 reads
Db files size per directory
This procedure displays amount of disk space used by database per directories.
2008-02-29 (first published: 2008-01-14)
934 reads
Random varchars
This procedure generates a list of random varchars (8 charactes length, only letters - lower or upper case).
2008-02-28 (first published: 2008-01-14)
661 reads
Blogs
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
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...
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