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

2009-08-27

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

2009-05-18

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

2009-05-14

1,999 reads

Blogs

Get Configuration Change History From the SQL Server Error Logs

By

Get Configuration Change History From the SQL Server Error Logs There...

A Study in SQL Server Ad hoc Query Plans

By

A Study in SQL Server Ad hoc Query Plans ...

Read the latest Blogs

Forums

CXConsumer wait type issue

By saum70

hello, my query is select * into #TmpA from tblA (nolock). tblA contains 116000000...

How to speed up this?

By water490

Hi everyone One of my SSIS components seem to be very slow.  I am...

Managing some particular dimensions in a data warehouse based on medical records

By pmscorca

Hi, I need to design a data warehouse solution to manage medical records about...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers