In this article, adapted from the just-published second edition of MDX Solutions that Chris co-authored with George Spofford, Siva Harinath, Dylan Hai Huang, and Francesco Civardi, Chris shows us how to start exploring the world of cubes and MDX Scripts.
2006-04-30
1,472 reads
Display a person's initials regardless if they have a middle name or not.Just pass in the persons name
2006-05-15 (first published: 2006-04-27)
586 reads
There is a world of difference between the business processes that really take place in a company and the management's understanding of those processes…
2006-04-27
2,351 reads
2006-05-16 (first published: 2006-04-26)
281 reads
2006-05-17 (first published: 2006-04-25)
273 reads
The calculation of distance between two points using standard spherical geometry can be inaccurate for short distances (ten miles or less) because the sine function of very small angles approaches zero. The haversine approach (http://en.wikipedia.org/wiki/Haversine_formula) turns this around, so it is very accurate at small distances but has larger errors (about ten miles) for points […]
2006-05-18 (first published: 2006-04-25)
700 reads
This function allows you to calculate the distance in miles or kilometers between any two points on the earth. I created to calculate the distance between two zip codes but is can be used for any two coordinates for which latitude and longitude is known.NOTE: A database for the coordinates of any US postal code […]
2006-04-25 (first published: 2006-04-12)
1,282 reads
Both Sachinvaishnav and Mark Chad have submitted scripts to populate a column with a sequence number. The first solution uses a cursor; the second uses the SQL 2005 ROW_NUMBER() function.v1:http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1643v2:http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1664Since neither script requires a specific order for the sequence number, the same result can be achieved with a single UPDATE statement.
2006-04-26 (first published: 2006-04-11)
403 reads
Will multiple processors or a dual core processor be beneficial to you, and what are the differences between them? These are the questions this article will attempt to lay to rest.
2006-04-04
6,052 reads
In this article I will show you how you can implement security on a WCF service. There are many options and extensibility points for implementing security in WCF. You can also use specific products, such as the Windows 2003 Server Authorization Manager, together with WCF to implement the authorization requirements of a solution. Out of the box, WCF supports Windows credentials, Username Tokens and X.509 Digital Certificates as security credentials.
2006-04-03
1,557 reads
By SQLPals
SQL Server instance metadata inventory with PowerShell and SMO The purpose...
Disclosure: this post may contain links to books as an affiliate link. If you...
By Vinay Thakur
Google has contributed a lot of stuff/enhancement on its portfolio, google is no longer...
Comments posted to this topic are about the item Celebrating 30 years of PostgreSQL,...
Hello, has anyone here ever provisioned and actually used an MS SQL Server with...
Comments posted to this topic are about the item No More Deadlocks
After detecting deadlocks in SQL Server 2025 and lowering the time threshold for detecting future issues, when does the Database Engine return to the 5s default interval?
See possible answers