SQLSaturday Orlando Marketing Plan-Part 35

Quick update on registrations. We’re at 287 as of noon on August 15th, not bad. The blue part of the...

USING SQL & POWERSHELL – Different Methods to List Databases WITH Recovery Models

USING POWERSHELL TO LIST SQLSERVER USER DATABASES WITH RECOVERY MODELS
One of op requested to list all the user defined databases...

A Full Day of Query Tuning

I’m excited to able to say that I’ve been given the opportunity to put on a full day workshop at...

Announcing SQL Server Radio – English Edition!

About a year and a half ago, I approached Guy and asked him if he wanted to start a podcast...

AVG() function in SQL Server

Avg():- This function is used to get the average value of a numeric column

Syntax:-

      SELECT AVG(column_name) FROM table_name

In this article,...

Effects of sp_rename on Stored Procedures

There comes a time when mistakes are made.  Sometimes those mistakes can be as annoying as a spelling mistake during the creation of a stored procedure.  When a mistake...

Export XML Columns to Individual Files

I was reading SqlServerCentral.com Articles Requested forum and saw this request.
Looking for an article that takes data from an XML...

Guest Post on SQL Authority – Default Trace & Deleted Databases

I had the opportunity to write another guest post at SQL Authority:
Finding Out What Changed in a Deleted Database
This one...

IN clause in SQL Server

With IN clause, we can specify multiple values in a WHERE clause.

For example, in case of "IN", one can use...

LEN() function in SQL Server

LEN():- This function is used to get the length of the given string value.

  Syntax:-

    Select len (stringvalue)

  For example,

   ...