One of the difficult parts of developing anaylsis services cubes is determining which aggregations should be chosen. Yaniv Mor brings us the second part of his series and examines using Usage Based Optimization in SQL Server 2005.
2006-05-30
8,107 reads
This project was done using SQL Server 2005 Enterprise Edition (with SP1 beta) using the BULK INSERT command with 60 parallel input files, each of approximately 16.67 GB. The best time I got was 50 minutes. Hewlett Packard was kind enough to loan me some time one night on the machine they use to do the TPC-H tests. It is an Itanium2 Superdome with 64 1.6GHZ 9M (Madison) CPUs. For the insert tests the system was equipped with 256GB of RAM. The HP SAN configuration is rated at 14GB per second throughput.
2006-05-30
2,290 reads
At just about every talk I give I always try to make several consistent statements. One of which is: ‘Whenever possible use stored procedures to access your data’.
2006-05-29
3,437 reads
Let me start by stating some disclaiming remarks. I'm not against stored procedures in general, I find that the choice why procedures should be used, should be based on proper facts, not on claims without any proof.
2006-05-29
4,315 reads
Part 1 of a 4 part series about ADO, this is a beginner level article designed to get you started using the ADO connection object. If you haven't used ADO so far, why not see what it's all about?
2006-05-26 (first published: 2001-11-08)
31,330 reads
This is a good explanation on how to acctually bill a customer for your service over a credit card in your web application.
2006-05-26
2,841 reads
Everyone wants a highly available system, but achieving 4 or 5 9s of uptime is hard to do. Especially when you have cost limitations. New author Mark Cook takes a look at how his company analyzed the challenges and which method they chose along with some implementation details.
2006-05-25
5,300 reads
Continuing our coverage of topics dealing with various aspects of managing SQL Server 2005 Integration Services packages, which we started with an overview of their storage and deployment, we now turn our focus to their execution.
2006-05-25
1,816 reads
Not the traditional overview here. Steve Jones takes a look at the various high availability technologies from a different perspective.
2006-05-24
17,992 reads
This article, published in the June 2005 issue of SIGMOD Record, provides an overview of SQL Server Data Mining from a standards perspective.
2006-05-24
2,097 reads
A while back I wrote a quick post on setting up key mappings in...
By Steve Jones
In 100 years a lot of what we take to be true now will...
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
Hi, i'm running vs2022. I'm trying out a c# script that i'd like to...
Comments posted to this topic are about the item Missing the Jaro Winkler Distance
I upgraded a SQL Server 2019 instance to SQL Server 2025. I wanted to test the fuzzy string search functions. I run this code:
SELECT JARO_WINKLER_DISTANCE('tim', 'tom')
I get this error message:Msg 195, Level 15, State 10, Line 1 'JARO_WINKLER_DISTANCE' is not a recognized built-in function name.What is wrong? See possible answers