2004-09-25
60 reads
Additional Articles
2004-09-25
583 reads
2004-09-25
79 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)
156 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)
109 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
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
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...
Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
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