Work Habits
I enjoy woodworking as a hobby and as I try new things I find that my work habits during the...
2009-08-31
2,092 reads
Blogs
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
There is no excuse
I read Jack Corbett's blog entry,No Training Budget Still No Excuse, last week and thought it was excellent. In fact,...
2009-08-21
1,956 reads
How Much Should You Post Online About Your Life?
I’ve touched on it some in the past, but it’s a question that comes up a lot when we discuss...
2009-08-21
2,360 reads
I/O I/O - It's why my server's slow.....Examing I\O Statistics
I/O I/O - It's why my server's slow.....
Often I've been curious about ways to measure the performance of SQL Server, and...
2009-08-20
4,229 reads
Replication – Accommodating Application Inserts
Recently I have been involved in lots of projects involving replication. I have done some things to make replication work...
2009-08-19
1,759 reads
Evil Code
/*
A couple
of years ago, when I wrote the Simple-Talk Prettifier that is really no more than a stored
procedure...
2009-08-18
2,619 reads
The Joy of Data Modelling.
You may think that the task of teasing out the exact nature
of the data and processes within a company...
2009-08-17
2,916 reads
Writing Technical Content for PASS
We’ve just posted our core guidelines for technical content on sqlpass.org. The short story is there are three main ways...
2009-08-17
976 reads
Adding Multiple Columns to a Table With a Single T-SQL Statement
You know, I believe the old saying, “If you don’t use it you will lose it”. Well, I write a...
2009-08-13
38,455 reads
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers