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
SQL SERVER - How to Enable Index - How to Disable Index - Incorrect syntax near 'ENABLE'

SQL SERVER – How to Enable Index – How to Disable Index – Incorrect syntax near ‘ENABLE’

October 27, 2009
Pinal Dave
SQL Tips and Tricks
SQL Index, SQL Scripts

ALTER INDEX with ENABLE fails with Incorrect syntax near ‘ENABLE’. To enable index after you disable it for a bulk load, you rebuild it instead.

Read More
Gouache painting: two identical engine sheds stand side by side in a railway yard

AsGml: Export a Shape as Namespaced XML

October 24, 2009
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL Function, SQL Scripts

AsGml exports geometry as XML in the GML namespace. Read a line’s coordinates with a qualified path and compare an unqualified path.

Read More
Candidate Key Query.

SQL SERVER – Difference Between Candidate Keys and Primary Key In Simple Words

October 22, 2009
Pinal Dave
SQL Tips and Tricks
SQL Constraint and Keys, SQL Scripts

The difference between candidate keys and primary key in simple words: any unique column can be a candidate key, but only one becomes the primary key.

Read More
SQL SERVER - Change Collation of Database Column - T-SQL Script - Consolidating Collations - Extention Script

SQL SERVER – Change Collation of Database Column – T-SQL Script – Consolidating Collations – Extention Script

October 19, 2009
Pinal Dave
SQL Tips and Tricks
SQL Collation, SQL Scripts, SQL Utility

Brian Cidern’s extension script for consolidating collations across a database, a big help when you face the annoying cannot resolve collation error.

Read More
A shop door at dusk with the shutter half down and a blank red board hanging beside it

Adding Business Hours to a Timestamp in T-SQL

October 17, 2009
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Function, SQL Scripts, SQL Server

Add business hours through a stored work calendar, skip closed dates and nights, and calculate ticket deadlines without a minute loop.

Read More
SQL SERVER - Recently Executed T-SQL Query

SQL SERVER – Recently Executed T-SQL Query

October 16, 2009
Pinal Dave
SQL Tips and Tricks
SQL DMV, SQL Function, SQL Scripts, SQL System Table

fn_get_sql() and DBCC INPUTBUFFER will be deprecated. Use sys.dm_exec_query_stats and sys.dm_exec_sql_text to see each recently executed T-SQL query.

Read More
Fresh shoots and established seedlings share a tray beside an adjustable growth guide.

SQL SERVER – Enable Automatic Statistic Update on Database

October 15, 2009
Pinal Dave
SQL Performance
SQL Scripts, SQL Server, SQL Statistics

Automatic statistics updates respond to changing data and query needs. I inspect the setting and estimates before treating it as a tuning fix.

Read More
Previous 1 … 272 273 274 275 276 277 278 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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