Steve’s tweets
- @SQLSoldier do it, they are in source control, right? 1 day ago
- Loading All CSV Files with PowerShell voiceofthedba.com/2017/06/23/loa… https://t.co/8BbCuMSMau 1 day ago
- Nice to see security is a popular developer topic at @denverdevday https://t.co/Chu8Pwm4fC 1 day ago
Speaking at VS Live – Austin
Register with AUSPK14 and save $400
Tags
administration auditing Azure backup Backup/Recovery big data blogging bloopers business Business Intelligence career career cell phone Cloud Computing computers conferences continuous delivery continuous integration data analysis database design databases Database Weekly deployment Dev Connections DevOps disaster recovery DLM encryption Filetable Friday Poll hardware high availability Humor hyper-v life mcm Microsoft misc monitoring networking NoSQL PASS patching Performance powershell presentations Redgate sabbatical security software development software development speaking SQL Bits SQL Connections SQL Intersection SQL in the City SQLNewBlogger SQL Prompt SQL Saturday SQLServer sql server SQLServerCentral syndicated T-SQL T-SQL Tuesday testing TopTenSkills training travel tsqlt vacation version control virtualization windows work
Tag Archives: indexing
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
Rebuilding a Heap–Don’t Do It
I saw someone mention recently that you can run a REBUILD on a heap table. I hadn’t realized that, but when I looked in BOL, I saw that indeed you can run this on a heap. That’s interesting, in that … Continue reading
Reframing to Overcome Filtered Index Limitations
I’m continuing on with the Blogger’s challenge in this post. Turning the Problem Around In the last post, I wrote about limitations in filtered indexes. I proposed that my table had lots of data with NULL or blank spaces in … Continue reading
April Blogger Challenge 4–Filtered Index Limitations
The April Blogger Challenge is from Ed Leighton-Dick and aimed at new bloggers, but anyone is welcome. I’m trying to motivate and cheer people on. Filtered Index Limits I ran across a limitation recently with filtered indexes and was surprised. … Continue reading
The DBA Team #1–Code and Slides
Our first DBA Team event, in Richmond, VA just before SQL Saturday #187 went well. Overall I think our experiment was a success and we’re already talking about where and when we might do this again. In the meantime, we … Continue reading
Posted in Blog
Tagged backup, corruption, indexing, monitoring, Redgate, speaking, syndicated
2 Comments
Dropping Indexes
While working on some demos recently, I needed to drop an index for a test. I executed this generic statement for an index I’d just created. 1: DROP INDEX ix_IndexName Needless to say I was surprised when I got this … Continue reading
Review Your Indexing
In the latest versions of SQL Server, there are some amazing new features. Many of them allow us to expand the capabilities of SQL Server, but some are added to allow us to dive more deeply into how the system … Continue reading
Posted in Editorial
Tagged indexing, sql server
Trace Flag 2371 and Statistics
One of the issues that I see published often on forums like SQLServerCentral is the advice to update statistics on your tables if you have strange performance issues, or sudden changes in performance. Statistics are important for the query optimizer, … Continue reading
Common SQL Server – Not Indexing FKs
This series looks at Common SQL Server mistakes that I see many people making in SQL Server. Foreign Keys It’s way too often that I see people building databases without including declared referential integrity (DRI) in their databases. Even when … Continue reading
Posted in Blog
Tagged Common SQL Server Mistakes, indexing, presentations, sql server, syndicated, T-SQL
