Technical Article

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

253 reads

Technical Article

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

564 reads

Blogs

Experimenting with RedisGraph on Docker and Windows

By

I have been experimenting a bit with graph databases, trying to learn more about...

Resources for Adding Graph Structures to Your Database at VS Live

By

Thanks to everyone who attended my talk at VS Live Las Vegas 2023 on...

Resources for Architecting Zero Downtime Deployments

By

I delivered my talk on Architecting Zero Downtime Deployments yesterday at VS Live Las...

Read the latest Blogs

Forums

Best way to ETL on large tablle with columnstore index

By SQL_Surfer

I have a table with 489M rows and growing. The reason we had to...

Unable To Create Transactional Replication - Microsoft SQL Error 20026

By maroju1

Hi All, This is Naveen Maroju. My previous DBA was created distribution database later...

Grouping the first letter in a string

By sathishkm

Hi All, I have the column of data in SQL Server. Here  I need...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Cloud Diagrams

See possible answers