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 2005 connection window.

SQL SERVER – Clear Drop Down List of Recent Connection From SQL Server Management Studio

November 5, 2008
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, DBA, SQL Scripts, Vista

Is the SSMS connect drop down list full of old server names? Delete the mru.dat file for SQL Server 2005 or 2008 to clear it and start fresh.

Read More
SQL SERVER - DECLARE Multiple Variables in One Statement

SQL SERVER – DECLARE Multiple Variables in One Statement

October 31, 2008
Pinal Dave
SQL Performance
Best Practices, SQL Scripts

Yes, you can DECLARE multiple variables in one statement in SQL Server. Compare both methods side by side: one statement per variable, or all in one line.

Read More
Execution time statistics.

SQL SERVER – Retrieve – Select Only Date Part From DateTime – Best Practice – Part 2

October 18, 2008
Pinal Dave
SQL Performance
Best Practices, SQL DateTime, SQL Function, SQL Scripts

Which way to select only date part from DATETIME is faster? After more tests on large tables, I now suggest the DATEADD and DATEDIFF method over CONVERT.

Read More
Gouache painting of a person sorting punctuation into a separate tray beside a database cabinet

SQL Injection: The Joke, the Failure and the Parameter Fix

October 12, 2008
Pinal Dave
SQL Tips and Tricks
Best Practices, Dynamic SQL, SQL Humor, SQL Server Security

SQL Injection makes a good joke and a terrible incident. The tests here show a concatenated query returning every row for one hostile name, the same text passed as a parameter returning none, a table name caught by QUOTENAME, and a read-only user blocked from dropping a table.

Read More
A set of architect's drawings pinned flat on a drawing board with a scale rule laid across them, the drawn lines clear and no lettering anywhere.

What Is a Database Schema in SQL Server?

October 3, 2008
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, Developer, SQL Server

A database schema is a namespace inside a database. What dbo really is, why two tables can carry the same name, how a schema makes permissions something you set once, and why naming it in your code saves you from odd bugs.

Read More
SQL SERVER - Guidelines and Coding Standards Complete List Download

SQL SERVER – Guidelines and Coding Standards Complete List Download

September 25, 2008
Pinal Dave
SQL Tips and Tricks
Best Practices, Data Warehousing, Database, DBA, SQL Coding Standards, SQL Constraint and Keys, SQL Cursor, SQL Data Storage, SQL Download, SQL Function, SQL Index, SQL Joins, SQL Scripts, SQL Server Security, SQL Stored Procedure, SQL Trigger, SQL Utility

My coding standards complete list for SQL Server, cut to what people follow: naming, formatting, and the rules that prevent real bugs.

Read More
SQL SERVER - Guidelines and Coding Standards Part - 2

SQL SERVER – Guidelines and Coding Standards Part – 2

September 24, 2008
Pinal Dave
SQL Performance
Best Practices, Database, Software Development, SQL Coding Standards, SQL Scripts, SQL Stored Procedure

Part 2 of my Guidelines and Coding Standards: nest single quotes, add parentheses for readability, use IF EXISTS with SELECT 1, and avoid the SP_ prefix.

Read More
Previous 1 … 42 43 44 45 46 47 48 … 55 Next
  • Books
  • Testimonials
  • Privacy Policy

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