By Pinalkumar Dave, 09/29/2008
Pick up 7 basic query analysis rules from Dave.
By Pinalkumar Dave, 05/28/2008
Discover the difference between Windows Authentication Mode and Mixed Mode, and learn the names and uses of installed system databases.
By Pinalkumar Dave, 04/24/2008
By Pinalkumar Dave, 03/28/2008
Get answers to your questions about SQL Server 2005 Surface Area Configuration tools that can help you protect the SQL Server surface area from security breaches perpetrated by ...
By Pinalkumar Dave, 02/28/2008
More answers to DBAs' questions. What’s the difference between dividing an integer with NULL or zero, or between a unique constraint and a primary key constraint, or between ...
By Pinalkumar Dave, 01/25/2008
Server backup doesn’t have to be complex. With these simple commands you can perform full, transaction log or incremental, differential, and file backups. Plus you’ll learn ...
By Pinalkumar Dave, 11/20/2007
DBAs get answers to basic Structured Query Language (SQL) questions on the difference between FILLFACTOR = 0 and FILLFACTOR = 100; ISNULL and NULLIF; clustered index and ...
By Pinalkumar Dave, 10/25/2007
Learn the difference between UNION and UNION ALL; INNER JOIN and OUTER JOIN; DISTINCT and GROUP BY; NVARCHAR, VARCHAR, and CHAR; and timestamp and GETDATE().
By Pinalkumar Dave, 09/20/2007
SQL Server often features several ways to do the same or similar tasks. To select the best technique for the job, you need to understand the differences.