As each year goes by the uptime requirement for our databases gets larger and larger, meaning the downtime that we have to do maintenance on our databases is getting smaller and smaller. This tip will look at a feature that was introduced in SQL Server 2005 that allows us to leave our indexes online and accessible while they are being rebuilt.
2012-02-08
4,386 reads
The most common T-SQL command in use has to be the SELECT statement, it is the bedrock of any SQL Professional's day. Sometimes it's used to snatch some data from a table or two while some quick investigation is done, other times it is at the heart of a stored procedure or view that will inform business decisions for coming months or even years.
2012-01-30
4,672 reads
2011-12-27
3,258 reads
At some time or another every DBA has been faced with the challenge of solving a deadlock issue in their SQL Server database. In the following tip we will look at how indexes and more specifically clustered indexes on the right columns can help reduce the chance of your applications receiving this dreaded error
2011-11-01
4,839 reads
2011-10-06
2,474 reads
Are your index statistics up to date? The SQL Server database engine uses statistics to determine which execution plan to use when a query is compiled. Index statistics are used to help the SQL Server engine determine the cardinality of different column values in a SQL Server table. If you want to give SQL Server a fighting chance at picking an optimal execution plan then you need to make sure you maintain your index statistics.
2011-09-14
3,901 reads
This article shows an automated reorg/rebuild index for remote servers with notifications for the DBA.
2011-09-12
3,565 reads
Lists all the tables in a database that do not contain any LOB columns(text, ntext, image, varchar (max), nvarchar (max), varbinary (max) and xml).
Useful when rebuilding indexes online.
2011-08-30 (first published: 2011-08-25)
776 reads
2011-08-08
2,379 reads
Learn how to add those indexes you need in part 3 of Matt Perdeck's 8 part series on improving data access. This is based on the book ASP.NET Site Performance Secrets.
2011-08-02
9,211 reads
The first version of my accounting assistant could not find a single purchase of...
Why isn’t AI paying off yet? Drawing on lessons from digital transformation, Joyful Craftsmen...
By Steve Jones
I’m really excited about some growth in Flyway support. I’ve been asking about this...
Comments posted to this topic are about the item Pay for Performance, which is...
Hi I have this slow query that is pulling data from a linked server....
Comments posted to this topic are about the item Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers