fnCharPad

This function allows the user to pass in a string / character value and it     will padd the value according to given parameters. The parameters are as follows:@ValueToPad = Value to be padded by function.@PadCharacter = Character used to pad a given value.@Justification = Justification format bit 0 - Value will be RIGHT justified […]

2002-09-06

245 reads

spEasyBackup

Database backup made simple. You dont even have to pass any parameters if desired. It will all be handled for you.Capable of Net Send status notifications and writes status message to Windows event log.Side Effects:When not passing any @database params the the backup is done of the database where the proc resides. That means if […]

2002-09-06

560 reads

Blogs

One Thousand SQL Saturdays (*ish)

By

This weekend is SQL Saturday #1000, running virtually from Oregon. It’s a good schedule,...

Top Azure Synapse Analytics and Power BI questions

By

I have listed below the top questions I see from customers about Azure Synapse...

Pre-Conference Workshop and Sessions at PASS Summit

By

I’m pleased to announce that I will be presenting at PASS Summit. This year...

Read the latest Blogs

Forums

Index scan

By hello.priyanka

Hi, I have a query as below: ;With P As (Select ProductID --Query that...

why cannot use ClientProcessID to trace data in SQL Server Profile.

By 892717952

A C/S system is running on a SQL Server database, and I get its...

Copying an Azure SQL Database with PowerShell

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Copying an Azure SQL Database...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers