Will cloud services render DBAs obsolete? Does the cloud mean that developers will use less of SQL Server? Kendra talks about the future of database administration and gives tips on strategizing your career.
Learn why the output from the built-in procedure sp_who2 can be so confusing, how to get more information, and free tools that can make it easier to figure out what you need to pay attention to in SQL Server.
Learn where full-text search shines, a common problem which full-text search does NOT solve, where full-text can run into performance problems.
Learn the difference between heaps, clustered and nonclustered indexes, primary keys, and columnstore indexes in SQL Server.
Learn how to approach the unexpected in a mysterious execution plan that contains way more operators than expected for a very simple SQL Server query.
Performing a switcharoo between new and old tables can cause blocking nightmares. Partition switching may help, surprisingly even on non-partitioned tables.