Sep 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – 2005 – Mechanisms to Ensure Integrity and Consistency of Databases – Locking and Row Versioning

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
Database, SQL Lock
Today I was going through Book On Line while researching something, I come across one interesting small article about two mechanisms to ensure integrity and consistency of databases – 1) Locking 2) Row Versioning Let us see their definition from Book Online Itself. Locking Each transaction requests locks of different…
Read More

SQLAuthority News – Book Review – Joe Celkos SQL Puzzles and Answers, Second Edition, Second Edition

Pinal Dave
SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks, SQLAuthority News
Database, SQLAuthority Book Review
Joe Celko’s SQL Puzzles and Answers, Second Edition, Second Edition (The Morgan Kaufmann Series in Data Management Systems) (Paperback) by Joe Celko (Author) Link to Amazon Short Review: This book is for all of them who enjoy little puzzles or just something which gives them challenge. Some puzzles took hours…
Read More

SQL SERVER – 2005 – Analysis Services Query Performance Top 10 Best Practices

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
Best Practices, Database, SQL Documentation
Analysis Services Query Performance Top 10 Best Practices Optimize cube and measure group design Define effective aggregations Use partitions Write efficient MDX Use the query engine cache efficiently Ensure flexible aggregations are available to answer queries. Tune memory usage Tune processor usage Scale up where possible Scale out when you…
Read More

SQLAuthority News – Download White Papers – Migration from MySQL, Oracle, Sybase, or Microsoft Access to Microsoft SQL Server

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Database, SQL Download, SQL White Papers
Note : Download White Papers by Microsoft Guide to Migrating from MySQL to SQL Server 2005 This migration guide explains the differences between the MySQL and SQL Server 2005 database platforms, and the steps necessary to convert a MySQL database to SQL Server. Guide to Migrating from Oracle to SQL…
Read More

SQL SERVER – Sharpen Your Basic SQL Server Skills – Learn the distinctions between unique constraint and primary key constraint and the easiest way to get random rows from a table

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Database, DBA, SQL Constraint and Keys
Read my article in SQL Server Magazine March 2007 Edition I will be not able to post complete article here due to copyright issues. Please visit the link above to read the article. [Articles are relocated so links are disabled] Reference : Pinal Dave (https://blog.sqlauthority.com)
Read More