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
585 reads
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
585 reads
What are the benefits of Effective Dating and what problems does it solve?
2009-10-01
9,763 reads
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
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,548 reads
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
11,404 reads
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
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
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,608 reads
You will be at least 2 cents richer....
2009-05-12
526 reads
Most of us are tired of this overused, vague term. How many of you have clicked on a 'DBA' job...
2009-05-12
1,177 reads
By Steve Jones
feresy – n. the fear that your partner is changing in ways you don’t...
This article provides a comprehensive overview of the ORDER BY clause within SQL window...
Want to build a data analytics foundation that transforms raw data into valuable business...
Comments posted to this topic are about the item The Cloud Security Problem, which...
Hi, I have a simple table with 5 columns as follows with about 80,000...
hi everyone I have a SP that is run in SSIS. That particular SP...