Indexes Out the Window II
In Part I, I discussed some of the peculiarities and troubleshooting done in relation to a peculiar execution plan. In...
2010-01-26
847 reads
Blog Posts
It’s a Toaster
I had to install WinZip the other day, having the need to unlock a .RAR file. There’s no native support...
2010-01-26
1,161 reads
Jimmy May coming to our Local Chapter meeting
This is wonderful news to our new chapter. Jimmy May has agreed to come to give a presentation at our...
2010-01-26
688 reads
Proofing Your Resume
The resume that you send out, whether in print or electronically, is the first impression that you will make on...
2010-01-26
1,366 reads
Second Normal Form (2NF)
Second Normal Form (2NF) :-A table is said to be in its Second Normal Form if it satisfied the following...
2010-01-26
3,652 reads
SQLFool IDX Defrag Scripts
I just found out that Michelle Ufford (@sqlfool) has updated her Index Defrag scripts. Right now she is looking for...
2010-01-26
929 reads
The Three Events That Brought Me Here
Recently Paul Randal (twitter, blog) instigated another meme in the SQL Server community – What three events brought you here. If...
2010-01-26
443 reads
Third Normal Form (3NF)
Third Normal Form (3NF) :- A table is said to be in the Third Normal form (3NF) if it satisfy the...
2010-01-26
2,241 reads
Tweeting – I took the Dive.
In a previous post, I questioned how much Twitter could really do for me. After some comments made, and some...
2010-01-26
609 reads
Updating a column
Hi,
I have a table name CustUsers. In this table, there is a field name: PWD
I have refreshed the production database...
2010-01-26
378 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