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 - Get a List of Fixed Hard Drive and Free Space on Server

SQL SERVER – Get a List of Fixed Hard Drive and Free Space on Server

August 5, 2009
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Stored Procedure, Undocumented SQL

No OS access? Run xp_fixeddrives from Management Studio to list each fixed hard drive with its free space, then plan where TempDB and indexes go.

Read More
SQL SERVER - Forgot the Password of Username SA

SQL SERVER – Forgot the Password of Username SA

August 4, 2009
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server Management Studio, SQL Server Security

Forgot the password of username SA? Resetting it is easy when another sysadmin login or a Windows admin account can get in. Here are your options.

Read More
Gouache painting: in the upper row they are ordered by the color of their base band, so the tallest candle with the earliest color stands first

MIN and MAX Text: Collation Chooses the Extremes

August 2, 2009
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts, SQL String

MIN and MAX text use collation ordering, not numeric magnitude. Compare digit strings, empty text and NULL using an explicit BIN2 contract.

Read More
A small plain brass desk bell beside a closed notebook and a wooden tray in soft daylight.

Monitoring With What You Already Have

August 1, 2009
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server

Build useful SQL Server alerts with Agent, operators, failed-job notifications, and a review routine that verifies the whole delivery path.

Read More
Two groups of sage, blue and cream cloths hang above a table with a red cord.

Date Conversion Styles: Disambiguate Day and Month

July 31, 2009
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL NULL, SQL Scripts, SQL Server

Date conversion styles define how incoming text becomes a date. Compare month-first and day-first interpretations without guessing. Keep invalid dates separate from missing input.

Read More
Script Wizard - SQL.

SQL SERVER – 2008 – Copy Database With Data – Generate T-SQL For Inserting Data From One Table to Another Table

July 29, 2009
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, DBA, SQL Scripts, SQL Utility

SQL Server 2008 lets you copy database with data: turn on Script Data in the Generate Scripts wizard to get INSERT statements for the rows in your tables.

Read More
A fishing net hauled onto a jetty holds a few whole fish while sand and pebbles stream through its mesh.

Full-Text Search Basics

July 26, 2009
Pinal Dave
SQL Tips and Tricks
SQL Index, SQL Scripts, SQL Server, SQL String

Full-text search basics explains catalogs, full-text indexes, CONTAINS, and LIKE so SQL Server searches match the question and the data.

Read More
Previous 1 … 277 278 279 280 281 282 283 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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