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 - Renaming SP is Not Good Idea - Renaming Stored Procedure Does Not Update sys.procedures

SQL SERVER – Renaming SP is Not Good Idea – Renaming Stored Procedure Does Not Update sys.procedures

September 28, 2008
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Stored Procedure, SQL System Table

Renaming Stored Procedure objects with sp_rename looks fine, but the stored definition keeps the old name, as sp_helptext shows. A quick demo on AdventureWorks.

Read More
SQL SERVER - Puzzle - Computed Columns Datatype Explanation

SQL SERVER – Puzzle – Computed Columns Datatype Explanation

September 27, 2008
Pinal Dave
SQL Puzzle
MVP, SQL Scripts

Jacob Sebastian explains that SQL Server casts to the data type with the highest precedence. That leads to my puzzle on computed columns datatype.

Read More
SQL SERVER - Get Answer in Float When Dividing of Two Integer

SQL SERVER – Get Answer in Float When Dividing of Two Integer

September 26, 2008
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts

Dividing one integer by another in SQL Server returns an integer. Use CAST or CONVERT to get the answer in float, with decimals, as this example shows.

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
SQL SERVER - Guidelines and Coding Standards Part - 1

SQL SERVER – Guidelines and Coding Standards Part 1

September 23, 2008
Pinal Dave
SQL Performance
Best Practices, Database, Software Development, SQL Coding Standards, SQL Constraint and Keys, SQL Index, SQL Joins, SQL Scripts, SQL Stored Procedure

Guidelines and Coding Standards Part 1: Pascal naming for tables, and naming patterns for stored procedures, triggers, indexes and keys.

Read More
A wooden apparatus with two pale wheels and a metal arm beside a bowl of stones, an empty bowl, a walnut and a red cord.

bit Conversion: Nonzero Numbers Become One

September 21, 2008
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL Function, SQL Scripts

bit conversion turns any nonzero number into one. Compare zero, negative values, NULL and TRUE/FALSE text before treating conversion as validation.

Read More
Previous 1 … 299 300 301 302 303 304 305 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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