Indexing is a critical part of database optimization. Indexing can dramatically increase query speed. However, DBAs still struggle with finding optimal indexes or optimal SQL plans. DBTA held a ...

Dave the DBA adds an index to a table to improve a report query that takes over an hour to run. Now it takes 10 minutes. Dave is a hero. But not for long. Later in the week, he'll find himself ...

Developers working with SQL Server often treat indexing as a DBA's domain--something happening "under the hood" that doesn't require much attention unless performance takes a hit. But ignoring the ...

There are some minor potential dangers associated with Groovy’s def keyword. The Groovy style and language feature guidelines for Java developers provides some warnings about use of def. In this blog ...

I'm familiar with the process and have a script that will touch every table in a specified database with the DBCC REINDEX command, however I'm having an unusual problem.<BR><BR>Due to the size of the ...