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 - Creating Comma Separate Values List from Table - UDF - SP

SQL SERVER – Creating Comma Separate Values List from Table – UDF – SP

May 6, 2007
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts

Three ways to build a Comma Separate Values List from a table: COALESCE, a smart SELECT, or a cursor. Written for SQL Server 2005 with VARCHAR(MAX).

Read More
SQL SERVER - UDF - Function to Convert List to Table

SQL SERVER – UDF – Function to Convert List to Table

May 6, 2007
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts

A UDF, udf_List2Table, to convert list to table with any delimiter you choose. Written for SQL Server 2005 with VARCHAR(MAX), and easy to adapt for 2000.

Read More
SQL SERVER - 2005 Enable CLR using T-SQL script

SQL SERVER – 2005 Enable CLR using T-SQL script

May 5, 2007
Pinal Dave
SQL Tips and Tricks
CLR, SQL Scripts, SQL Server Configuration, SQL Server Security

In SQL Server 2005 the CLR is off by default. Here is the sp_configure script to enable CLR, turning on show advanced options and then clr enabled.

Read More
SQL SERVER - UDF - User Defined Function to Find Weekdays Between Two Dates

SQL SERVER – UDF – User Defined Function to Find Weekdays Between Two Dates

May 5, 2007
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Function, SQL Scripts, SQL Utility

A user defined function that returns the number of weekdays between two dates, skipping Saturday and Sunday. It was written by Alexander Chigrik.

Read More
A rich gouache cabinet separates ceramic pieces, carved molds and brass connectors in three independent drawers.

SQL SERVER – What DBCC Memory Cache Commands Actually Clear

May 3, 2007
Pinal Dave
SQL Tips and Tricks
SQL Memory, SQL Scripts, SQL Server, SQL Server DBCC, SQL Stored Procedure

SQL Server retains memory caches to support later work. I investigate memory pressure before trying to release them.

Read More
A gouache key cupboard keeps a heavy brass key separately from everyday keys, beside a closed lockbox.

SQL SERVER – Enable Login – Disable Login using ALTER LOGIN – Change name of the ‘SA’

May 3, 2007
Pinal Dave
SQL Tips and Tricks
SQL Login, SQL Scripts, SQL Server, SQL Server Security

ALTER LOGIN can enable, disable or rename a SQL Server login. I verify another administrative access path before changing sa.

Read More
SQL SERVER - 2005 TOP Improvements/Enhancements

SQL SERVER – 2005 TOP Improvements/Enhancements

May 2, 2007
Pinal Dave
SQL Performance
SQL Scripts

SQL Server 2005 brings two enhancements to the TOP clause: pass a variable or sub-query as the TOP value, and use TOP in INSERT, UPDATE and DELETE.

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

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