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 - Introduction to Filtered Index - Improve performance with Filtered Index

SQL SERVER – Introduction to Filtered Index – Improve performance with Filtered Index

September 1, 2008
Pinal Dave
SQL Tips and Tricks
SQL Index, SQL Scripts, SQL Server

A Filtered Index in SQL Server 2008 indexes only some rows of a table, which can speed up queries and cut index storage and upkeep. Example on the Employee table.

Read More
SQL Server Management Studio query window with script.

SQL SERVER – 2008 – Introduction to Table-Valued Parameters with Example

August 31, 2008
Pinal Dave
SQL Performance
SQL Scripts, SQL Stored Procedure, SQL Utility

Table-Valued Parameters in SQL Server 2008 let you pass many rows to a stored procedure without a temp table. I walk through the steps with a Department example.

Read More
SQL SERVER - Few Useful DateTime Functions to Find Specific Dates

SQL SERVER – Few Useful DateTime Functions to Find Specific Dates

August 29, 2008
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Function, SQL Scripts

Useful DateTime functions from Vivek Jamwal: find today, yesterday, and the first and last day of the current or last week and month with DATEADD.

Read More
SQL SERVER - 2008 - Introduction to Merge Statement - One Statement for INSERT, UPDATE, DELETE

SQL SERVER – 2008 – Introduction to Merge Statement – One Statement for INSERT, UPDATE, DELETE

August 28, 2008
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Joins, SQL Scripts, SQL Server

The SQL Server 2008 Merge Statement does INSERT, UPDATE and DELETE in one statement and reads the data only once. An introduction to how it works and its syntax.

Read More
SQL Server Management Studio query window.

SQL SERVER – How to Rename a Column Name or Table Name

August 26, 2008
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Stored Procedure

How to rename a column or a table in SQL Server with sp_RENAME, with a video and a simple AdventureWorks example for each case.

Read More
An painting shows a branching vine supported by a walnut trellis beside neatly arranged brass clips.

Recursive CTE Performance: Index the Child Lookup

August 25, 2008
Pinal Dave
SQL Performance
SQL Index, SQL Performance, SQL Scripts

Recursive CTE performance depends on finding the next children efficiently. Compare identical rows and actual plans before accepting an index change.

Read More
SQL SERVER - Fix : Error : 40 - could not open a connection to SQL server - Fix Connection Problems of SQL Server

SQL SERVER – Fix : Error : 40 – could not open a connection to SQL server – Fix Connection Problems of SQL Server

August 24, 2008
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts, SQL Server Security

Still stuck on Error 40, could not open a connection to SQL server? Here are more suggestions to fix connection problems, beyond my first two articles.

Read More
Previous 1 … 302 303 304 305 306 307 308 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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