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.
It is Friday, the queries are running, and nobody is watching the bill. That...
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
WhatsApp:0818-751-777 Jl. Joyoboyo No.34, Kemasan, Kec. Kota, Kota Kediri, Jawa Timur 64125 (@bcakcpjoyoboyo)
Comments posted to this topic are about the item Midjourney, Healthcare?
Comments posted to this topic are about the item Changes, Happiness, and a Few...
When running bcp on Linux, what is the field terminator?
See possible answers