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
Gouache painting of a miniature wooden workshop being assembled from organized parts beside an illustrated instruction book.

Generate Script for Schema and Data in SQL Server: SQL in Sixty Seconds #021

July 18, 2012
Pinal Dave
SQL Video
SQL Identity, SQL in Sixty Seconds, SQL Scripts, SQL Server Management Studio

To generate script for schema and data, choose Schema and data in the SSMS wizard and review the result before you run it. The tests here build such a script with T-SQL on SQL Server 2025 and show three ways it breaks: identity columns, apostrophes and the 1,000 row limit.

Read More
Gouache painting of a tree stump with growth rings and one red pin in the center ring

Find SQL Server Installation Date and Time with T-SQL

July 5, 2012
Pinal Dave
SQL Tips and Tricks
SQL DMV, SQL Scripts, SQL Server Installation

The SQL Server Installation Date is the create date of the NT AUTHORITY\SYSTEM login, and one short query reads it. This post compares that clue with other dates that look right but aren’t, shows how to work out an Evaluation expiry date, and lists the cases where the clue is wrong.

Read More
SQL SERVER - Monitoring SQL Server Database Transaction Log Space Growth - DBCC SQLPERF(logspace) - Puzzle for You

SQL SERVER – Monitoring SQL Server Database Transaction Log Space Growth – DBCC SQLPERF(logspace) – Puzzle for You

July 3, 2012
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server

Old but still my favorite: DBCC SQLPERF(logspace) to monitor transaction log space growth, saved with the time of each snapshot. Plus a puzzle for you.

Read More
SQL SERVER - Validating Spatial Object with IsValidDetailed Function

SQL SERVER – Validating Spatial Object with IsValidDetailed Function

June 29, 2012
Pinal Dave
SQL Tips and Tricks
Spatial Database, SQL Scripts

Invalid spatial objects used to give only a simple error. The IsValidDetailed function tells you whether a shape is valid and, when it is not, the reason why.

Read More
SQL SERVER - Powershell - Importing CSV File Into Database - Video

SQL SERVER – Powershell – Importing CSV File Into Database – Video

June 27, 2012
Pinal Dave
SQL Tips and Tricks
PowerShell, SQL Scripts, SQL Server, SQL Utility

PowerShell expert Laerte Junior shows importing CSV file into database tables with PowerShell, with a video, building on my SQL in Sixty Seconds post.

Read More
An open plain reference book has several colored fabric bookmarks beside a magnifying glass.

Finding the Right Answer in SQL Server Documentation

June 24, 2012
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server

Use SQL Server documentation with the right version and platform selected, read syntax carefully, and keep useful reference material offline.

Read More
Gouache painting of mixed tiles travelling down wooden channels into organized rows in a sorting tray.

Importing CSV File into SQL Server: SQL in Sixty Seconds #018

June 20, 2012
Pinal Dave
SQL Video
CSV, File format, SQL in Sixty Seconds, SQL Scripts

Importing CSV file data into SQL Server means matching the file to a table, loading it and checking the result. The tests here show a bad row skipped after a printed error, a text staging load, and the encoding and line ending settings that break a load.

Read More
Previous 1 … 202 203 204 205 206 207 208 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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