Finding Duplicates
This is just a short post that uses a contrived example to demonstrate how to find duplicate records in a...
2010-06-18
1,112 reads
Blog Posts
How Do I ... Get a List of Tables With Data Modifications in a Specific Timeframe?
How Do I ... Get a List of Tables With Data Modifications in a Specific Timeframe?
There was a question on a...
2010-06-18
1,943 reads
June SCSUG Meeting Follow-up
This is a bit later than usual as the meeting was a week ago now, but I wanted to post...
2010-06-18
661 reads
Learn SQL Server 2008 R2 with 24-HOP
Last month, the Professional Association for SQL Server (PASS) held its second 24 Hours of PASS, or 24 HOP for...
2010-06-18
409 reads
PASS Update #34 (The “Spring Event”!)
The minutes of the June 2010 Board meeting have been posted and if you haven’t read them yet, you missed...
2010-06-18
670 reads
Speaking and Presenting Tips - Handouts
I’ve given quite a few presentations, one keynote with another to come, and attended many more. I’ve read a few...
2010-06-18
1,198 reads
SQL Spatial data for State/County shapes
I saw a Blog post by Grant Fritchey (Blog | Twitter) a couple days ago on using Geospatial data in SSRS...
2010-06-18
1,797 reads
Travel Tips from an Intrepid Traveling DBA
Recently, Buck Woody challenged myself, Paul Randal, and Brent Ozar to write a blog post on “How I Travel”. I...
2010-06-18
2,345 reads
Building a PASS Voting Solution – Part 1
Last year for the annual Board of Directors election we used Zoomerang as our e-voting solution. It’s not the worst...
2010-06-17
515 reads
Finding SQL Server Client Ports
I saw a post recently asking if there was an easy way to find the port a client was using...
2010-06-17
1,562 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