The Current Book
Search this blog
Steve’s tweets
- @AaronBertrand @ATT Looks like policy from entering your password with T9 1 day ago
- @sqlpass Thanks, not a big deal, but wanted to change a phone number in my profile. 1 day ago
- @sqlpass I think your form is broken. I start typing, pick an item, and can't update profile https://t.co/KZecvV4d2Z 1 day ago
Friends of Redgate
MVP Award
Tags
- administration
- AI
- auditing
- Azure
- backup
- Backup/Recovery
- blogging
- bloopers
- business
- Business Intelligence
- career
- career
- cell phone
- Cloud Computing
- computers
- continuous delivery
- continuous integration
- data
- data analysis
- database design
- databases
- Database Weekly
- dbatools
- deployment
- Dev Connections
- DevOps
- disaster recovery
- DLM
- encryption
- Friday Poll
- GDPR
- goals
- hardware
- high availability
- Humor
- life
- Linux
- mcm
- Microsoft
- misc
- monitoring
- networking
- NoSQL
- PASS
- patching
- Performance
- powershell
- presentations
- Redgate
- sabbatical
- security
- software development
- software development
- speaking
- SQL Clone
- SQL Connections
- SQL in the City
- SQLNewBlogger
- SQL Prompt
- SQL Saturday
- sql server
- SQLServerCentral
- SSMS
- syndicated
- T-SQL
- T-SQL Tuesday
- testing
- travel
- tsqlt
- vacation
- version control
- virtualization
- webinar
- windows
- work
Tag Archives: indexing
Mastering Index Tuning–Day 3
This is a short series of posts on the courses I took with Brent Ozar. I actually completed the courses in the past, but I wrote notes and wanted to revisit the way things went. This post looks at the … Continue reading
Mastering Index Tuning–Day 2
This is a short series of posts on the courses I took with Brent Ozar. I actually completed the courses in the past, but I wrote notes and wanted to revisit the way things went. This post looks at the … Continue reading
Interviews: Covering index
Performance seems to be a part of every DBAs job. It should be a part of every developer’s job, but I understand the focus to build software is different and many developers aren’t sure how much a feature or option … Continue reading
Posted in Editorial
Tagged indexing, interviews
The Clustered Index is not the Primary Key
I was reading through a list of links for Database Weekly and ran across this script from Pinal Dave, looking for tables where the clustered index isn’t the PK. It struck me that this is one of those facts I … Continue reading
