2004-09-25
579 reads
Additional Articles
2004-09-25
75 reads
spilt function
Many a times we need to split a string into its indivisual words and return a array like the Split function of Visal Basic which accepts a delimeter. Here is a script which assumes the delimeter to be the space character and works in a similar method.
2004-09-24 (first published: 2004-03-25)
151 reads
Not All SQL Server Indexes Are Created Equal
Just because a column has an index doesn't mean the SQL Server Query Analyzer will use it. Learn how to create indexes SQL Server will use.
2004-09-24 (first published: 2001-04-22)
4,826 reads
Systems Thinking
J.D. Edwards was big on Systems Thinking, a way of looking at your systems and improving their functions. It was applied it to IT to become one of the top IT organizations to work for. Read some of these articles for an overview of how this works.
2004-09-24
2,685 reads
function to get the number of days in a month
This functin returns the number of days in a month, given the month and the year. It does this by adding 1 month to the first of the month, substract 1 day and get the day part of the result.
2004-09-23 (first published: 2004-03-30)
100 reads
A Survey of Microsoft SQL Server 2000 XML Features
An oldy, but good basic look at XML and how it fits into SQL Server 2000.
2004-09-23
3,008 reads
The SQL of OLAP
A look at how OLAP and Anlysis services might fit into your business and some things to think about when a business intelligence system might be right for you.
2004-09-22
2,400 reads
Scanning the network for SQL Server
Have you ever wondered how many SQL Servers are on your network? Need their versions for patches, reporting, etc? Read about this technique for easily scanning for all the servers that are installed.
2004-09-21
1,691 reads
Remove multiple whitespace from a string
Simple enough routine that I've had to write I don't know how many times in different languages. It does what it says in the title i.e. kills multiple occurences of the whitespace character, leaving one behind to tell the tale.
2004-09-20 (first published: 2004-05-21)
138 reads
Blogs
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Forums
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Sql script replace and rearrange numbers
Hi everyone. I have this table and this information. (left side of the image)...