21  1888 
Oh geez. I guess a car must be a death trap if no crash test reports are
available six months before release, eh?
"rkusenet" <us*******@gmai l.com> wrote in message
news:39******** *****@individua l.net... Trolling before someone else does -)
http://www.eweek.com/article2/0,1759,1776048,00.asp
Interesting article but a couple months back Infoweek carried an
article that stated that the beta version was missing the optimizer.
If I was in charge of the project I would want the otimizer beta tested
also, but just because I think all the code should be beta tested does
not mean MS's approach is wrong. It does however raise questions about
why the beta engine is claimed to be non-optimizing. It could be that
MS is having trouble getting the optimizer to work correctly, or they
could be planning to spring a surprise. In another few months we will
find out.
-- Mark D Powell --
You forgot the bit where they ask 12 unattributed individuals who say off
the record that they are seriously considering switching to Ford instead...
It of course true that we still don't know how an unreleased product runs
software that no-one uses to do anything other than generate marketing. I'll
not sleep easy tonight no sir.
--
Niall Litchfield
Oracle DBA http://www.niall.litchfield.dial.pipex.com
"Aaron [SQL Server MVP]" <te*****@dnartr eb.noraa> wrote in message
news:e0******** ******@TK2MSFTN GP14.phx.gbl... Oh geez. I guess a car must be a death trap if no crash test reports are
available six months before release, eh?
"rkusenet" <us*******@gmai l.com> wrote in message
news:39******** *****@individua l.net... Trolling before someone else does -)
http://www.eweek.com/article2/0,1759,1776048,00.asp
> not mean MS's approach is wrong. It does however raise questions about why the beta engine is claimed to be non-optimizing. It could be that
MS is having trouble getting the optimizer to work correctly, or they
could be planning to spring a surprise.
Personally, I think there is some value in getting the functionality
perfected before you start optimizing performance. It's the same approach I
take with many of my development efforts. Of course, when you get down to
the final few tweaks, the impact of each can affect the other in minor ways.
But there was a large portion of completely new functionality in this
release, and I'm glad they focused on having new functions return the right
answer, rather than return the wrong answer a little bit faster.
But I agree, we will have to wait and find out. eWeek's statements that
because no TPC-C score is available now, performance in the release will
suck, are just asinine.
A
The article said ... "TPC benchmarks are one of several criteria
customers use to choose a high-end, scalable database"
Guess we can all chip in with how knowledgeable the writer is about how
the database selection process is, eh?
> Interesting article but a couple months back Infoweek carried an article that stated that the beta version was missing the optimizer.
I'd like to see that article. :-)
The execution engine cannot execute an SQL query. It needs a execution plan. The execution plan is
generated by the optimizer.
Now, the optimizer might not have been as polished at that point in time as it will be in the
released version, but that is of course the case with all parts of a product.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Mark D Powell" <Ma*********@ed s.com> wrote in message
news:11******** *************@l 41g2000cwc.goog legroups.com... Interesting article but a couple months back Infoweek carried an
article that stated that the beta version was missing the optimizer.
If I was in charge of the project I would want the otimizer beta tested
also, but just because I think all the code should be beta tested does
not mean MS's approach is wrong. It does however raise questions about
why the beta engine is claimed to be non-optimizing. It could be that
MS is having trouble getting the optimizer to work correctly, or they
could be planning to spring a surprise. In another few months we will
find out.
-- Mark D Powell --
> I'd like to see that article. :-) The execution engine cannot execute an SQL query. It needs a execution
plan. The execution plan is generated by the optimizer.
I was going to make the same comment but I think the difference between "the
optimizer" and "an optimized optimizer" might have been lost.
Now, the optimizer might not have been as polished at that point in time
as it will be in the released version, but that is of course the case with all parts of a
product.
Right, I guess most people have forgotten that we're not even at beta 3 yet.
<<Personally, I think there is some value in getting the functionality
perfected before you start optimizing performance. It's the same
approach I take with many of my development efforts. >>
This statement I disagree with. I have seen to many software projects
fail (not just RDBMS project's, but others, as well) because
performance was not designed into the application from day one.
Usually performance is directly related to application design.
I can create a Fred Flintstone car tomorrow that I move with my legs
that is totally functional, but it probably wouldn't sell too well.
Regards,
Steve
> This statement I disagree with.
That's fine. Your analogy of a Flintstone car is incorrect, however. I
wouldn't consider a car that you "drive" with your feet fully functional.
In addition, you failed to identify that it's not a one-or-the-other thing.
You do both, but fine-tuning performance (not designing for general
performance, that's always a goal when implementing the design from the
start) doesn't need to be done until you're sure the tool does what it's
supposed t.
It's just a different approach, not a right/wrong thing. Maybe the software
projects you've seen fail just didn't have the right people.
--
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: B Moor |
last post by:
SServer PC: Win SBS 2003 with 2.6 GHz processor and 1GB RAM
SQL Server 2000 v 2000.8.00.76 (sp3)
MS Office 2k3
MSJet ms04-014 (latest ost sp8)
MDAC v2.8 RTM
ADO 2.1
vb6.exe / ADO 2.0
I think this is a SQL Server/ADO problem as I have 2 applications with
|
by: B Moor |
last post by:
Host PC: Win SBS 2003 with 2.6 GHz processor and 1GB RAM
SQL Server 2000 sp3 (or latest).MS Office 2k3
I have the access 2k3 front end running on server (this may get
changed) and all was well until an upgrade 1 week ago when I installed
a new version of the mde (with very minor changes) and a new VB
application via a VB6 installer setup.exe.
Access uses odbc to linked tables on SQL Server, plus a few local
tables.
|
by: B Moor |
last post by:
Hello,
I am quite bogged down with this problem and would like some tips/help
if any one has any.
Thanks in advance.
The Problem
-----------
This system initially seemed quite stable for a few weeks but now,
|
by: ikshefem |
last post by:
I often need to re-code for myself a small code snippet to define
string.upto() and string.from(), which are used like :
# canonical examples
> "1234456789".upto("45")
'1234'
> "123456dd987".from('d')
'd987'
# if not found, return whole string
|
by: alwinkotiya |
last post by:
Hi all,
If I set recovery model SIMPLE then truncation of log files will be
automated , but I will lose
database changes made since the last backup was taken.
Is there any way to automate truncation of log file and
backup of database upto last change has been done????
Plz Help.
| | |
by: =?Utf-8?B?Tml5YXpp?= |
last post by:
Hi all,
Does anyone know how to embed the Excel file in VB.NET 2005 Resources?
Here is what I am doing at the moment:
1) In my VB.NET 2005 project code I load the excel with it path into string
as:
------------------------------------------------------------------------------------------------
Dim fileNameXL As String = "_MYEXCEL_REPORTS.XLS"
Dim pathNameXL As String = "\EXCEL_TEMP\"
|
by: =?Utf-8?B?ZHZhcm1h?= |
last post by:
Hi
I am executing a Sql Server SP from my C# app
One of the parameters is of type varbinary. Since the content length of this
parameter is variable I cannot set it to a pre-defined length. What do I set
the parameter size to ?
I can set it to -1 but does -1 means variable upto maximum size of Varbinary
type ?
Regards
|
by: ianwr |
last post by:
Hi,
I was wondering if anyone could shed any light on performance problems
we are having with sql 2005. We have 3 boxes which are all 64bit
itanium boxes (4 CPU) connected to a 145 spindle SAN using a 2gb FC
card. All 3 servers also have identical builds of windows 2003 sp1.
The performance on the 2005 boxes has always seemed to be worse than
the 2000 box for some reason. to checkout the san performance i ran
sqlio and when the box is...
|
by: priyamtheone |
last post by:
Hi everyone,
I'm working with VB.Net 2005(.Net framework 2.0). I am having a problem in accessing the items in a menustrip of a form. Suppose there is an item in a menustrip named FILE. Under the FILE item there are 3 subitems- OPEN, SAVE and EXIT. Now, I wanna access and disable the 2nd subitem i.e. SAVE with its index value. In VB.Net 2002 it could be done by the following code:
Me.Menu.MenuItems(0).MenuItems(1).Enabled=False
The first...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
