Indexes in Sql server
Indexes-Indexing is way to sort and search records in the table. It will improve the speed of locating and retrieval...
2010-01-03
943 reads
Blog Posts
Upgrading the SSC SQL Servers: Part 2
Since I wrote the first part of this blog series, SQLServerCentral.com (SSC) SQL Servers have been upgraded, and performance is...
2010-01-03
893 reads
A Year In Review
It’s been a busy year for me. Last year I quit traveling and took a 8 to 5 job so...
2010-01-02
772 reads
Sql Joins- Inner Joins, Self Joins, Outer Joins, Cross Joins
I generally feel that people are afraid of Joins in SQL Server. But if they know what the different types...
2010-01-02
24,842 reads
This Blog is Moving!
I’ve moved my blog to www.sqlandy.com and the first post of 2010 is up. It’s still very much a work...
2010-01-02
286 reads
2009 Goals in Review
Late last year, I blogged about some goals I had set for myself to accomplish during 2009. No goal-setting session...
2010-01-01
1,111 reads
Board Election for the North Texas SQL Server User Group
The new year is less than 24 hours old and I’ve already been blessed with two different honors. I shared...
2010-01-01
553 reads
I’m a Microsoft MVP!
I received a notification e-mail earlier this morning that I’ve been selected as a Microsoft SQL Server MVP for 2010! ...
2010-01-01
907 reads
Moving My Blog and Rebranding Too
I started blogging about 2-1/2 years ago on SQLServerCentral.com and at the time it was the logical place for hosting....
2010-01-01
325 reads
Plagiarism
And really bad plagiarism at that.
I received an email from someone suggesting I check out a book on Lulu.com, that...
2010-01-01
1,029 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