the ability to move virtual servers from one physical host to another on the fly without downtime. While that does indeed work great, it doesn’t necessarily work great for every server in every shop. If you’ve got a heavily saturated network, and your SQL Server’s memory is changing...
Best Practices + Table Partitioning: Merging Boundary Points(Blog) Brent Ozar: “SQL Server Partitioning: Not the Best Practice for Everything” (Blog) Hash Partitioning, SQL Server, and Scaling Writes(Blog) Potential Problems with Partitioning(Blog) ...
Last Updated April 9, 2009 Brent Ozar 6 Comments That’s right, you heard me. Your manager doesn’t care about best practices. You can beat your chest and wail about putting the SQL Server data and log files on separate arrays, and your manager doesn’t care. The instant you’re out...
SQL Server Articles Home SQL Server Articles
Last Updated April 10, 2017 Brent Ozar Unlimited Team Interviewing 100 Comments I’ve put together my best questions to ask during an interview when I’m hiring a senior database administrator for Microsoft SQL Server or Oracle. I don’t expect any DBA to ace all of these – I’m not ...
Please advice me how to increase the SQL server performance and decrease the load time Reply Brent Ozar October 4, 2012 9:39 am Nikki – there’s a lot of possibilities here. The best way to get help on something like this is to narrow down the question as tightly as possible, then...
SQL Server is waiting to read data pages from storage. These pages weren’t cached in memory, so we have to get ’em from disk. In most cases, this is to satisfy a SELECT statement, but you can also see this for DELETES, UPDATES, and INSERTS (DUIs) as well. ...
Users WHERE DisplayName = N'Brent Ozar'; Now, the actual execution plan is simpler: From right to left, SQL Server can open the index on DisplayName, seek into just the row it’s looking for, then delete the row from the clustered index. Be aware that the plan is simplifying ...
Last Updated 16 years ago Brent Ozar The SSWUG Virtual Conference has posted free 10-minute samples of each speaker’s videos. You can get a 10-minute intro to several presentations to get a feel for the quality of the videos, the speakers and the material. The videos take 10-15 seconds...
Last Updated 5 years ago Brent Ozar Production Database Administration 300 Comments I had sworn to myself that if I saw one more helpful article about how to shrink your SQL Server database files with DBCC SHRINKFILE or how to back up your log with TRUNCATE_ONLY, I was going to write ...