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 - Reverse String Word By Word

SQL SERVER – Reverse String Word By Word

December 6, 2014
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts, SQL String

A reader wanted to reverse string word by word, so “I am Pinal Dave” becomes “Dave Pinal am I”. Here is the function that does it.

Read More
Customization of Query in SQL Server Management Studio.

SQL SERVER – Customization of New Query in SQL Server Management Studio

November 29, 2014
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Server Management Studio

A junior DBA was fired for dropping a table on production. Here is how to customize the New Query window in SSMS so it opens with the commands you need.

Read More
SQL SERVER - FIX - The database 'model' is marked RESTORING and is in a state that does not allow recovery to be run

SQL SERVER – FIX – The database ‘model’ is marked RESTORING and is in a state that does not allow recovery to be run

November 25, 2014
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Data Storage, SQL Scripts

After a backup restore mistake, SQL Server would not start and ERRORLOG said the database ‘model’ is marked RESTORING. This is how I got it running again.

Read More
Gouache painting of a row of closed wooden shutters on a plaster wall, with one small shutter opened a hand-width and a vermilion flowerpot on its sill

Msg 230: A Column Level GRANT Overrides a Table DENY

November 21, 2014
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts, SQL Server Security

A column level GRANT overrides a DENY on the whole table in SQL Server. A friend challenged my earlier claim that DENY always wins, so I built a repro. The granted column works, and every other column raises Msg 230.

Read More
SQL SERVER - User Defined Audit with SQL Server

SQL SERVER – User Defined Audit with SQL Server

November 15, 2014
Pinal Dave
SQL Tips and Tricks
SQL Audit, SQL Scripts, SQL Server

Bank security checks taught me patience about audits. Here is how a user defined Audit in SQL Server lets you write your own events to the audit log.

Read More
Sausage links on a red hook, one missed twist leaving two sausages joined into one long one

Why SELECT 28F3 Returns 28: Float Literals and Hidden Aliases

November 10, 2014
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL Scripts, SQL Server, Starting SQL

Explain float literals, why SELECT 28F3 creates an alias, how 28E3 uses scientific notation, and why explicit AS prevents confusion.

Read More
helpbutton

SQL SERVER – Unable to Restore From Backup After Detach Operation

November 4, 2014
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Scripts

A young guy came to me and said – “I found a bug in SQL Server Restore”. How to fix Unable to Restore From Backup After Detach Operation.

Read More
Previous 1 … 169 170 171 172 173 174 175 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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