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
Workshop pegboard with neatly arranged tools, standards that keep work organized

SQL SERVER – Database Coding Standards and Guidelines Part 2

June 5, 2007
Pinal Dave
SQL Interview Questions and Answers
Database, DBA, Software Development, SQL Coding Standards, SQL Download, SQL Scripts, SQL Server

Database Coding Standards and Guidelines Part 2: skip SELECT *, use SET NOCOUNT ON, prefer CTEs over temp tables, avoid cursors, and more query tips.

Read More
Workshop pegboard with neatly arranged tools, standards that keep work organized

SQL SERVER – Database Coding Standards and Guidelines Part 1

June 4, 2007
Pinal Dave
SQL Tips and Tricks
Database, DBA, Software Development, SQL Coding Standards, SQL Download, SQL Scripts, SQL Server

Database Coding Standards and Guidelines Part 1: naming rules for tables, stored procedures, triggers, indexes, primary keys and foreign keys.

Read More
A pale-stone path border is accompanied by a separate slate, two bricks and a shell in a sunlit courtyard

Coding Standards: A Short Guide and a Practical Naming Check

June 3, 2007
Pinal Dave
SQL Tips and Tricks
Developer, SQL Coding Standards, SQL Scripts

Useful SQL coding standards give teams a short rule set with clear exceptions. Run a read-only naming report, check literal underscores in procedure prefixes and review the results before changing objects.

Read More
SQL SERVER - 2005 Explanation and Example - SELF JOIN

SQL SERVER – 2005 Explanation and Example – SELF JOIN

June 3, 2007
Pinal Dave
SQL Tips and Tricks
SQL Joins, SQL Scripts

A self join joins a table to itself with table aliases. When to use one, why the joined columns must share a data type, and an employee example.

Read More
A hand moving a magnifying glass along a shelf of plain matching books, one book pulled halfway out.

Searching Every Stored Procedure for a Word

June 1, 2007
Pinal Dave
SQL Tips and Tricks
SQL Collation, SQL Scripts, SQL Server, SQL Stored Procedure, SQL System Table

Searching every stored procedure through sys.sql_modules finds text quickly, but comments, case, dynamic SQL, and other databases need care.

Read More
SQL SERVER - 2005 Constraint on VARCHAR(MAX) Field To Limit It Certain Length

SQL SERVER – 2005 Constraint on VARCHAR(MAX) Field To Limit It Certain Length

June 1, 2007
Pinal Dave
SQL Tips and Tricks
SQL Constraint and Keys, SQL Scripts, SQL String

SQL Server 2005 has no VARCHAR(12500), so how do you cap a VARCHAR(MAX) field at 12500 characters? A constraint on the column does the job.

Read More
SQL SERVER - Retrieve Information of SQL Server Agent Jobs

SQL SERVER – Retrieve Information of SQL Server Agent Jobs

May 31, 2007
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Server Agent, SQL Stored Procedure

sp_help_job returns information about SQL Server Agent jobs in msdb. Run it with no parameters to list every job, plus a few related Agent posts.

Read More
Previous 1 … 344 345 346 347 348 349 350 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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