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 - 18 Seconds of Fame - My PASS Experience

SQLAuthority News – 18 Seconds of Fame – My PASS Experience

December 25, 2010
Pinal Dave
SQL Performance
SQLAuthority Author Visit

At SQLPASS someone asked me for 15 seconds on camera and I forgot all about it. Today I found out about that clip: my 18 seconds of fame from PASS.

Read More
Two wooden house-shaped blocks with keyholes stand beside two plain metal keys on a table.

Restoring to a Newer SQL Server Is a One-Way Trip

December 24, 2010
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Backup and Restore, SQL Server

Plan a restore to newer SQL Server with the version boundary in mind, preserve the original backup, and understand options for moving data back.

Read More
SQL Server query window displaying cost calculations.

SQL SERVER – Index Created on View not Used Often – Observation of the View – Part 2

December 23, 2010
Pinal Dave
SQL Performance
SQL Scripts, SQL View

A reader asked what happens when we create an index on the base table as well as on the view. Part 2 of my observation of the view looks at both cases.

Read More
Gouache painting: a battered tin box with its lid propped open stands on a bench

geometry Collections: Read Members With STGeometryN

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

geometry Collections hold member shapes that STGeometryN can return individually. I extract a point and a line from one fixed collection. A third request deliberately exceeds its member count.

Read More
SQL Server query window displaying cost calculations.

SQL SERVER – Index Created on View not Used Often – Observation of the View

December 21, 2010
Pinal Dave
SQL Performance
SQL Scripts, SQL View

When is an index created on view actually used? After showing it is often ignored, I demonstrate a condition where SQL Server uses it, including NOEXPAND.

Read More
A mandoline slices a cucumber beside separate dishes of cucumber and radish slices.

Turning a Comma-Separated Column Into a Proper Child Table

December 20, 2010
Pinal Dave
SQL Tips and Tricks
CSV, Normalization, SQL Constraint and Keys, SQL String, SQL Table Operation

A list stuffed in one column makes every search a guess. Split it, clean it and move it into a child table, then check the result before you drop anything.

Read More
A brass identification plate riveted to a machine housing, its stamped surface worn smooth and blank, lit by a torch beam from one side.

How to Check Your SQL Server Version, Edition and Patch Level

December 19, 2010
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Server, SQL Server Installation

Check your SQL Server version, edition and patch level with one query. How to read the build number, why ProductLevel still says RTM on a patched server, and the edition surprise a health check finds most often.

Read More
An old car drives along an empty road at dusk, past a roadside garage with its shutters closed.

End of Support: What Actually Stops Working

December 19, 2010
Pinal Dave
SQL Tips and Tricks
DBA, SQL Migration, SQL Server, SQL Server Security, SQL Upgrade

End of Support does not shut down SQL Server, but it changes security updates, fixes, and help; plan an exit before risk grows.

Read More
SQL SERVER - Index Created on View not Used Often - Limitation of the View 12

SQL SERVER – Index Created on View not Used Often – Limitation of the View 12

December 18, 2010
Pinal Dave
SQL Tips and Tricks
SQL Index, SQL Scripts, SQL Server, SQL Training, SQL View

At my Hyderabad seminar someone asked: will an Index Created on a view be used when you query the view? Not always. Limitation 12 of views explained.

Read More
SQLAuthority News - A Successful Community Tech Days in Ahmedabad - December 11, 2010

SQLAuthority News – A Successful Community Tech Days in Ahmedabad – December 11, 2010

December 17, 2010
Pinal Dave
SQLAuthority News
SQL User Group, SQLAuthority Author Visit

Nearly 170 people joined a successful Community Tech Days in Ahmedabad with Jacob Sebastian, Rushabh Mehta, Vinod Kumar and me. Here are the details.

Read More
Previous 1 … 433 434 435 436 437 438 439 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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