Another article from our own Chris Hedgate! This one looks at the different types of fragmentation that can exist inside your SQL Server and some ways you can go about minimizing them.
2007-10-02 (first published: 2004-05-10)
48,372 reads
SQL Server 2000 trace flags can dramatically alter the behavior and functionality of the server. There are a number of ways that they can be enabled and Chris Hedgate brings us a tutorial on their use and benefits.
2007-06-21 (first published: 2005-05-04)
25,491 reads
These are not the DMO bits you are thinking of from SQL Server 2000. SQL Server 2005 introduces a new way of digging into the inner workings of the server with both Dynamic Management Views and Dynamic Management Functions. Longtime SQL Server guru Christoffer Hedgate looks at these new ways of understanding your server.
2006-01-26
9,027 reads
One thing that often amazes me is that many SQL Server developers do not actually measure the performance of their queries. Many of them thought that you needed external tools, more or less complicated, to run against your server, and they did not have the time or inclination to learn and try these. This article will describe a couple of much easier methods of measuring performance of queries.
2005-12-23 (first published: 2004-04-02)
37,769 reads
It just ended, but Chris Hedgate filed a report from the airplane as he sped home at 30,000ft across the Atlantic.
2005-10-06
4,091 reads
One of the more controversial new features in SQL Server 2005 is the inclusion of the Common Language Runtime (CLR) inside the server. Whether you agree this is a good idea or not, the very knowledgable Chris Hedgate brings us the first article in a series looking at how the CLR fits into your database server.
2005-07-13
17,244 reads
Chris Hedgate, one of our regular SQL Server columnists, recently became intrigued by the way that SQL Server implements the week number. His concern was why SQL Server treats week 53 as week 1, which is not that way that ISO6801 sees it. Read about his investigation into the methods of implementing an algorithm to solve this problem.
2005-01-20
11,661 reads
The default location for the SQL Server system databases doesn't always meet the standards of many organizations. Author Chris Hedgate has taken the time to put together a short checklist on how you can move the master, msdb, model, and tempdb databases easily.
2004-11-30
21,847 reads
Regular columnist Chris Hedgate follow up on Andy's recent article about Worst Practices with one of his own. This is worth passing on to your development team.
2004-03-10
17,329 reads
Chris (one of our regulars!) installed Log Explorer and took it for a test drive. Written up in our standard review format this will give you a very quick overview of what the product does.
2004-02-13
8,848 reads
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
By DataOnWheels
I have been active in the data community throughout my career. I have met...
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
hi, in an ssis for each loop over an object variable called MyListVariable, i...
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers