Sam Bendayan

Technical Article

Beware the REPLACE function when doing heavy string parsing

I found something interesting the other day. I was attempting to optimize a very heavy string parsing routine using T-SQL and was having problems. I don’t normally use T-SQL for such heavy string parsing, but this was a special case of a legacy structure that I had to work with, so I had no choice.

You rated this post out of 5. Change rating


5,504 reads

Technical Article

To Date or Not To Date….

OK….so I’m in the middle of a very interesting Effective Dating project…basically we’re dealing with some tables that only store current data, but there is a need for future-dated data as well. Because the base table can’t hold that data...

You rated this post out of 5. Change rating


3,057 reads

Technical Article

What's a DBA

Most of us are tired of this overused, vague term. How many of you have clicked on a 'DBA' job posting only to find that it's not what you do? Or asked for a DBA resume from a recruiter and gotten something other than what you expected? Or...

You rated this post out of 5. Change rating


1,999 reads


Creating an Empty Repo in GitHub–#SQLNewBlogger


I saw someone struggling with getting started with a Visual Studio project and Azure...

Product Review: DataVeil


If you’re looking at data masking tools, I recently was able to review the...

The Last Price Bump for the Data Community Summit


This week the cost of the PASS Data Community Summit jumps up to full...

Read the latest Blogs


Copying an old database to a new database

By paul 69259

Hi All, I've got a write a program to copy the data from one...

Transaction log full due to LOG_BACKUP

By JasonO

1 of my production database's transaction log file is full due to some backup...

Calender Error in SSRS with SSAS Tabular Source


I have a report which get a Date Parameter.. I don't want to display...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers