More posts coming soon...
Haven't been around for a while, but doing some interesting work with Database Refactoring and Effective Dating...more posts coming soon....
2010-03-10
595 reads
Sam Bendayan
Effective Dating Series Part I - The Problem
What are the benefits of Effective Dating and what problems does it solve?
2009-10-01
10,244 reads
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.
2009-08-27
5,504 reads
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...
2009-08-23
8,689 reads
Trouble printing out long VARCHAR(MAX) strings?
Ever try to print out a long VARCHAR(MAX)/NVARCHAR(MAX) string, only to find that it's truncated at 8,000/4,000 characters? How do you get around this? New author Sam Bendayan shows us how.
2009-07-29
12,055 reads
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...
2009-05-18
3,057 reads
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...
2009-05-14
1,999 reads
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...
2009-05-13
1,627 reads
Welcome to Sam Bendayan's 2 cents.....content coming soon...
You will be at least 2 cents richer....
2009-05-12
538 reads
What's a 'DBA'?
Most of us are tired of this overused, vague term. How many of you have clicked on a 'DBA' job...
2009-05-12
1,204 reads
Blogs
Take Time to Gain Perspective
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
The Fringe Festival
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
Forums
Alamat Kantor BCA KCU BOGOR Tlp:08217555651
WA CS 628217555651 Jl. Ir. H. Juanda No.28, RT.03/RW.02, Paledang, Kecamatan Bogor Tengah, Kota...
Alamat Kantor BCA KCU Sukabumi Tlp:08217555651
WA CS 628217555651 Jl. A. Yani No.33-35, Gunungparang, Kec. Cikole, Kota Sukabumi, Jawa Barat...
Alamat Kantor BCA KCU Karawang Tlp:08217555651
WA CS 628217555651 Jl. Interchange Karawang Barat, Purwadana, Karawang, 41361, Purwadana, Telukjambe Timur, Karawang,...
Question of the Day
The SQL Server MCP Server
How do I get an MCP server for my SQL Server 2025 database from Microsoft?
See possible answers