Indexes help your application find your data quickly and provide users with a well performing application, while minimizing server resources. This article discusses indexing guidelines related to join tables and covering indexes.
If you want to speak at SQL Saturday #38 in Jacksonville, FL on May 8, 2010, there's still time to submit a session.
With the launch of SQL Server 2008 R2 almost upon us, DBAs need to start planning in some time to see what it has to offer. Brad McGehee reviews some of the available resources.
Log shipping is a tool that has more benefits than just recovering from a major disaster. Steve Jones thinks this might be a tool that DBAs should use for all their critical databases.
We are working on the migration to SQL Server 2008 and have geospatial data that we would like to move over as well. As part of our application we house information on locations across the globe. Which data type should we use?
For this Friday's poll, Steve Jones asks if there is a set of essential software that every DBA needs to have installed on their machine.
This article examines the various methods for retrieving data from an Audit table.
Fabiano Amorim is hooked on today's Integrated Development Environments with built-in Intellisense, so he looked forward keenly to SQL Server 2008's native intellisense. He was disappointed at how it turned out, so turned instead to SQL Prompt. Fabiano explains why he prefers to SQL Prompt, why he reckons it fits in with the way that database developers work, and goes on to describe some of the features he'd like to see in it
A guest editorial from Andy Warren today looks at choices in time management, as well as work accomplished.
In last months one of the scenarios where you can use AI has been...
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Comments posted to this topic are about the item Creating JSON II
Comments posted to this topic are about the item Engineer Lessons
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers