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 - Restrictions of Views - T SQL View Limitations

SQL SERVER – Restrictions of Views – T SQL View Limitations

April 28, 2007
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Stored Procedure, SQL View

SQL Server views come with many rules, like ANSI_NULLS and QUOTED_IDENTIFIER being on. My list of view limitations, corrected with help from Ben Taylor.

Read More
SQL SERVER - Good, Better and Best Programming Techniques

SQL SERVER – Good, Better and Best Programming Techniques

April 28, 2007
Pinal Dave
SQL Interview Questions and Answers
SQL Backup and Restore, SQL Constraint and Keys, SQL Cursor, SQL Download, SQL Function, SQL Index, SQL Joins, SQL Scripts, SQL Server DBCC, SQL Server Security, SQL Stored Procedure, SQL Trigger

My notes for a programmers meeting on Good, Better and Best Programming Techniques in SQL Server, plus a funny bug ticket about a client who got no email.

Read More
A gouache mason's courtyard groups paired stones on three distinct height levels, with a red wedge at the middle level.

SQL SERVER – Query to Retrieve the Nth Maximum Value

April 27, 2007
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Joins, SQL Scripts, SQL Server

Finding the nth Maximum Value means deciding how ties should count. Here, I rank distinct known salaries.

Read More
A gouache garden gate has three distinct latch mechanisms, with a vermilion pin beside weathered timber and iron fittings.

SQL SERVER – Locking Hints with Correct Scope and Safe Examples

April 27, 2007
Pinal Dave
SQL Tips and Tricks
SQL Lock, SQL Scripts, SQL Server

Locking Hints change how a table reference participates in locking. I choose the required consistency before changing the query.

Read More
SQL SERVER - SELECT vs. SET Performance Comparison

SQL SERVER – SELECT vs. SET Performance Comparison

April 27, 2007
Pinal Dave
SQL Performance
SQL Download, SQL Scripts, SQL Server Security

SELECT vs. SET for local variables: SELECT can assign several at once and runs faster in a loop, while SET is the ANSI standard and assigns one at a time.

Read More
SQL SERVER - Difference Between Unique Index vs Unique Constraint

SQL SERVER – Difference Between Unique Index vs Unique Constraint

April 26, 2007
Pinal Dave
SQL Tips and Tricks
SQL Constraint and Keys, SQL Index, SQL Scripts

Unique Index vs Unique Constraint: is there a difference? No. A unique constraint creates a unique index, and performance is the same. Syntax for both.

Read More
Configure and reconfigure options.

SQL SERVER – Enable xp_cmdshell using sp_configure

April 26, 2007
Pinal Dave
SQL Tips and Tricks
PowerShell, SQL Scripts, SQL Server, SQL Server Configuration, SQL Server Security, SQL Stored Procedure, SQL Utility

Enable xp_cmdshell with sp_configure: turn on show advanced options, set xp_cmdshell to 1 and run RECONFIGURE. The full script is ready to run in SSMS.

Read More
Previous 1 … 351 352 353 354 355 356 357 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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