This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
SQLAuthority News – Meeting Bryan Oliver and Learning Wisdom of Life

SQLAuthority News – Meeting Bryan Oliver and Learning Wisdom of Life

June 24, 2010
Pinal Dave
SQLAuthority News
Database, SQL User Group

I met Bryan Oliver of Solid Quality Mentors expecting a proud expert, and found an extremely friendly and knowledgeable person. Some wisdom I learned from him.

Read More
SQLAuthority News - Guest Post - SELECT * FROM XML - Jacob Sebastian

SQLAuthority News – Guest Post – SELECT * FROM XML – Jacob Sebastian

June 23, 2010
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL XML

Getting NULL when reading a value from XML? Most of the time the XPath expression is wrong. A guest post by Jacob Sebastian on writing it correctly.

Read More
Two shallow wooden trays on pale surfaces, connected by a blue cord, with a terracotta cord passing through the right tray.

geometry STIsValid: Parsed Shapes Still Need a Validity Check

June 22, 2010
Pinal Dave
SQL Tips and Tricks
Spatial Database, SQL Function, SQL Scripts, SQL Server

geometry STIsValid checks whether a spatial instance satisfies the validity rules for its geometry type. I use two parsed lines to separate those questions. Successful construction alone does not establish that a shape is valid.

Read More
Critical error.

SQL SERVER – TRANSACTION, DML and Schema Locks

June 21, 2010
Pinal Dave
SQL Interview Questions and Answers
SQL Scripts, SQL Stored Procedure, SQL Transactions

Most candidates in a senior developer interview could not create a scenario that shows schema locks. Here is a simple demo with a TRANSACTION and DML.

Read More
Three small wooden sample pieces beside an open blank notebook and a plain magnifying glass.

How to Learn a New SQL Server Release Quickly

June 20, 2010
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server

Evaluate new SQL Server features with a focused reading plan, version checks, three relevant experiments, and a record of operational tradeoffs.

Read More
Skittles set in a triangle with two gaps in the middle, a red ball waiting at the near end before any throw.

Sequence Gaps: Why NEXT VALUE FOR Skips Numbers

June 19, 2010
Pinal Dave
SQL Tips and Tricks
SQL Cache, SQL Identity, SQL Server, SQL Transactions

Explain sequence gaps, inspect cached values, test rollback behavior, and separate SQL Server identifiers from gapless numbering.

Read More
SQLAuthority News - Interview with SQL Server MVP Madhivanan - A Real Problem Solver

SQLAuthority News – Interview with SQL Server MVP Madhivanan – A Real Problem Solver

June 18, 2010
Pinal Dave
SQL Tips and Tricks
MVP

SQL Server MVP Madhivanan has left over 1000 helpful comments on this blog. In this interview he talks about his work and his life outside SQL.

Read More
Table showing clustered index entries.

SQL SERVER – Data Pages in Buffer Pool – Data Stored in Memory Cache

June 17, 2010
Pinal Dave
SQL Performance
SQL DMV, SQL Scripts

What is in your memory cache? A query on sys.dm_os_buffer_descriptors shows the data pages in buffer pool for each table and index.

Read More
SQL SERVER - Find Largest Supported DML Operation - Question to You

SQL SERVER – Find Largest Supported DML Operation – Question to You

June 16, 2010
Pinal Dave
SQL Tips and Tricks
Best Practices

Best practice says the log should be twice the size of the largest supported DML operation. But how do you measure that? Share your ideas with me.

Read More
Shrinking Database

SQL SERVER – Shrinking Database NDF and MDF Files

June 15, 2010
Pinal Dave
SQL Tips and Tricks
Shrinking Database, SQL Server, SQL Server DBCC

Previously, I had written a blog post about SQL SERVER. I am posting this blog post here about Shrinking Database.

Read More
Previous 1 … 452 453 454 455 456 457 458 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com