What is the latest version of MSDE (and SQL Server)
that I can install for a client that uses Windows XP ?
SQL Server 2000 SP3 ?Originally posted by Karolyn
What is the latest version of MSDE (and SQL Server)
that I can install for a client that uses Windows XP ?
SQL Server 2000 SP3 ? http://www.microsoft.com/sql/msde/downloads/download.asp|||you're early today !
happy new year !
Is there some significant performance increase
between SQL Server 7 and SQL Server 2K ?
'Cause I've done all my tests on SQL Server 7 and MSDE 7
and I was'nt impressed by the performances
(that we're comparable with thoses I had with Sybase)|||Originally posted by Karolyn
Is there some significant performance increase
between SQL Server 7 and SQL Server 2K ?
Cant comment much on that !! have not worked much on SQL Server 7.0|||Performance increases - New datatype(table), views (ability to index and partition), index enhancements such as ability to index a computed column and index creation, how text/ntext/image are stored ...
Read this article:
link (http://msdn.microsoft.com/msdnmag/issues/0800/sql2000/default.aspx)|||You left out UDFs?|||That was referencing performance increases - udfs offer reusability,maintainability and extensibility ... Anyway, all the benefits of sql server 2000 are included in the link.|||Also ... don't mention udfs for a while after the permissions bug :-)|||yeah, brett, you almost started it again|||Originally posted by rnealejr
Also ... don't mention udfs for a while after the permissions bug :-)
hey !!! what was that ??|||well, rdjabarov and blindman got at it again when an m$ bug was being discussed. apparently neither one of them can hold their waters :-)|||?? :confused: ??|||hey, it's simple:
one is a man, and another...is also a man...does it make sense?? :-)|||I mean ... can you point me to the battleground ... i would like to see the war for myself :D|||just read from the beginning (http://www.dbforums.com/t977030.html)
Showing posts with label latest. Show all posts
Showing posts with label latest. Show all posts
Wednesday, March 28, 2012
Latest version of Microsoft MBSA 1.1.1 says:
I would think that you would still want to remove the
BUILTIN\Administrators group from the sysadmin role even
on a client-only installation.
Many non-administrator users are often members of the
BULTIN\Administrators group on their own machines whether
they should be or not. These users would have the
ability to drop databases, truncate tables, etc., etc.
It may not be the most likely scenario, but stranger
things have happened...
Tim
be
has
local
login rights for it's service account, and if you use full-text make sure
[nt authority\system] has sysadmin rights....
Richard Waymire, MCSE, MCDBA
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tim Richardson" <anonymous@.discussions.microsoft.com> wrote in message
news:023601c3d948$60021dd0$a401280a@.phx.gbl...[QUOTE]
> I would think that you would still want to remove the
> BUILTIN\Administrators group from the sysadmin role even
> on a client-only installation.
> Many non-administrator users are often members of the
> BULTIN\Administrators group on their own machines whether
> they should be or not. These users would have the
> ability to drop databases, truncate tables, etc., etc.
> It may not be the most likely scenario, but stranger
> things have happened...
> Tim
>
> be
> has
> local
BUILTIN\Administrators group from the sysadmin role even
on a client-only installation.
Many non-administrator users are often members of the
BULTIN\Administrators group on their own machines whether
they should be or not. These users would have the
ability to drop databases, truncate tables, etc., etc.
It may not be the most likely scenario, but stranger
things have happened...
Tim
quote:
>--Original Message--
>The latest MBSA (1.1.1) says
>"Issue
>Local Windows administrators should not also be SQL
>database administrators. These roles are very different
>and are typically performed by different people.
>Solution
>Remove BUILTIN\Administrators from the sysadmin role."
>This makes sense for a server. Does it make sense on a
>client machine?
>I am thinking this is necessary for the server that may
be
quote:
>shared in someway; however, if I am using a setup that
has
quote:
>DISABLENETWORKPROTOCOLS=1 (no access except from the
local
quote:Make sure, however that the SQL Server Agent service still has sysadmin
>host itself), I would think this does not apply.
>Does anyone know for sure?
>Giacomo
>.
>
login rights for it's service account, and if you use full-text make sure
[nt authority\system] has sysadmin rights....
Richard Waymire, MCSE, MCDBA
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tim Richardson" <anonymous@.discussions.microsoft.com> wrote in message
news:023601c3d948$60021dd0$a401280a@.phx.gbl...[QUOTE]
> I would think that you would still want to remove the
> BUILTIN\Administrators group from the sysadmin role even
> on a client-only installation.
> Many non-administrator users are often members of the
> BULTIN\Administrators group on their own machines whether
> they should be or not. These users would have the
> ability to drop databases, truncate tables, etc., etc.
> It may not be the most likely scenario, but stranger
> things have happened...
> Tim
>
> be
> has
> local
Latest version of Microsoft MBSA 1.1.1 says:
The latest MBSA (1.1.1) says
"Issue
Local Windows administrators should not also be SQL
database administrators. These roles are very different
and are typically performed by different people.
Solution
Remove BUILTIN\Administrators from the sysadmin role."
This makes sense for a server. Does it make sense on a
client machine?
I am thinking this is necessary for the server that may be
shared in someway; however, if I am using a setup that has
DISABLENETWORKPROTOCOLS=1 (no access except from the local
host itself), I would think this does not apply.
Does anyone know for sure?
GiacomoGiacomo wrote:
> The latest MBSA (1.1.1) says
> "Issue
> Local Windows administrators should not also be SQL
> database administrators. These roles are very different
> and are typically performed by different people.
> Solution
> Remove BUILTIN\Administrators from the sysadmin role."
> This makes sense for a server. Does it make sense on a
> client machine?
> I am thinking this is necessary for the server that may be
> shared in someway; however, if I am using a setup that has
> DISABLENETWORKPROTOCOLS=1 (no access except from the local
> host itself), I would think this does not apply.
> Does anyone know for sure?
There is not much "for sure" in security issues, just which side of a
compromise makes the most sense for you.
For me, one of the most compelling reasons to do this on a local workstation
copy of SQL is that only my SQL developers have this, and both i and they
would want to mimic the conditions the live system they are developing for
runs under as much as possible.
We've had issues in the past where a, pardon me, less diligent developer who
has had admin rights to everything on their dev machine didn't bother coding
to take security into account so their code wouldn't run on a live system
without a lot of re-working.
"Issue
Local Windows administrators should not also be SQL
database administrators. These roles are very different
and are typically performed by different people.
Solution
Remove BUILTIN\Administrators from the sysadmin role."
This makes sense for a server. Does it make sense on a
client machine?
I am thinking this is necessary for the server that may be
shared in someway; however, if I am using a setup that has
DISABLENETWORKPROTOCOLS=1 (no access except from the local
host itself), I would think this does not apply.
Does anyone know for sure?
GiacomoGiacomo wrote:
> The latest MBSA (1.1.1) says
> "Issue
> Local Windows administrators should not also be SQL
> database administrators. These roles are very different
> and are typically performed by different people.
> Solution
> Remove BUILTIN\Administrators from the sysadmin role."
> This makes sense for a server. Does it make sense on a
> client machine?
> I am thinking this is necessary for the server that may be
> shared in someway; however, if I am using a setup that has
> DISABLENETWORKPROTOCOLS=1 (no access except from the local
> host itself), I would think this does not apply.
> Does anyone know for sure?
There is not much "for sure" in security issues, just which side of a
compromise makes the most sense for you.
For me, one of the most compelling reasons to do this on a local workstation
copy of SQL is that only my SQL developers have this, and both i and they
would want to mimic the conditions the live system they are developing for
runs under as much as possible.
We've had issues in the past where a, pardon me, less diligent developer who
has had admin rights to everything on their dev machine didn't bother coding
to take security into account so their code wouldn't run on a live system
without a lot of re-working.
Latest value for all members at a given point in time
We have a fact table with a current balance record. For this balance rows are added to the table only when the balance has changed. This way we can reduce the volume in the fact table by not saving redundant information for every point in time that we want to analyze.
In SQL it is a simple task to get a view of the lastest fact records for a given point in time. SELECT f1.* FROM factTable f1 WHERE f1.timestamp = (SELECT MAX(f2.timestamp) FROM factTable f2 WHERE f2.timestamp <= givenPointInTime AND f2.balanceKey = f1.balanceKey). In other words, the given point in time directly determines which rows should be fetched from our fact table, one row for each balance record (balanceKey). This row will of course include several dimension attributes, which represent the point in time when the balance changed.
Now, we would like to reproduce this behaviour in our Analysis Services 2005 cube. Using a time dimension, we would like to be able to select a given point in time and have the cube return all rows previous to that time, one row for each balanceKey. Not only the rows matching the given point in time. How can this be done? For the other dimension attributes, they should behave in a normal way, such that for the returned rows, you can slice using any combination of them.
Any help or ideas are appreciated,
Lars
Assuming that you're using AS 2005 Enterprise Edition, you could try the "Last Nonempty Child" aggregation:
http://msdn2.microsoft.com/en-us/library/ms175356.aspx
>>
SQL Server 2005 Books Online
Defining Semiadditive Behavior
Semiadditive measures, which do not uniformly aggregate across all dimensions, are very common in many business scenarios. Every cube that is based on snapshots of balances over time exhibits this problem. You can find these snapshots in applications dealing with securities, account balances, budgeting, human resources, insurance policies and claims, and many other business domains.
...
LastNonEmpty
The member value is evaluated as the value of its last child along the time dimension that contains data.
>>
|||Thanks Deepak. We are on an Enterprise Edition (pre-SP1) but we do not get the desired behaviour using the "Last Nonempty Child" aggregation. In fact, it doesn't seem to make any difference at all from using SUM. We have created an example containing a relational database with a simple fact table and an analysis services database built upon it with a measure called "Account Balance". If we browse the cube and add the measure and the Account dimension to the results pane, then filter based on the Time dimension and select the date 2005-12-31, Account number 3 should display the balance 400. Currently it does not.
The example (SQL script + XMLA script) can be found at: http://www.intellibis.se/pub/CumulativeExample.zip
Can anyone help us?
Regards,
Lars
Latest Updates
Can some tell me where I can find the list of latest updates for SQL Server
2005? I'd like to find a way of being informed when the latest update is
released (I'm assuming Microsoft Update doesn't list the cumulative update
packages released every so often?)?
Thanks - John.
No, there is no definitive place to watch. I will include a bunch of posts
I have made on new builds below. I try to stay on top of it, but I am only
human, and have other responsibilities, like day job, family, etc.
http://sqlblog.com/blogs/aaron_bertrand/archive/2006/12/12/419.aspx
http://sqlblog.com/blogs/aaron_bertrand/archive/2007/03/06/service-pack-2a.aspx
http://sqlblog.com/blogs/aaron_bertrand/archive/2007/03/28/an-update-on-recent-sql-server-2005-builds.aspx
http://sqlblog.com/blogs/aaron_bertrand/archive/2007/04/04/the-drama-continues-more-post-sp2-fallout.aspx
http://sqlblog.com/blogs/aaron_bertrand/archive/2007/04/11/more-on-gdrs-qfes-and-the-aftermath-of-sp2.aspx
http://sqlblog.com/blogs/aaron_bertrand/archive/2007/05/03/some-new-or-updated-sql-server-2005-builds.aspx
http://sqlblog.com/blogs/aaron_bertrand/archive/2007/06/27/staying-on-top-of-sql-server-2005-builds-and-hotfixes.aspx
http://sqlblog.com/blogs/aaron_bertrand/archive/2007/06/27/some-new-and-updated-sql-server-2005-builds.aspx
http://sqlblog.com/blogs/aaron_bertrand/archive/2007/09/11/new-cumulative-update-is-available.aspx
http://sqlblog.com/blogs/aaron_bertrand/archive/2007/10/16/quick-update-new-cumulative-update-has-been-released.aspx
http://sqlblog.com/blogs/aaron_bertrand/archive/2008/02/06/list-of-sql-server-2005-post-sp2-builds.aspx
http://sqlblog.com/blogs/aaron_bertrand/archive/2008/02/19/i-would-rather-see-sp3-but-i-ll-take-cu6-instead.aspx
And then these guys try to keep a list too, but everyone seems to have
little holes in their lists here and there:
http://www.aspfaq.com/sql2005/show.asp?id=20
http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx
http://sqlserverbuilds.blogspot.com/
http://www.sqlservercentral.com/articles/Administration/2960/
Microsoft is trying to maintain a list, but the following one is only 3152+
http://support.microsoft.com/kb/937137/
"John Davis" <jdavis707@.hotmail.com> wrote in message
news:uTv4DiMkIHA.2276@.TK2MSFTNGP05.phx.gbl...
> Can some tell me where I can find the list of latest updates for SQL
> Server 2005? I'd like to find a way of being informed when the latest
> update is released (I'm assuming Microsoft Update doesn't list the
> cumulative update packages released every so often?)?
> Thanks - John.
|||You'd think the best place to keep track of this type of stuff would MS <sigh>.
Linchi
"Aaron Bertrand [SQL Server MVP]" wrote:
> No, there is no definitive place to watch. I will include a bunch of posts
> I have made on new builds below. I try to stay on top of it, but I am only
> human, and have other responsibilities, like day job, family, etc.
> http://sqlblog.com/blogs/aaron_bertrand/archive/2006/12/12/419.aspx
> http://sqlblog.com/blogs/aaron_bertrand/archive/2007/03/06/service-pack-2a.aspx
> http://sqlblog.com/blogs/aaron_bertrand/archive/2007/03/28/an-update-on-recent-sql-server-2005-builds.aspx
> http://sqlblog.com/blogs/aaron_bertrand/archive/2007/04/04/the-drama-continues-more-post-sp2-fallout.aspx
> http://sqlblog.com/blogs/aaron_bertrand/archive/2007/04/11/more-on-gdrs-qfes-and-the-aftermath-of-sp2.aspx
> http://sqlblog.com/blogs/aaron_bertrand/archive/2007/05/03/some-new-or-updated-sql-server-2005-builds.aspx
> http://sqlblog.com/blogs/aaron_bertrand/archive/2007/06/27/staying-on-top-of-sql-server-2005-builds-and-hotfixes.aspx
> http://sqlblog.com/blogs/aaron_bertrand/archive/2007/06/27/some-new-and-updated-sql-server-2005-builds.aspx
> http://sqlblog.com/blogs/aaron_bertrand/archive/2007/09/11/new-cumulative-update-is-available.aspx
> http://sqlblog.com/blogs/aaron_bertrand/archive/2007/10/16/quick-update-new-cumulative-update-has-been-released.aspx
> http://sqlblog.com/blogs/aaron_bertrand/archive/2008/02/06/list-of-sql-server-2005-post-sp2-builds.aspx
> http://sqlblog.com/blogs/aaron_bertrand/archive/2008/02/19/i-would-rather-see-sp3-but-i-ll-take-cu6-instead.aspx
> And then these guys try to keep a list too, but everyone seems to have
> little holes in their lists here and there:
> http://www.aspfaq.com/sql2005/show.asp?id=20
> http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx
> http://sqlserverbuilds.blogspot.com/
> http://www.sqlservercentral.com/articles/Administration/2960/
> Microsoft is trying to maintain a list, but the following one is only 3152+
> http://support.microsoft.com/kb/937137/
>
> "John Davis" <jdavis707@.hotmail.com> wrote in message
> news:uTv4DiMkIHA.2276@.TK2MSFTNGP05.phx.gbl...
>
2005? I'd like to find a way of being informed when the latest update is
released (I'm assuming Microsoft Update doesn't list the cumulative update
packages released every so often?)?
Thanks - John.
No, there is no definitive place to watch. I will include a bunch of posts
I have made on new builds below. I try to stay on top of it, but I am only
human, and have other responsibilities, like day job, family, etc.
http://sqlblog.com/blogs/aaron_bertrand/archive/2006/12/12/419.aspx
http://sqlblog.com/blogs/aaron_bertrand/archive/2007/03/06/service-pack-2a.aspx
http://sqlblog.com/blogs/aaron_bertrand/archive/2007/03/28/an-update-on-recent-sql-server-2005-builds.aspx
http://sqlblog.com/blogs/aaron_bertrand/archive/2007/04/04/the-drama-continues-more-post-sp2-fallout.aspx
http://sqlblog.com/blogs/aaron_bertrand/archive/2007/04/11/more-on-gdrs-qfes-and-the-aftermath-of-sp2.aspx
http://sqlblog.com/blogs/aaron_bertrand/archive/2007/05/03/some-new-or-updated-sql-server-2005-builds.aspx
http://sqlblog.com/blogs/aaron_bertrand/archive/2007/06/27/staying-on-top-of-sql-server-2005-builds-and-hotfixes.aspx
http://sqlblog.com/blogs/aaron_bertrand/archive/2007/06/27/some-new-and-updated-sql-server-2005-builds.aspx
http://sqlblog.com/blogs/aaron_bertrand/archive/2007/09/11/new-cumulative-update-is-available.aspx
http://sqlblog.com/blogs/aaron_bertrand/archive/2007/10/16/quick-update-new-cumulative-update-has-been-released.aspx
http://sqlblog.com/blogs/aaron_bertrand/archive/2008/02/06/list-of-sql-server-2005-post-sp2-builds.aspx
http://sqlblog.com/blogs/aaron_bertrand/archive/2008/02/19/i-would-rather-see-sp3-but-i-ll-take-cu6-instead.aspx
And then these guys try to keep a list too, but everyone seems to have
little holes in their lists here and there:
http://www.aspfaq.com/sql2005/show.asp?id=20
http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx
http://sqlserverbuilds.blogspot.com/
http://www.sqlservercentral.com/articles/Administration/2960/
Microsoft is trying to maintain a list, but the following one is only 3152+
http://support.microsoft.com/kb/937137/
"John Davis" <jdavis707@.hotmail.com> wrote in message
news:uTv4DiMkIHA.2276@.TK2MSFTNGP05.phx.gbl...
> Can some tell me where I can find the list of latest updates for SQL
> Server 2005? I'd like to find a way of being informed when the latest
> update is released (I'm assuming Microsoft Update doesn't list the
> cumulative update packages released every so often?)?
> Thanks - John.
|||You'd think the best place to keep track of this type of stuff would MS <sigh>.
Linchi
"Aaron Bertrand [SQL Server MVP]" wrote:
> No, there is no definitive place to watch. I will include a bunch of posts
> I have made on new builds below. I try to stay on top of it, but I am only
> human, and have other responsibilities, like day job, family, etc.
> http://sqlblog.com/blogs/aaron_bertrand/archive/2006/12/12/419.aspx
> http://sqlblog.com/blogs/aaron_bertrand/archive/2007/03/06/service-pack-2a.aspx
> http://sqlblog.com/blogs/aaron_bertrand/archive/2007/03/28/an-update-on-recent-sql-server-2005-builds.aspx
> http://sqlblog.com/blogs/aaron_bertrand/archive/2007/04/04/the-drama-continues-more-post-sp2-fallout.aspx
> http://sqlblog.com/blogs/aaron_bertrand/archive/2007/04/11/more-on-gdrs-qfes-and-the-aftermath-of-sp2.aspx
> http://sqlblog.com/blogs/aaron_bertrand/archive/2007/05/03/some-new-or-updated-sql-server-2005-builds.aspx
> http://sqlblog.com/blogs/aaron_bertrand/archive/2007/06/27/staying-on-top-of-sql-server-2005-builds-and-hotfixes.aspx
> http://sqlblog.com/blogs/aaron_bertrand/archive/2007/06/27/some-new-and-updated-sql-server-2005-builds.aspx
> http://sqlblog.com/blogs/aaron_bertrand/archive/2007/09/11/new-cumulative-update-is-available.aspx
> http://sqlblog.com/blogs/aaron_bertrand/archive/2007/10/16/quick-update-new-cumulative-update-has-been-released.aspx
> http://sqlblog.com/blogs/aaron_bertrand/archive/2008/02/06/list-of-sql-server-2005-post-sp2-builds.aspx
> http://sqlblog.com/blogs/aaron_bertrand/archive/2008/02/19/i-would-rather-see-sp3-but-i-ll-take-cu6-instead.aspx
> And then these guys try to keep a list too, but everyone seems to have
> little holes in their lists here and there:
> http://www.aspfaq.com/sql2005/show.asp?id=20
> http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx
> http://sqlserverbuilds.blogspot.com/
> http://www.sqlservercentral.com/articles/Administration/2960/
> Microsoft is trying to maintain a list, but the following one is only 3152+
> http://support.microsoft.com/kb/937137/
>
> "John Davis" <jdavis707@.hotmail.com> wrote in message
> news:uTv4DiMkIHA.2276@.TK2MSFTNGP05.phx.gbl...
>
Latest Updates
Can some tell me where I can find the list of latest updates for SQL Server
2005? I'd like to find a way of being informed when the latest update is
released (I'm assuming Microsoft Update doesn't list the cumulative update
packages released every so often?)?
Thanks - John.No, there is no definitive place to watch. I will include a bunch of posts
I have made on new builds below. I try to stay on top of it, but I am only
human, and have other responsibilities, like day job, family, etc.
http://sqlblog.com/blogs/aaron_bertrand/archive/2006/12/12/419.aspx
http://sqlblog.com/blogs/aaron_bertrand/archive/2007/03/06/service-pack-2a.aspx
http://sqlblog.com/blogs/aaron_bertrand/archive/2007/03/28/an-update-on-recent-sql-server-2005-builds.aspx
http://sqlblog.com/blogs/aaron_bertrand/archive/2007/04/04/the-drama-continues-more-post-sp2-fallout.aspx
http://sqlblog.com/blogs/aaron_bertrand/archive/2007/04/11/more-on-gdrs-qfes-and-the-aftermath-of-sp2.aspx
http://sqlblog.com/blogs/aaron_bertrand/archive/2007/05/03/some-new-or-updated-sql-server-2005-builds.aspx
http://sqlblog.com/blogs/aaron_bertrand/archive/2007/06/27/staying-on-top-of-sql-server-2005-builds-and-hotfixes.aspx
http://sqlblog.com/blogs/aaron_bertrand/archive/2007/06/27/some-new-and-updated-sql-server-2005-builds.aspx
http://sqlblog.com/blogs/aaron_bertrand/archive/2007/09/11/new-cumulative-update-is-available.aspx
http://sqlblog.com/blogs/aaron_bertrand/archive/2007/10/16/quick-update-new-cumulative-update-has-been-released.aspx
http://sqlblog.com/blogs/aaron_bertrand/archive/2008/02/06/list-of-sql-server-2005-post-sp2-builds.aspx
http://sqlblog.com/blogs/aaron_bertrand/archive/2008/02/19/i-would-rather-see-sp3-but-i-ll-take-cu6-instead.aspx
And then these guys try to keep a list too, but everyone seems to have
little holes in their lists here and there:
http://www.aspfaq.com/sql2005/show.asp?id=20
http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx
http://sqlserverbuilds.blogspot.com/
http://www.sqlservercentral.com/articles/Administration/2960/
Microsoft is trying to maintain a list, but the following one is only 3152+
http://support.microsoft.com/kb/937137/
"John Davis" <jdavis707@.hotmail.com> wrote in message
news:uTv4DiMkIHA.2276@.TK2MSFTNGP05.phx.gbl...
> Can some tell me where I can find the list of latest updates for SQL
> Server 2005? I'd like to find a way of being informed when the latest
> update is released (I'm assuming Microsoft Update doesn't list the
> cumulative update packages released every so often?)?
> Thanks - John.|||You'd think the best place to keep track of this type of stuff would MS <sigh>.
Linchi
"Aaron Bertrand [SQL Server MVP]" wrote:
> No, there is no definitive place to watch. I will include a bunch of posts
> I have made on new builds below. I try to stay on top of it, but I am only
> human, and have other responsibilities, like day job, family, etc.
> http://sqlblog.com/blogs/aaron_bertrand/archive/2006/12/12/419.aspx
> http://sqlblog.com/blogs/aaron_bertrand/archive/2007/03/06/service-pack-2a.aspx
> http://sqlblog.com/blogs/aaron_bertrand/archive/2007/03/28/an-update-on-recent-sql-server-2005-builds.aspx
> http://sqlblog.com/blogs/aaron_bertrand/archive/2007/04/04/the-drama-continues-more-post-sp2-fallout.aspx
> http://sqlblog.com/blogs/aaron_bertrand/archive/2007/04/11/more-on-gdrs-qfes-and-the-aftermath-of-sp2.aspx
> http://sqlblog.com/blogs/aaron_bertrand/archive/2007/05/03/some-new-or-updated-sql-server-2005-builds.aspx
> http://sqlblog.com/blogs/aaron_bertrand/archive/2007/06/27/staying-on-top-of-sql-server-2005-builds-and-hotfixes.aspx
> http://sqlblog.com/blogs/aaron_bertrand/archive/2007/06/27/some-new-and-updated-sql-server-2005-builds.aspx
> http://sqlblog.com/blogs/aaron_bertrand/archive/2007/09/11/new-cumulative-update-is-available.aspx
> http://sqlblog.com/blogs/aaron_bertrand/archive/2007/10/16/quick-update-new-cumulative-update-has-been-released.aspx
> http://sqlblog.com/blogs/aaron_bertrand/archive/2008/02/06/list-of-sql-server-2005-post-sp2-builds.aspx
> http://sqlblog.com/blogs/aaron_bertrand/archive/2008/02/19/i-would-rather-see-sp3-but-i-ll-take-cu6-instead.aspx
> And then these guys try to keep a list too, but everyone seems to have
> little holes in their lists here and there:
> http://www.aspfaq.com/sql2005/show.asp?id=20
> http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx
> http://sqlserverbuilds.blogspot.com/
> http://www.sqlservercentral.com/articles/Administration/2960/
> Microsoft is trying to maintain a list, but the following one is only 3152+
> http://support.microsoft.com/kb/937137/
>
> "John Davis" <jdavis707@.hotmail.com> wrote in message
> news:uTv4DiMkIHA.2276@.TK2MSFTNGP05.phx.gbl...
> > Can some tell me where I can find the list of latest updates for SQL
> > Server 2005? I'd like to find a way of being informed when the latest
> > update is released (I'm assuming Microsoft Update doesn't list the
> > cumulative update packages released every so often?)?
> >
> > Thanks - John.
>
2005? I'd like to find a way of being informed when the latest update is
released (I'm assuming Microsoft Update doesn't list the cumulative update
packages released every so often?)?
Thanks - John.No, there is no definitive place to watch. I will include a bunch of posts
I have made on new builds below. I try to stay on top of it, but I am only
human, and have other responsibilities, like day job, family, etc.
http://sqlblog.com/blogs/aaron_bertrand/archive/2006/12/12/419.aspx
http://sqlblog.com/blogs/aaron_bertrand/archive/2007/03/06/service-pack-2a.aspx
http://sqlblog.com/blogs/aaron_bertrand/archive/2007/03/28/an-update-on-recent-sql-server-2005-builds.aspx
http://sqlblog.com/blogs/aaron_bertrand/archive/2007/04/04/the-drama-continues-more-post-sp2-fallout.aspx
http://sqlblog.com/blogs/aaron_bertrand/archive/2007/04/11/more-on-gdrs-qfes-and-the-aftermath-of-sp2.aspx
http://sqlblog.com/blogs/aaron_bertrand/archive/2007/05/03/some-new-or-updated-sql-server-2005-builds.aspx
http://sqlblog.com/blogs/aaron_bertrand/archive/2007/06/27/staying-on-top-of-sql-server-2005-builds-and-hotfixes.aspx
http://sqlblog.com/blogs/aaron_bertrand/archive/2007/06/27/some-new-and-updated-sql-server-2005-builds.aspx
http://sqlblog.com/blogs/aaron_bertrand/archive/2007/09/11/new-cumulative-update-is-available.aspx
http://sqlblog.com/blogs/aaron_bertrand/archive/2007/10/16/quick-update-new-cumulative-update-has-been-released.aspx
http://sqlblog.com/blogs/aaron_bertrand/archive/2008/02/06/list-of-sql-server-2005-post-sp2-builds.aspx
http://sqlblog.com/blogs/aaron_bertrand/archive/2008/02/19/i-would-rather-see-sp3-but-i-ll-take-cu6-instead.aspx
And then these guys try to keep a list too, but everyone seems to have
little holes in their lists here and there:
http://www.aspfaq.com/sql2005/show.asp?id=20
http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx
http://sqlserverbuilds.blogspot.com/
http://www.sqlservercentral.com/articles/Administration/2960/
Microsoft is trying to maintain a list, but the following one is only 3152+
http://support.microsoft.com/kb/937137/
"John Davis" <jdavis707@.hotmail.com> wrote in message
news:uTv4DiMkIHA.2276@.TK2MSFTNGP05.phx.gbl...
> Can some tell me where I can find the list of latest updates for SQL
> Server 2005? I'd like to find a way of being informed when the latest
> update is released (I'm assuming Microsoft Update doesn't list the
> cumulative update packages released every so often?)?
> Thanks - John.|||You'd think the best place to keep track of this type of stuff would MS <sigh>.
Linchi
"Aaron Bertrand [SQL Server MVP]" wrote:
> No, there is no definitive place to watch. I will include a bunch of posts
> I have made on new builds below. I try to stay on top of it, but I am only
> human, and have other responsibilities, like day job, family, etc.
> http://sqlblog.com/blogs/aaron_bertrand/archive/2006/12/12/419.aspx
> http://sqlblog.com/blogs/aaron_bertrand/archive/2007/03/06/service-pack-2a.aspx
> http://sqlblog.com/blogs/aaron_bertrand/archive/2007/03/28/an-update-on-recent-sql-server-2005-builds.aspx
> http://sqlblog.com/blogs/aaron_bertrand/archive/2007/04/04/the-drama-continues-more-post-sp2-fallout.aspx
> http://sqlblog.com/blogs/aaron_bertrand/archive/2007/04/11/more-on-gdrs-qfes-and-the-aftermath-of-sp2.aspx
> http://sqlblog.com/blogs/aaron_bertrand/archive/2007/05/03/some-new-or-updated-sql-server-2005-builds.aspx
> http://sqlblog.com/blogs/aaron_bertrand/archive/2007/06/27/staying-on-top-of-sql-server-2005-builds-and-hotfixes.aspx
> http://sqlblog.com/blogs/aaron_bertrand/archive/2007/06/27/some-new-and-updated-sql-server-2005-builds.aspx
> http://sqlblog.com/blogs/aaron_bertrand/archive/2007/09/11/new-cumulative-update-is-available.aspx
> http://sqlblog.com/blogs/aaron_bertrand/archive/2007/10/16/quick-update-new-cumulative-update-has-been-released.aspx
> http://sqlblog.com/blogs/aaron_bertrand/archive/2008/02/06/list-of-sql-server-2005-post-sp2-builds.aspx
> http://sqlblog.com/blogs/aaron_bertrand/archive/2008/02/19/i-would-rather-see-sp3-but-i-ll-take-cu6-instead.aspx
> And then these guys try to keep a list too, but everyone seems to have
> little holes in their lists here and there:
> http://www.aspfaq.com/sql2005/show.asp?id=20
> http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx
> http://sqlserverbuilds.blogspot.com/
> http://www.sqlservercentral.com/articles/Administration/2960/
> Microsoft is trying to maintain a list, but the following one is only 3152+
> http://support.microsoft.com/kb/937137/
>
> "John Davis" <jdavis707@.hotmail.com> wrote in message
> news:uTv4DiMkIHA.2276@.TK2MSFTNGP05.phx.gbl...
> > Can some tell me where I can find the list of latest updates for SQL
> > Server 2005? I'd like to find a way of being informed when the latest
> > update is released (I'm assuming Microsoft Update doesn't list the
> > cumulative update packages released every so often?)?
> >
> > Thanks - John.
>
Latest updated date of a Stored Procedure
How to get the last updated date of a Stored procedure... From the sysobjects, we are able to get the created date... but how to get the latest updated date...?
Tx
Gkhttp://www.dbforums.com/archives/t317417.html
Tx
Gkhttp://www.dbforums.com/archives/t317417.html
latest unique records, how to get?
Let's say I have a data entry from a pool of employees:
table is as follow:
EmpNo Branch Date Amount
1 A101 11/30/2007 $0.90
1 A101 11/30/2007 $1.20
2 A101 11/30/2007 $0.90
3 A101 11/30/2007 $0.80
How can I select the whole table and only take in 1 unique latest entry if there are multiple entries for the same day, same branch under same employee number?
Thanks! :DLet's say I have a data entry from a pool of employees:
table is as follow:
EmpNo Branch Date Amount
1 A101 11/30/2007 $0.90
1 A101 11/30/2007 $1.20
2 A101 11/30/2007 $0.90
3 A101 11/30/2007 $0.80
How can I select the whole table and only take in 1 unique latest entry if there are multiple entries for the same day, same branch under same employee number?
Thanks! :D
What do you mean by"select the whole table"? If you are hoping to get the "1 unique latest entry" the two statements contradict each other in my mind!
For example in your quoted sample data, what would be the result you would expect to get back? Just one row containing the $0.90 entry?
Edited to say "what consitutes 'latest' (and 'unique', come to think of it) as far as you are concerned?" If there are 14 entries for employee ID 1 on 11/30/2007 and some of them are for the same amount... what are you hoping to select? If you aren't using any kind of identity field then you must have some other way to make a record unique, right? If this is date & time, then you just select "top 1" or "max" based on the date/time field...? I must be missing something!|||Unless your dates contain a time component, or you have an incrementing surrogate key, there is no way to determine which of the records is "latest" when there are ties.|||If you happen to have a transaction log for the time in question, you could try and sift through that. Though, this would not be an easy task without a third party tool.
I believe there are two: Lumigent Log Explorer, http://www.lumigent.com and Log PI, http://www.logpi.com.
You could also try and use the DBCC LOG command, but this output is rather difficult to decipher.|||wow, that's fast reply. Sorry guys I guess I had missed out some important stuff....posted that from my office before I rushed back home.
my expected end results will be:
EmpNo Branch Date Amount
1 A101 11/30/2007 $1.20
2 A101 11/30/2007 $0.90
3 A101 11/30/2007 $0.80
the first item shall not be selected as there is a "latest" entry with the same employee number, same branch and same date. I only want one unique and latest entry from each employee in a given day. Why would that happen? somebody hand itchy and keyed in twice, or he/she keyed in the first time wrongly, and trying to key in again to replace the first one.
I have no control of the data given....this is a chuck of "dirty data" given to me. And yes, there is no time factor in this case.... :(
I think it's possible...was trying to look for a combi of "TOP" function and others. It's not going to be straight forward....
really appreciate the help from you guys! :D|||Er... but if you have no time component and no unique ID...
Hang on... where has this "dirty data" come from and what format is it in? You seem to be treating the order of the data as significant... is it some kind of flat file in which case the later rows are more recent? If so, there's something to work on, if not, there isn't! Sorry, but if you look at a given employee and there is more than one transaction on a day then what on earth separates the values? Surely you can't hope to do it on value alone?|||oh yah, the "dirty data" are flat files and generated from a DOS based programme. The sequence of the flat file is in proper order. Yes, for sure we could introduce some index to it while doing bulk loading to the database, but what shall I use? even time index alone could be tough to achieve what I wanted....|||Well, unless I'm missing something here, if you simply whack it into a table with an indentity field in it, that will automatically give you a unique index, then you just need to do something like this:
Assuming fields are something like ID (new identity field), EmployeeID, Branch, TDate, Amount
select distinct t1.EmployeeID, t1.BRANCH, t1.TDate, (select top 1 amount from flattable t2 where t2.EmployeeID=t1.EmployeeIDand t2.branch = t1.branch and t2.TDate=t1.TDate order by [id] desc) as amount
FROM flattable t1
ORDER BY t1.EmployeeID ASC
This will pick out the distinct employee, branch and date records and then let you pick off the latest transaction (it'll have a higher generated ID) if there is more than one transaction for that employee, branch and date...
Worked in my test anyway... :-)
table is as follow:
EmpNo Branch Date Amount
1 A101 11/30/2007 $0.90
1 A101 11/30/2007 $1.20
2 A101 11/30/2007 $0.90
3 A101 11/30/2007 $0.80
How can I select the whole table and only take in 1 unique latest entry if there are multiple entries for the same day, same branch under same employee number?
Thanks! :DLet's say I have a data entry from a pool of employees:
table is as follow:
EmpNo Branch Date Amount
1 A101 11/30/2007 $0.90
1 A101 11/30/2007 $1.20
2 A101 11/30/2007 $0.90
3 A101 11/30/2007 $0.80
How can I select the whole table and only take in 1 unique latest entry if there are multiple entries for the same day, same branch under same employee number?
Thanks! :D
What do you mean by"select the whole table"? If you are hoping to get the "1 unique latest entry" the two statements contradict each other in my mind!
For example in your quoted sample data, what would be the result you would expect to get back? Just one row containing the $0.90 entry?
Edited to say "what consitutes 'latest' (and 'unique', come to think of it) as far as you are concerned?" If there are 14 entries for employee ID 1 on 11/30/2007 and some of them are for the same amount... what are you hoping to select? If you aren't using any kind of identity field then you must have some other way to make a record unique, right? If this is date & time, then you just select "top 1" or "max" based on the date/time field...? I must be missing something!|||Unless your dates contain a time component, or you have an incrementing surrogate key, there is no way to determine which of the records is "latest" when there are ties.|||If you happen to have a transaction log for the time in question, you could try and sift through that. Though, this would not be an easy task without a third party tool.
I believe there are two: Lumigent Log Explorer, http://www.lumigent.com and Log PI, http://www.logpi.com.
You could also try and use the DBCC LOG command, but this output is rather difficult to decipher.|||wow, that's fast reply. Sorry guys I guess I had missed out some important stuff....posted that from my office before I rushed back home.
my expected end results will be:
EmpNo Branch Date Amount
1 A101 11/30/2007 $1.20
2 A101 11/30/2007 $0.90
3 A101 11/30/2007 $0.80
the first item shall not be selected as there is a "latest" entry with the same employee number, same branch and same date. I only want one unique and latest entry from each employee in a given day. Why would that happen? somebody hand itchy and keyed in twice, or he/she keyed in the first time wrongly, and trying to key in again to replace the first one.
I have no control of the data given....this is a chuck of "dirty data" given to me. And yes, there is no time factor in this case.... :(
I think it's possible...was trying to look for a combi of "TOP" function and others. It's not going to be straight forward....
really appreciate the help from you guys! :D|||Er... but if you have no time component and no unique ID...
Hang on... where has this "dirty data" come from and what format is it in? You seem to be treating the order of the data as significant... is it some kind of flat file in which case the later rows are more recent? If so, there's something to work on, if not, there isn't! Sorry, but if you look at a given employee and there is more than one transaction on a day then what on earth separates the values? Surely you can't hope to do it on value alone?|||oh yah, the "dirty data" are flat files and generated from a DOS based programme. The sequence of the flat file is in proper order. Yes, for sure we could introduce some index to it while doing bulk loading to the database, but what shall I use? even time index alone could be tough to achieve what I wanted....|||Well, unless I'm missing something here, if you simply whack it into a table with an indentity field in it, that will automatically give you a unique index, then you just need to do something like this:
Assuming fields are something like ID (new identity field), EmployeeID, Branch, TDate, Amount
select distinct t1.EmployeeID, t1.BRANCH, t1.TDate, (select top 1 amount from flattable t2 where t2.EmployeeID=t1.EmployeeIDand t2.branch = t1.branch and t2.TDate=t1.TDate order by [id] desc) as amount
FROM flattable t1
ORDER BY t1.EmployeeID ASC
This will pick out the distinct employee, branch and date records and then let you pick off the latest transaction (it'll have a higher generated ID) if there is more than one transaction for that employee, branch and date...
Worked in my test anyway... :-)
Latest TPC bencmarks killing SQl Server
After Microsoft's doing so well in the TPC raw performance bechmark for so
long, Oracle appears to have finally leapfrogged SQL Server on both
Clustered and Non-Clustered configurations. In fact, not only has Oracle
leapfrogged them but literally blew SQL Server away.
What is REALLY interesting about this is the fact that the number-one
performance for the clustered configuration is both considerably higher than
Microsoft and WITH BETTER PRICE PERFORMANCE, which has always been
Microsoft's strength.
This appears to be a function of using an Open Source OS (Linux).
I still generally prefer SQL Server over Oracle (easier to tune and
maintain) but have been troubled by Microsoft's trend AWAY from commodity
pricing (that they pioneered at the high end) at the same time Enterprise
providers have been trending toward it. I'm wondering if this latest
development might single an inflection point where Microsoft begins to
rethink ever-upward pricing and once again return to a more aggresive
position in this area.It's a constant battle to keep the numbers up. If MS posts something Oracle
or DB2 will better it and then MS will have their turn. It's almost
pointless now that the numbers are so far out of what systems need now a
days anyway. The hardware has caught up with the rest of the world in this
respect and it's only getting better.
--
Andrew J. Kelly
SQL Server MVP
"nospam" <nfr@.nospam.com> wrote in message
news:%23%236UwKmzDHA.2000@.TK2MSFTNGP11.phx.gbl...
> After Microsoft's doing so well in the TPC raw performance bechmark for so
> long, Oracle appears to have finally leapfrogged SQL Server on both
> Clustered and Non-Clustered configurations. In fact, not only has Oracle
> leapfrogged them but literally blew SQL Server away.
> What is REALLY interesting about this is the fact that the number-one
> performance for the clustered configuration is both considerably higher
than
> Microsoft and WITH BETTER PRICE PERFORMANCE, which has always been
> Microsoft's strength.
> This appears to be a function of using an Open Source OS (Linux).
> I still generally prefer SQL Server over Oracle (easier to tune and
> maintain) but have been troubled by Microsoft's trend AWAY from commodity
> pricing (that they pioneered at the high end) at the same time Enterprise
> providers have been trending toward it. I'm wondering if this latest
> development might single an inflection point where Microsoft begins to
> rethink ever-upward pricing and once again return to a more aggresive
> position in this area.
>|||As far as non-clustered goes, something you need to take into account is
that the top Oracle NC result is on a box that has 1tb of main memory. The
top MS SQL NC result is on virtually the same box, but only has half the
memory. It's reasonable to assume that the top MS SQL NC result is probably
similar to the top Oracle NC result if they were run on the same hardware.
As far as the use of Linux is concerned, the O/S cost is only a small
fraction of the overall cost of that benchmark. Download the full disclosure
statement & I'd suggest you'll see that the cost achieved by Oracle is due
to commodity pricing of grid components & the cost saving from use of the
Linux O/S is a relatively small contributor to the overall cost saving on
Oracle's C result.
The last thing to take into account is that Oracle's result is based on 10g.
It will be interesting to see what Yukon can do.
Regards,
Greg Linwood
SQL Server MVP
"nospam" <nfr@.nospam.com> wrote in message
news:%23%236UwKmzDHA.2000@.TK2MSFTNGP11.phx.gbl...
> After Microsoft's doing so well in the TPC raw performance bechmark for so
> long, Oracle appears to have finally leapfrogged SQL Server on both
> Clustered and Non-Clustered configurations. In fact, not only has Oracle
> leapfrogged them but literally blew SQL Server away.
> What is REALLY interesting about this is the fact that the number-one
> performance for the clustered configuration is both considerably higher
than
> Microsoft and WITH BETTER PRICE PERFORMANCE, which has always been
> Microsoft's strength.
> This appears to be a function of using an Open Source OS (Linux).
> I still generally prefer SQL Server over Oracle (easier to tune and
> maintain) but have been troubled by Microsoft's trend AWAY from commodity
> pricing (that they pioneered at the high end) at the same time Enterprise
> providers have been trending toward it. I'm wondering if this latest
> development might single an inflection point where Microsoft begins to
> rethink ever-upward pricing and once again return to a more aggresive
> position in this area.
>|||Agree with all your points.
I would actually like to see one of these top-end benchmarks at least run on
as identical hardware as possible, such as the SuperDome, with the variants
being the database, TP Monitor, and OS. That is an integrated MS solution
vs. a non-MS "best-of-breed" approach.
IOW, I'd like to see the HW held constant and look for performance advantage
in software platform configurations.
"Greg Linwood" <g_linwoodQhotmail.com> wrote in message
news:ebPCK8mzDHA.1524@.TK2MSFTNGP10.phx.gbl...
> As far as non-clustered goes, something you need to take into account is
> that the top Oracle NC result is on a box that has 1tb of main memory. The
> top MS SQL NC result is on virtually the same box, but only has half the
> memory. It's reasonable to assume that the top MS SQL NC result is
probably
> similar to the top Oracle NC result if they were run on the same hardware.
> As far as the use of Linux is concerned, the O/S cost is only a small
> fraction of the overall cost of that benchmark. Download the full
disclosure
> statement & I'd suggest you'll see that the cost achieved by Oracle is due
> to commodity pricing of grid components & the cost saving from use of the
> Linux O/S is a relatively small contributor to the overall cost saving on
> Oracle's C result.
> The last thing to take into account is that Oracle's result is based on
10g.
> It will be interesting to see what Yukon can do.
> Regards,
> Greg Linwood
> SQL Server MVP
> "nospam" <nfr@.nospam.com> wrote in message
> news:%23%236UwKmzDHA.2000@.TK2MSFTNGP11.phx.gbl...
> > After Microsoft's doing so well in the TPC raw performance bechmark for
so
> > long, Oracle appears to have finally leapfrogged SQL Server on both
> > Clustered and Non-Clustered configurations. In fact, not only has Oracle
> > leapfrogged them but literally blew SQL Server away.
> >
> > What is REALLY interesting about this is the fact that the number-one
> > performance for the clustered configuration is both considerably higher
> than
> > Microsoft and WITH BETTER PRICE PERFORMANCE, which has always been
> > Microsoft's strength.
> >
> > This appears to be a function of using an Open Source OS (Linux).
> >
> > I still generally prefer SQL Server over Oracle (easier to tune and
> > maintain) but have been troubled by Microsoft's trend AWAY from
commodity
> > pricing (that they pioneered at the high end) at the same time
Enterprise
> > providers have been trending toward it. I'm wondering if this latest
> > development might single an inflection point where Microsoft begins to
> > rethink ever-upward pricing and once again return to a more aggresive
> > position in this area.
> >
> >
>|||You're not likely to see hardware held constant b/c these benchmarks are
usually released by hardware vendors - they'll always want to show off how
fast their latest "babies" are. (c:
Regards,
Greg Linwood
SQL Server MVP
"nospam" <nfr@.nospam.com> wrote in message
news:%23D$cbQnzDHA.3416@.tk2msftngp13.phx.gbl...
> Agree with all your points.
> I would actually like to see one of these top-end benchmarks at least run
on
> as identical hardware as possible, such as the SuperDome, with the
variants
> being the database, TP Monitor, and OS. That is an integrated MS solution
> vs. a non-MS "best-of-breed" approach.
> IOW, I'd like to see the HW held constant and look for performance
advantage
> in software platform configurations.
> "Greg Linwood" <g_linwoodQhotmail.com> wrote in message
> news:ebPCK8mzDHA.1524@.TK2MSFTNGP10.phx.gbl...
> > As far as non-clustered goes, something you need to take into account is
> > that the top Oracle NC result is on a box that has 1tb of main memory.
The
> > top MS SQL NC result is on virtually the same box, but only has half the
> > memory. It's reasonable to assume that the top MS SQL NC result is
> probably
> > similar to the top Oracle NC result if they were run on the same
hardware.
> >
> > As far as the use of Linux is concerned, the O/S cost is only a small
> > fraction of the overall cost of that benchmark. Download the full
> disclosure
> > statement & I'd suggest you'll see that the cost achieved by Oracle is
due
> > to commodity pricing of grid components & the cost saving from use of
the
> > Linux O/S is a relatively small contributor to the overall cost saving
on
> > Oracle's C result.
> >
> > The last thing to take into account is that Oracle's result is based on
> 10g.
> > It will be interesting to see what Yukon can do.
> >
> > Regards,
> > Greg Linwood
> > SQL Server MVP
> >
> > "nospam" <nfr@.nospam.com> wrote in message
> > news:%23%236UwKmzDHA.2000@.TK2MSFTNGP11.phx.gbl...
> > > After Microsoft's doing so well in the TPC raw performance bechmark
for
> so
> > > long, Oracle appears to have finally leapfrogged SQL Server on both
> > > Clustered and Non-Clustered configurations. In fact, not only has
Oracle
> > > leapfrogged them but literally blew SQL Server away.
> > >
> > > What is REALLY interesting about this is the fact that the number-one
> > > performance for the clustered configuration is both considerably
higher
> > than
> > > Microsoft and WITH BETTER PRICE PERFORMANCE, which has always been
> > > Microsoft's strength.
> > >
> > > This appears to be a function of using an Open Source OS (Linux).
> > >
> > > I still generally prefer SQL Server over Oracle (easier to tune and
> > > maintain) but have been troubled by Microsoft's trend AWAY from
> commodity
> > > pricing (that they pioneered at the high end) at the same time
> Enterprise
> > > providers have been trending toward it. I'm wondering if this latest
> > > development might single an inflection point where Microsoft begins to
> > > rethink ever-upward pricing and once again return to a more aggresive
> > > position in this area.
> > >
> > >
> >
> >
>|||3 out of the top 4 benchmark's are on the HP Integrity Superdome, which
theoretically could have been configured identically. The most recent number
1 slot goes to the HP Integrity rx5670, which was a clustered solution.
It's intereesting there is not a single Java-based TP-monitor in the bunch.
It appears the battle is between BEA Tuxedo and COM+.
"Greg Linwood" <g_linwoodQhotmail.com> wrote in message
news:%23ep$xYnzDHA.2160@.TK2MSFTNGP12.phx.gbl...
> You're not likely to see hardware held constant b/c these benchmarks are
> usually released by hardware vendors - they'll always want to show off how
> fast their latest "babies" are. (c:
> Regards,
> Greg Linwood
> SQL Server MVP
> "nospam" <nfr@.nospam.com> wrote in message
> news:%23D$cbQnzDHA.3416@.tk2msftngp13.phx.gbl...
> > Agree with all your points.
> >
> > I would actually like to see one of these top-end benchmarks at least
run
> on
> > as identical hardware as possible, such as the SuperDome, with the
> variants
> > being the database, TP Monitor, and OS. That is an integrated MS
solution
> > vs. a non-MS "best-of-breed" approach.
> >
> > IOW, I'd like to see the HW held constant and look for performance
> advantage
> > in software platform configurations.
> >
> > "Greg Linwood" <g_linwoodQhotmail.com> wrote in message
> > news:ebPCK8mzDHA.1524@.TK2MSFTNGP10.phx.gbl...
> > > As far as non-clustered goes, something you need to take into account
is
> > > that the top Oracle NC result is on a box that has 1tb of main memory.
> The
> > > top MS SQL NC result is on virtually the same box, but only has half
the
> > > memory. It's reasonable to assume that the top MS SQL NC result is
> > probably
> > > similar to the top Oracle NC result if they were run on the same
> hardware.
> > >
> > > As far as the use of Linux is concerned, the O/S cost is only a small
> > > fraction of the overall cost of that benchmark. Download the full
> > disclosure
> > > statement & I'd suggest you'll see that the cost achieved by Oracle is
> due
> > > to commodity pricing of grid components & the cost saving from use of
> the
> > > Linux O/S is a relatively small contributor to the overall cost saving
> on
> > > Oracle's C result.
> > >
> > > The last thing to take into account is that Oracle's result is based
on
> > 10g.
> > > It will be interesting to see what Yukon can do.
> > >
> > > Regards,
> > > Greg Linwood
> > > SQL Server MVP
> > >
> > > "nospam" <nfr@.nospam.com> wrote in message
> > > news:%23%236UwKmzDHA.2000@.TK2MSFTNGP11.phx.gbl...
> > > > After Microsoft's doing so well in the TPC raw performance bechmark
> for
> > so
> > > > long, Oracle appears to have finally leapfrogged SQL Server on both
> > > > Clustered and Non-Clustered configurations. In fact, not only has
> Oracle
> > > > leapfrogged them but literally blew SQL Server away.
> > > >
> > > > What is REALLY interesting about this is the fact that the
number-one
> > > > performance for the clustered configuration is both considerably
> higher
> > > than
> > > > Microsoft and WITH BETTER PRICE PERFORMANCE, which has always been
> > > > Microsoft's strength.
> > > >
> > > > This appears to be a function of using an Open Source OS (Linux).
> > > >
> > > > I still generally prefer SQL Server over Oracle (easier to tune and
> > > > maintain) but have been troubled by Microsoft's trend AWAY from
> > commodity
> > > > pricing (that they pioneered at the high end) at the same time
> > Enterprise
> > > > providers have been trending toward it. I'm wondering if this latest
> > > > development might single an inflection point where Microsoft begins
to
> > > > rethink ever-upward pricing and once again return to a more
aggresive
> > > > position in this area.
> > > >
> > > >
> > >
> > >
> >
> >
>|||Just look at the dates submitted and fact that Oracle has built (how many?) new versions since 1999 and releasing of MS SQL 2000!?sql
long, Oracle appears to have finally leapfrogged SQL Server on both
Clustered and Non-Clustered configurations. In fact, not only has Oracle
leapfrogged them but literally blew SQL Server away.
What is REALLY interesting about this is the fact that the number-one
performance for the clustered configuration is both considerably higher than
Microsoft and WITH BETTER PRICE PERFORMANCE, which has always been
Microsoft's strength.
This appears to be a function of using an Open Source OS (Linux).
I still generally prefer SQL Server over Oracle (easier to tune and
maintain) but have been troubled by Microsoft's trend AWAY from commodity
pricing (that they pioneered at the high end) at the same time Enterprise
providers have been trending toward it. I'm wondering if this latest
development might single an inflection point where Microsoft begins to
rethink ever-upward pricing and once again return to a more aggresive
position in this area.It's a constant battle to keep the numbers up. If MS posts something Oracle
or DB2 will better it and then MS will have their turn. It's almost
pointless now that the numbers are so far out of what systems need now a
days anyway. The hardware has caught up with the rest of the world in this
respect and it's only getting better.
--
Andrew J. Kelly
SQL Server MVP
"nospam" <nfr@.nospam.com> wrote in message
news:%23%236UwKmzDHA.2000@.TK2MSFTNGP11.phx.gbl...
> After Microsoft's doing so well in the TPC raw performance bechmark for so
> long, Oracle appears to have finally leapfrogged SQL Server on both
> Clustered and Non-Clustered configurations. In fact, not only has Oracle
> leapfrogged them but literally blew SQL Server away.
> What is REALLY interesting about this is the fact that the number-one
> performance for the clustered configuration is both considerably higher
than
> Microsoft and WITH BETTER PRICE PERFORMANCE, which has always been
> Microsoft's strength.
> This appears to be a function of using an Open Source OS (Linux).
> I still generally prefer SQL Server over Oracle (easier to tune and
> maintain) but have been troubled by Microsoft's trend AWAY from commodity
> pricing (that they pioneered at the high end) at the same time Enterprise
> providers have been trending toward it. I'm wondering if this latest
> development might single an inflection point where Microsoft begins to
> rethink ever-upward pricing and once again return to a more aggresive
> position in this area.
>|||As far as non-clustered goes, something you need to take into account is
that the top Oracle NC result is on a box that has 1tb of main memory. The
top MS SQL NC result is on virtually the same box, but only has half the
memory. It's reasonable to assume that the top MS SQL NC result is probably
similar to the top Oracle NC result if they were run on the same hardware.
As far as the use of Linux is concerned, the O/S cost is only a small
fraction of the overall cost of that benchmark. Download the full disclosure
statement & I'd suggest you'll see that the cost achieved by Oracle is due
to commodity pricing of grid components & the cost saving from use of the
Linux O/S is a relatively small contributor to the overall cost saving on
Oracle's C result.
The last thing to take into account is that Oracle's result is based on 10g.
It will be interesting to see what Yukon can do.
Regards,
Greg Linwood
SQL Server MVP
"nospam" <nfr@.nospam.com> wrote in message
news:%23%236UwKmzDHA.2000@.TK2MSFTNGP11.phx.gbl...
> After Microsoft's doing so well in the TPC raw performance bechmark for so
> long, Oracle appears to have finally leapfrogged SQL Server on both
> Clustered and Non-Clustered configurations. In fact, not only has Oracle
> leapfrogged them but literally blew SQL Server away.
> What is REALLY interesting about this is the fact that the number-one
> performance for the clustered configuration is both considerably higher
than
> Microsoft and WITH BETTER PRICE PERFORMANCE, which has always been
> Microsoft's strength.
> This appears to be a function of using an Open Source OS (Linux).
> I still generally prefer SQL Server over Oracle (easier to tune and
> maintain) but have been troubled by Microsoft's trend AWAY from commodity
> pricing (that they pioneered at the high end) at the same time Enterprise
> providers have been trending toward it. I'm wondering if this latest
> development might single an inflection point where Microsoft begins to
> rethink ever-upward pricing and once again return to a more aggresive
> position in this area.
>|||Agree with all your points.
I would actually like to see one of these top-end benchmarks at least run on
as identical hardware as possible, such as the SuperDome, with the variants
being the database, TP Monitor, and OS. That is an integrated MS solution
vs. a non-MS "best-of-breed" approach.
IOW, I'd like to see the HW held constant and look for performance advantage
in software platform configurations.
"Greg Linwood" <g_linwoodQhotmail.com> wrote in message
news:ebPCK8mzDHA.1524@.TK2MSFTNGP10.phx.gbl...
> As far as non-clustered goes, something you need to take into account is
> that the top Oracle NC result is on a box that has 1tb of main memory. The
> top MS SQL NC result is on virtually the same box, but only has half the
> memory. It's reasonable to assume that the top MS SQL NC result is
probably
> similar to the top Oracle NC result if they were run on the same hardware.
> As far as the use of Linux is concerned, the O/S cost is only a small
> fraction of the overall cost of that benchmark. Download the full
disclosure
> statement & I'd suggest you'll see that the cost achieved by Oracle is due
> to commodity pricing of grid components & the cost saving from use of the
> Linux O/S is a relatively small contributor to the overall cost saving on
> Oracle's C result.
> The last thing to take into account is that Oracle's result is based on
10g.
> It will be interesting to see what Yukon can do.
> Regards,
> Greg Linwood
> SQL Server MVP
> "nospam" <nfr@.nospam.com> wrote in message
> news:%23%236UwKmzDHA.2000@.TK2MSFTNGP11.phx.gbl...
> > After Microsoft's doing so well in the TPC raw performance bechmark for
so
> > long, Oracle appears to have finally leapfrogged SQL Server on both
> > Clustered and Non-Clustered configurations. In fact, not only has Oracle
> > leapfrogged them but literally blew SQL Server away.
> >
> > What is REALLY interesting about this is the fact that the number-one
> > performance for the clustered configuration is both considerably higher
> than
> > Microsoft and WITH BETTER PRICE PERFORMANCE, which has always been
> > Microsoft's strength.
> >
> > This appears to be a function of using an Open Source OS (Linux).
> >
> > I still generally prefer SQL Server over Oracle (easier to tune and
> > maintain) but have been troubled by Microsoft's trend AWAY from
commodity
> > pricing (that they pioneered at the high end) at the same time
Enterprise
> > providers have been trending toward it. I'm wondering if this latest
> > development might single an inflection point where Microsoft begins to
> > rethink ever-upward pricing and once again return to a more aggresive
> > position in this area.
> >
> >
>|||You're not likely to see hardware held constant b/c these benchmarks are
usually released by hardware vendors - they'll always want to show off how
fast their latest "babies" are. (c:
Regards,
Greg Linwood
SQL Server MVP
"nospam" <nfr@.nospam.com> wrote in message
news:%23D$cbQnzDHA.3416@.tk2msftngp13.phx.gbl...
> Agree with all your points.
> I would actually like to see one of these top-end benchmarks at least run
on
> as identical hardware as possible, such as the SuperDome, with the
variants
> being the database, TP Monitor, and OS. That is an integrated MS solution
> vs. a non-MS "best-of-breed" approach.
> IOW, I'd like to see the HW held constant and look for performance
advantage
> in software platform configurations.
> "Greg Linwood" <g_linwoodQhotmail.com> wrote in message
> news:ebPCK8mzDHA.1524@.TK2MSFTNGP10.phx.gbl...
> > As far as non-clustered goes, something you need to take into account is
> > that the top Oracle NC result is on a box that has 1tb of main memory.
The
> > top MS SQL NC result is on virtually the same box, but only has half the
> > memory. It's reasonable to assume that the top MS SQL NC result is
> probably
> > similar to the top Oracle NC result if they were run on the same
hardware.
> >
> > As far as the use of Linux is concerned, the O/S cost is only a small
> > fraction of the overall cost of that benchmark. Download the full
> disclosure
> > statement & I'd suggest you'll see that the cost achieved by Oracle is
due
> > to commodity pricing of grid components & the cost saving from use of
the
> > Linux O/S is a relatively small contributor to the overall cost saving
on
> > Oracle's C result.
> >
> > The last thing to take into account is that Oracle's result is based on
> 10g.
> > It will be interesting to see what Yukon can do.
> >
> > Regards,
> > Greg Linwood
> > SQL Server MVP
> >
> > "nospam" <nfr@.nospam.com> wrote in message
> > news:%23%236UwKmzDHA.2000@.TK2MSFTNGP11.phx.gbl...
> > > After Microsoft's doing so well in the TPC raw performance bechmark
for
> so
> > > long, Oracle appears to have finally leapfrogged SQL Server on both
> > > Clustered and Non-Clustered configurations. In fact, not only has
Oracle
> > > leapfrogged them but literally blew SQL Server away.
> > >
> > > What is REALLY interesting about this is the fact that the number-one
> > > performance for the clustered configuration is both considerably
higher
> > than
> > > Microsoft and WITH BETTER PRICE PERFORMANCE, which has always been
> > > Microsoft's strength.
> > >
> > > This appears to be a function of using an Open Source OS (Linux).
> > >
> > > I still generally prefer SQL Server over Oracle (easier to tune and
> > > maintain) but have been troubled by Microsoft's trend AWAY from
> commodity
> > > pricing (that they pioneered at the high end) at the same time
> Enterprise
> > > providers have been trending toward it. I'm wondering if this latest
> > > development might single an inflection point where Microsoft begins to
> > > rethink ever-upward pricing and once again return to a more aggresive
> > > position in this area.
> > >
> > >
> >
> >
>|||3 out of the top 4 benchmark's are on the HP Integrity Superdome, which
theoretically could have been configured identically. The most recent number
1 slot goes to the HP Integrity rx5670, which was a clustered solution.
It's intereesting there is not a single Java-based TP-monitor in the bunch.
It appears the battle is between BEA Tuxedo and COM+.
"Greg Linwood" <g_linwoodQhotmail.com> wrote in message
news:%23ep$xYnzDHA.2160@.TK2MSFTNGP12.phx.gbl...
> You're not likely to see hardware held constant b/c these benchmarks are
> usually released by hardware vendors - they'll always want to show off how
> fast their latest "babies" are. (c:
> Regards,
> Greg Linwood
> SQL Server MVP
> "nospam" <nfr@.nospam.com> wrote in message
> news:%23D$cbQnzDHA.3416@.tk2msftngp13.phx.gbl...
> > Agree with all your points.
> >
> > I would actually like to see one of these top-end benchmarks at least
run
> on
> > as identical hardware as possible, such as the SuperDome, with the
> variants
> > being the database, TP Monitor, and OS. That is an integrated MS
solution
> > vs. a non-MS "best-of-breed" approach.
> >
> > IOW, I'd like to see the HW held constant and look for performance
> advantage
> > in software platform configurations.
> >
> > "Greg Linwood" <g_linwoodQhotmail.com> wrote in message
> > news:ebPCK8mzDHA.1524@.TK2MSFTNGP10.phx.gbl...
> > > As far as non-clustered goes, something you need to take into account
is
> > > that the top Oracle NC result is on a box that has 1tb of main memory.
> The
> > > top MS SQL NC result is on virtually the same box, but only has half
the
> > > memory. It's reasonable to assume that the top MS SQL NC result is
> > probably
> > > similar to the top Oracle NC result if they were run on the same
> hardware.
> > >
> > > As far as the use of Linux is concerned, the O/S cost is only a small
> > > fraction of the overall cost of that benchmark. Download the full
> > disclosure
> > > statement & I'd suggest you'll see that the cost achieved by Oracle is
> due
> > > to commodity pricing of grid components & the cost saving from use of
> the
> > > Linux O/S is a relatively small contributor to the overall cost saving
> on
> > > Oracle's C result.
> > >
> > > The last thing to take into account is that Oracle's result is based
on
> > 10g.
> > > It will be interesting to see what Yukon can do.
> > >
> > > Regards,
> > > Greg Linwood
> > > SQL Server MVP
> > >
> > > "nospam" <nfr@.nospam.com> wrote in message
> > > news:%23%236UwKmzDHA.2000@.TK2MSFTNGP11.phx.gbl...
> > > > After Microsoft's doing so well in the TPC raw performance bechmark
> for
> > so
> > > > long, Oracle appears to have finally leapfrogged SQL Server on both
> > > > Clustered and Non-Clustered configurations. In fact, not only has
> Oracle
> > > > leapfrogged them but literally blew SQL Server away.
> > > >
> > > > What is REALLY interesting about this is the fact that the
number-one
> > > > performance for the clustered configuration is both considerably
> higher
> > > than
> > > > Microsoft and WITH BETTER PRICE PERFORMANCE, which has always been
> > > > Microsoft's strength.
> > > >
> > > > This appears to be a function of using an Open Source OS (Linux).
> > > >
> > > > I still generally prefer SQL Server over Oracle (easier to tune and
> > > > maintain) but have been troubled by Microsoft's trend AWAY from
> > commodity
> > > > pricing (that they pioneered at the high end) at the same time
> > Enterprise
> > > > providers have been trending toward it. I'm wondering if this latest
> > > > development might single an inflection point where Microsoft begins
to
> > > > rethink ever-upward pricing and once again return to a more
aggresive
> > > > position in this area.
> > > >
> > > >
> > >
> > >
> >
> >
>|||Just look at the dates submitted and fact that Oracle has built (how many?) new versions since 1999 and releasing of MS SQL 2000!?sql
Latest SQL Server Analysis Patch
Does anyone knows what is the latest SQL Server 2000
Analysis Services patch and how can I get it (Web address)
Thanks.That I know of? 8.0.921.0. http://support.microsoft.com/?kbid=838004
(Sorry, you can't download the patch without talking to Microsoft Product
Support Services. Follow the instructions in the article.)
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"James" <anonymous@.discussions.microsoft.com> wrote in message
news:1002a01c40d33$7c0a4ec0$a101280a@.phx
.gbl...
> Does anyone knows what is the latest SQL Server 2000
> Analysis Services patch and how can I get it (Web address)
> Thanks.|||Thanks for the info.........
Is there a website where there is the list of all patches?
Thanks.
>--Original Message--
>That I know of? 8.0.921.0.
http://support.microsoft.com/?kbid=838004
>(Sorry, you can't download the patch without talking to
Microsoft Product
>Support Services. Follow the instructions in the
article.)
>--
>Aaron Bertrand
>SQL Server MVP
>http://www.aspfaq.com/
>
>"James" <anonymous@.discussions.microsoft.com> wrote in
message
> news:1002a01c40d33$7c0a4ec0$a101280a@.phx
.gbl...
address)
>
>.
>|||I don't know of an official one. I try to keep this one up to date:
http://www.aspfaq.com/2160
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"James" <anonymous@.discussions.microsoft.com> wrote in message
news:b8ee01c40dbe$b20e5e90$a001280a@.phx.gbl...
> Thanks for the info.........
> Is there a website where there is the list of all patches?
> Thanks.
>
> http://support.microsoft.com/?kbid=838004
> Microsoft Product
> article.)
> message
> address)
Analysis Services patch and how can I get it (Web address)
Thanks.That I know of? 8.0.921.0. http://support.microsoft.com/?kbid=838004
(Sorry, you can't download the patch without talking to Microsoft Product
Support Services. Follow the instructions in the article.)
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"James" <anonymous@.discussions.microsoft.com> wrote in message
news:1002a01c40d33$7c0a4ec0$a101280a@.phx
.gbl...
> Does anyone knows what is the latest SQL Server 2000
> Analysis Services patch and how can I get it (Web address)
> Thanks.|||Thanks for the info.........
Is there a website where there is the list of all patches?
Thanks.
>--Original Message--
>That I know of? 8.0.921.0.
http://support.microsoft.com/?kbid=838004
>(Sorry, you can't download the patch without talking to
Microsoft Product
>Support Services. Follow the instructions in the
article.)
>--
>Aaron Bertrand
>SQL Server MVP
>http://www.aspfaq.com/
>
>"James" <anonymous@.discussions.microsoft.com> wrote in
message
> news:1002a01c40d33$7c0a4ec0$a101280a@.phx
.gbl...
address)
>
>.
>|||I don't know of an official one. I try to keep this one up to date:
http://www.aspfaq.com/2160
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"James" <anonymous@.discussions.microsoft.com> wrote in message
news:b8ee01c40dbe$b20e5e90$a001280a@.phx.gbl...
> Thanks for the info.........
> Is there a website where there is the list of all patches?
> Thanks.
>
> http://support.microsoft.com/?kbid=838004
> Microsoft Product
> article.)
> message
> address)
latest service pack
What is the latest service pack for MSSQL2000 and MSSQL7?
Was there any significant or critical patch since service pack4Service Pack 4 is still the latest for SQL Server 2000.
See the update note on this link about "an issue with the final build of SP4
that impacts customers who run SQL Server with AWE support enabled".
http://www.microsoft.com/downloads/details.aspx?familyid=8E2DFC8D-C20E-4446-99A9-B7F0213F8BC5&displaylang=en
See Microsoft Knowledge Base article 899761.
Ben Nevarez, MCDBA, OCP
Database Administrator
"kimi" wrote:
> What is the latest service pack for MSSQL2000 and MSSQL7?
> Was there any significant or critical patch since service pack4
Was there any significant or critical patch since service pack4Service Pack 4 is still the latest for SQL Server 2000.
See the update note on this link about "an issue with the final build of SP4
that impacts customers who run SQL Server with AWE support enabled".
http://www.microsoft.com/downloads/details.aspx?familyid=8E2DFC8D-C20E-4446-99A9-B7F0213F8BC5&displaylang=en
See Microsoft Knowledge Base article 899761.
Ben Nevarez, MCDBA, OCP
Database Administrator
"kimi" wrote:
> What is the latest service pack for MSSQL2000 and MSSQL7?
> Was there any significant or critical patch since service pack4
latest service pack
What is the latest service pack for MSSQL2000 and MSSQL7?
Was there any significant or critical patch since service pack4Service Pack 4 is still the latest for SQL Server 2000.
See the update note on this link about "an issue with the final build of SP4
that impacts customers who run SQL Server with AWE support enabled".
http://www.microsoft.com/downloads/...&displaylang=en
See Microsoft Knowledge Base article 899761.
Ben Nevarez, MCDBA, OCP
Database Administrator
"kimi" wrote:
> What is the latest service pack for MSSQL2000 and MSSQL7?
> Was there any significant or critical patch since service pack4
Was there any significant or critical patch since service pack4Service Pack 4 is still the latest for SQL Server 2000.
See the update note on this link about "an issue with the final build of SP4
that impacts customers who run SQL Server with AWE support enabled".
http://www.microsoft.com/downloads/...&displaylang=en
See Microsoft Knowledge Base article 899761.
Ben Nevarez, MCDBA, OCP
Database Administrator
"kimi" wrote:
> What is the latest service pack for MSSQL2000 and MSSQL7?
> Was there any significant or critical patch since service pack4
latest service pack
What is the latest service pack for MSSQL2000 and MSSQL7?
Was there any significant or critical patch since service pack4
Service Pack 4 is still the latest for SQL Server 2000.
See the update note on this link about "an issue with the final build of SP4
that impacts customers who run SQL Server with AWE support enabled".
http://www.microsoft.com/downloads/d...displaylang=en
See Microsoft Knowledge Base article 899761.
Ben Nevarez, MCDBA, OCP
Database Administrator
"kimi" wrote:
> What is the latest service pack for MSSQL2000 and MSSQL7?
> Was there any significant or critical patch since service pack4
Was there any significant or critical patch since service pack4
Service Pack 4 is still the latest for SQL Server 2000.
See the update note on this link about "an issue with the final build of SP4
that impacts customers who run SQL Server with AWE support enabled".
http://www.microsoft.com/downloads/d...displaylang=en
See Microsoft Knowledge Base article 899761.
Ben Nevarez, MCDBA, OCP
Database Administrator
"kimi" wrote:
> What is the latest service pack for MSSQL2000 and MSSQL7?
> Was there any significant or critical patch since service pack4
Latest record
My table are
Customer: customerId ,name
Order: orderId, customerId, product,date
I want to display latest order from the customer
You can use ORDER BY.
Select O.OrderId, C.Name, O.Product, O.DateFROM Order OJOIN Customer CON C.CustomerId O.CustomerIdORDER BY O.DateDesc|||
SELECT orderId, customerId, product,[date], [name]FROM(select a.orderId, a.customerId, a.product,a.[date], b.name, row_number()over(partitionby a.customeridorderby [date]DESC)as RowNum
from [Order] ainnerjoin [Customer] bon a.customerId=b.customerId) t
WHERE RowNum= 1
sqlLatest RDL Specification?
I read in someone's blog somewhere that the RDL Specification was changing
for SSRS 2005 (http://blogs.msdn.com/gsnowman/archive/2005/10/12/480328.aspx).
I went to the MS Reporting Services website and this version of the
specification appears to be old
(http://www.microsoft.com/sql/technologies/reporting/rdlspec.mspx). Can
someone either confirm or deny that the spec located at
http://www.microsoft.com/sql/technologies/reporting/rdlspec.mspx is the
latest RDL specification for SSRS2005?
Thanks!
Brian McCulloughWell I guess this was sort of a dumb question...
You can find the latest schema out here (which you can tell by looking at
the reference in the <Report> tag):
http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition/
"brianpmccullough" wrote:
> I read in someone's blog somewhere that the RDL Specification was changing
> for SSRS 2005 (http://blogs.msdn.com/gsnowman/archive/2005/10/12/480328.aspx).
> I went to the MS Reporting Services website and this version of the
> specification appears to be old
> (http://www.microsoft.com/sql/technologies/reporting/rdlspec.mspx). Can
> someone either confirm or deny that the spec located at
> http://www.microsoft.com/sql/technologies/reporting/rdlspec.mspx is the
> latest RDL specification for SSRS2005?
> Thanks!
> Brian McCullough
for SSRS 2005 (http://blogs.msdn.com/gsnowman/archive/2005/10/12/480328.aspx).
I went to the MS Reporting Services website and this version of the
specification appears to be old
(http://www.microsoft.com/sql/technologies/reporting/rdlspec.mspx). Can
someone either confirm or deny that the spec located at
http://www.microsoft.com/sql/technologies/reporting/rdlspec.mspx is the
latest RDL specification for SSRS2005?
Thanks!
Brian McCulloughWell I guess this was sort of a dumb question...
You can find the latest schema out here (which you can tell by looking at
the reference in the <Report> tag):
http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition/
"brianpmccullough" wrote:
> I read in someone's blog somewhere that the RDL Specification was changing
> for SSRS 2005 (http://blogs.msdn.com/gsnowman/archive/2005/10/12/480328.aspx).
> I went to the MS Reporting Services website and this version of the
> specification appears to be old
> (http://www.microsoft.com/sql/technologies/reporting/rdlspec.mspx). Can
> someone either confirm or deny that the spec located at
> http://www.microsoft.com/sql/technologies/reporting/rdlspec.mspx is the
> latest RDL specification for SSRS2005?
> Thanks!
> Brian McCullough
Latest quarterly default
In Query Analyzer, I would like to design a view that would that would return
data automatically for the most recent completed quarter based on a calendar
year.
For example(from the SOP30200 table in Great Plains Dynamics 7.0):
sopnumbe soptype docdate subtotal
-- -- -- --
I would like all data from July 1 through September 30, 2006 since today is
December 27 and this current calendar quarter is still in progress.
Thank you.
If you are still interested this should work (but it's a bit convoluted).
You can replace the @.Today WITH GETDATE() is you want to use the machine date.
DECLARE @.Today DATETIME
SELECT @.Today = '12/27/2006'
SELECT
@.Today AS TodaysDate,
DATEPART(year, @.Today) - CASE WHEN DATEPART(quarter, @.Today) = 1 THEN 1
ELSE 0 END AS [Year],
CASE WHEN DATEPART(quarter, @.Today) = 1 THEN 4 ELSE DATEPART(quarter,
@.Today) - 1 END AS [Quarter],
CAST(
CASE
WHEN DATEPART(quarter, @.Today) = 1 THEN '12/31/'
WHEN DATEPART(quarter, @.Today) = 2 THEN '03/31/'
WHEN DATEPART(quarter, @.Today) = 3 THEN '06/30/'
ELSE '09/30/'
END +
CAST(DATEPART(year, @.Today) - CASE WHEN DATEPART(quarter, @.Today) = 1 THEN
1 ELSE 0 END AS VARCHAR)
AS DATETIME) AS LastQuarterEnd
Results:
2006-12-27 00:00:00.000200632006-09-30 00:00:00.000
Regards,
JayAchTee
"chas2006" wrote:
> In Query Analyzer, I would like to design a view that would that would return
> data automatically for the most recent completed quarter based on a calendar
> year.
> For example(from the SOP30200 table in Great Plains Dynamics 7.0):
> sopnumbe soptype docdate subtotal
> -- -- -- --
> I would like all data from July 1 through September 30, 2006 since today is
> December 27 and this current calendar quarter is still in progress.
> Thank you.
data automatically for the most recent completed quarter based on a calendar
year.
For example(from the SOP30200 table in Great Plains Dynamics 7.0):
sopnumbe soptype docdate subtotal
-- -- -- --
I would like all data from July 1 through September 30, 2006 since today is
December 27 and this current calendar quarter is still in progress.
Thank you.
If you are still interested this should work (but it's a bit convoluted).
You can replace the @.Today WITH GETDATE() is you want to use the machine date.
DECLARE @.Today DATETIME
SELECT @.Today = '12/27/2006'
SELECT
@.Today AS TodaysDate,
DATEPART(year, @.Today) - CASE WHEN DATEPART(quarter, @.Today) = 1 THEN 1
ELSE 0 END AS [Year],
CASE WHEN DATEPART(quarter, @.Today) = 1 THEN 4 ELSE DATEPART(quarter,
@.Today) - 1 END AS [Quarter],
CAST(
CASE
WHEN DATEPART(quarter, @.Today) = 1 THEN '12/31/'
WHEN DATEPART(quarter, @.Today) = 2 THEN '03/31/'
WHEN DATEPART(quarter, @.Today) = 3 THEN '06/30/'
ELSE '09/30/'
END +
CAST(DATEPART(year, @.Today) - CASE WHEN DATEPART(quarter, @.Today) = 1 THEN
1 ELSE 0 END AS VARCHAR)
AS DATETIME) AS LastQuarterEnd
Results:
2006-12-27 00:00:00.000200632006-09-30 00:00:00.000
Regards,
JayAchTee
"chas2006" wrote:
> In Query Analyzer, I would like to design a view that would that would return
> data automatically for the most recent completed quarter based on a calendar
> year.
> For example(from the SOP30200 table in Great Plains Dynamics 7.0):
> sopnumbe soptype docdate subtotal
> -- -- -- --
> I would like all data from July 1 through September 30, 2006 since today is
> December 27 and this current calendar quarter is still in progress.
> Thank you.
latest patch
What is the latest patch for SQL 2000 and how can I know it is the latest?
Thanks.Go here:
http://www.microsoft.com/technet/treeview/default.asp?url=/technet/security/current.asp
Select your product and service pack level, and it gives you all subsequent
patches, and the order that they came out in.
Cheers
Ken
"supernova" <abc@.yahoo.com> wrote in message
news:e8oHIbcnDHA.2404@.TK2MSFTNGP12.phx.gbl...
: What is the latest patch for SQL 2000 and how can I know it is the latest?
: Thanks.
:
:|||Thanks a lot, Ken. It helps. Do you know how to find out if I am running SQL
2K 32-bit or 64-bit?
"Ken Schaefer" <kenREMOVE@.THISadOpenStatic.com> wrote in message
news:eQK1$8cnDHA.2772@.TK2MSFTNGP10.phx.gbl...
> Go here:
>
http://www.microsoft.com/technet/treeview/default.asp?url=/technet/security/current.asp
> Select your product and service pack level, and it gives you all
subsequent
> patches, and the order that they came out in.
> Cheers
> Ken
> "supernova" <abc@.yahoo.com> wrote in message
> news:e8oHIbcnDHA.2404@.TK2MSFTNGP12.phx.gbl...
> : What is the latest patch for SQL 2000 and how can I know it is the
latest?
> : Thanks.
> :
> :
>|||Um, if you don't know, then you're probably running 32 bit :-)
64-bit is only available (currently) on Intel's Itanium chips, and you'd
need to be running 64-bit Windows as well. (and if you have a server running
Itanium CPUs, you should probably know about it...)
Cheers
Ken
"supernova" <abc@.yahoo.com> wrote in message
news:OI1P6TdnDHA.2244@.TK2MSFTNGP12.phx.gbl...
: Thanks a lot, Ken. It helps. Do you know how to find out if I am running
SQL
: 2K 32-bit or 64-bit?
:
:
: "Ken Schaefer" <kenREMOVE@.THISadOpenStatic.com> wrote in message
: news:eQK1$8cnDHA.2772@.TK2MSFTNGP10.phx.gbl...
: > Go here:
: >
:
http://www.microsoft.com/technet/treeview/default.asp?url=/technet/security/current.asp
: >
: > Select your product and service pack level, and it gives you all
: subsequent
: > patches, and the order that they came out in.
: >
: > Cheers
: > Ken
: >
: > "supernova" <abc@.yahoo.com> wrote in message
: > news:e8oHIbcnDHA.2404@.TK2MSFTNGP12.phx.gbl...
: > : What is the latest patch for SQL 2000 and how can I know it is the
: latest?
: > : Thanks.sql
Thanks.Go here:
http://www.microsoft.com/technet/treeview/default.asp?url=/technet/security/current.asp
Select your product and service pack level, and it gives you all subsequent
patches, and the order that they came out in.
Cheers
Ken
"supernova" <abc@.yahoo.com> wrote in message
news:e8oHIbcnDHA.2404@.TK2MSFTNGP12.phx.gbl...
: What is the latest patch for SQL 2000 and how can I know it is the latest?
: Thanks.
:
:|||Thanks a lot, Ken. It helps. Do you know how to find out if I am running SQL
2K 32-bit or 64-bit?
"Ken Schaefer" <kenREMOVE@.THISadOpenStatic.com> wrote in message
news:eQK1$8cnDHA.2772@.TK2MSFTNGP10.phx.gbl...
> Go here:
>
http://www.microsoft.com/technet/treeview/default.asp?url=/technet/security/current.asp
> Select your product and service pack level, and it gives you all
subsequent
> patches, and the order that they came out in.
> Cheers
> Ken
> "supernova" <abc@.yahoo.com> wrote in message
> news:e8oHIbcnDHA.2404@.TK2MSFTNGP12.phx.gbl...
> : What is the latest patch for SQL 2000 and how can I know it is the
latest?
> : Thanks.
> :
> :
>|||Um, if you don't know, then you're probably running 32 bit :-)
64-bit is only available (currently) on Intel's Itanium chips, and you'd
need to be running 64-bit Windows as well. (and if you have a server running
Itanium CPUs, you should probably know about it...)
Cheers
Ken
"supernova" <abc@.yahoo.com> wrote in message
news:OI1P6TdnDHA.2244@.TK2MSFTNGP12.phx.gbl...
: Thanks a lot, Ken. It helps. Do you know how to find out if I am running
SQL
: 2K 32-bit or 64-bit?
:
:
: "Ken Schaefer" <kenREMOVE@.THISadOpenStatic.com> wrote in message
: news:eQK1$8cnDHA.2772@.TK2MSFTNGP10.phx.gbl...
: > Go here:
: >
:
http://www.microsoft.com/technet/treeview/default.asp?url=/technet/security/current.asp
: >
: > Select your product and service pack level, and it gives you all
: subsequent
: > patches, and the order that they came out in.
: >
: > Cheers
: > Ken
: >
: > "supernova" <abc@.yahoo.com> wrote in message
: > news:e8oHIbcnDHA.2404@.TK2MSFTNGP12.phx.gbl...
: > : What is the latest patch for SQL 2000 and how can I know it is the
: latest?
: > : Thanks.sql
latest patch
One of our systems support personnel says there is a new
security patch for SQL Server 2000.
How can I find and download that patch?
How can I be notified of future patches/service packs?
TIA,
AdriaI don't know of a SQL Server security patch in some time. See
http://www.aspfaq.com/2160 for a summary of other updates (e.g. hotfix
releases).
You can sign up for security release bulletins at
http://www.microsoft.com/technet/se...tin/notify.mspx
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Adria" <a-carbo@.tamu.edu> wrote in message
news:16fd601c41825$3d0dfd00$a501280a@.phx
.gbl...
> One of our systems support personnel says there is a new
> security patch for SQL Server 2000.
> How can I find and download that patch?
> How can I be notified of future patches/service packs?
> TIA,
> Adria
security patch for SQL Server 2000.
How can I find and download that patch?
How can I be notified of future patches/service packs?
TIA,
AdriaI don't know of a SQL Server security patch in some time. See
http://www.aspfaq.com/2160 for a summary of other updates (e.g. hotfix
releases).
You can sign up for security release bulletins at
http://www.microsoft.com/technet/se...tin/notify.mspx
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Adria" <a-carbo@.tamu.edu> wrote in message
news:16fd601c41825$3d0dfd00$a501280a@.phx
.gbl...
> One of our systems support personnel says there is a new
> security patch for SQL Server 2000.
> How can I find and download that patch?
> How can I be notified of future patches/service packs?
> TIA,
> Adria
latest patch
One of our systems support personnel says there is a new
security patch for SQL Server 2000.
How can I find and download that patch?
How can I be notified of future patches/service packs?
TIA,
Adria
I don't know of a SQL Server security patch in some time. See
http://www.aspfaq.com/2160 for a summary of other updates (e.g. hotfix
releases).
You can sign up for security release bulletins at
http://www.microsoft.com/technet/sec...in/notify.mspx
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Adria" <a-carbo@.tamu.edu> wrote in message
news:16fd601c41825$3d0dfd00$a501280a@.phx.gbl...
> One of our systems support personnel says there is a new
> security patch for SQL Server 2000.
> How can I find and download that patch?
> How can I be notified of future patches/service packs?
> TIA,
> Adria
security patch for SQL Server 2000.
How can I find and download that patch?
How can I be notified of future patches/service packs?
TIA,
Adria
I don't know of a SQL Server security patch in some time. See
http://www.aspfaq.com/2160 for a summary of other updates (e.g. hotfix
releases).
You can sign up for security release bulletins at
http://www.microsoft.com/technet/sec...in/notify.mspx
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Adria" <a-carbo@.tamu.edu> wrote in message
news:16fd601c41825$3d0dfd00$a501280a@.phx.gbl...
> One of our systems support personnel says there is a new
> security patch for SQL Server 2000.
> How can I find and download that patch?
> How can I be notified of future patches/service packs?
> TIA,
> Adria
latest order date
Hi,
I have an order table which contains the following fielde: 1). orderid (this
is the order number 2). clientid 3). orderdate.
I need to script so that I can find out those clientids which do not have
place an order for at least 90 days.
Can you tell me how to program it?Read the documentation. You want to select clientids which are NOT IN a
subquery that selects all clients that have ordered in the last 90 days. You
could also use a join where max order date is less than 90 days ago.
RR
"qjlee" <qjlee@.discussions.microsoft.com> wrote in message
news:B84E46A2-9291-4D17-A625-3DBADD9746B1@.microsoft.com...
> Hi,
> I have an order table which contains the following fielde: 1). orderid
(this
> is the order number 2). clientid 3). orderdate.
> I need to script so that I can find out those clientids which do not have
> place an order for at least 90 days.
> Can you tell me how to program it?
>
>|||Something like this should give you the client and their last order date.
declare @.DaysSinceOrder as numeric
set @.DaysSinceOrder = 90
select
clientid ,
max(orderdate)
from "YourTableHere"
group by clientid
having max(orderdate) < getdate()-@.DaysSinceOrder
"qjlee" wrote:
> Hi,
> I have an order table which contains the following fielde: 1). orderid (th
is
> is the order number 2). clientid 3). orderdate.
> I need to script so that I can find out those clientids which do not have
> place an order for at least 90 days.
> Can you tell me how to program it?
>
>|||Please post DDL, sample data and expected results
(http://www.aspfaq.com/etiquette.asp?id=5006 )
Since you have a ClientID column in your Orders table, I am guessing that
you have a Clients table somewhere. Here is a complete guess:
SELECT ClientID, ClientName
FROM Clients
WHERE ClientID NOT IN (SELECT ClientID FROM Orders WHERE DATEDIFF(d,
OrderDate, CURRENT_TIMESTAMP) <= 90)
"qjlee" <qjlee@.discussions.microsoft.com> wrote in message
news:B84E46A2-9291-4D17-A625-3DBADD9746B1@.microsoft.com...
> Hi,
> I have an order table which contains the following fielde: 1). orderid
> (this
> is the order number 2). clientid 3). orderdate.
> I need to script so that I can find out those clientids which do not have
> place an order for at least 90 days.
> Can you tell me how to program it?
>
>
I have an order table which contains the following fielde: 1). orderid (this
is the order number 2). clientid 3). orderdate.
I need to script so that I can find out those clientids which do not have
place an order for at least 90 days.
Can you tell me how to program it?Read the documentation. You want to select clientids which are NOT IN a
subquery that selects all clients that have ordered in the last 90 days. You
could also use a join where max order date is less than 90 days ago.
RR
"qjlee" <qjlee@.discussions.microsoft.com> wrote in message
news:B84E46A2-9291-4D17-A625-3DBADD9746B1@.microsoft.com...
> Hi,
> I have an order table which contains the following fielde: 1). orderid
(this
> is the order number 2). clientid 3). orderdate.
> I need to script so that I can find out those clientids which do not have
> place an order for at least 90 days.
> Can you tell me how to program it?
>
>|||Something like this should give you the client and their last order date.
declare @.DaysSinceOrder as numeric
set @.DaysSinceOrder = 90
select
clientid ,
max(orderdate)
from "YourTableHere"
group by clientid
having max(orderdate) < getdate()-@.DaysSinceOrder
"qjlee" wrote:
> Hi,
> I have an order table which contains the following fielde: 1). orderid (th
is
> is the order number 2). clientid 3). orderdate.
> I need to script so that I can find out those clientids which do not have
> place an order for at least 90 days.
> Can you tell me how to program it?
>
>|||Please post DDL, sample data and expected results
(http://www.aspfaq.com/etiquette.asp?id=5006 )
Since you have a ClientID column in your Orders table, I am guessing that
you have a Clients table somewhere. Here is a complete guess:
SELECT ClientID, ClientName
FROM Clients
WHERE ClientID NOT IN (SELECT ClientID FROM Orders WHERE DATEDIFF(d,
OrderDate, CURRENT_TIMESTAMP) <= 90)
"qjlee" <qjlee@.discussions.microsoft.com> wrote in message
news:B84E46A2-9291-4D17-A625-3DBADD9746B1@.microsoft.com...
> Hi,
> I have an order table which contains the following fielde: 1). orderid
> (this
> is the order number 2). clientid 3). orderdate.
> I need to script so that I can find out those clientids which do not have
> place an order for at least 90 days.
> Can you tell me how to program it?
>
>
Subscribe to:
Posts (Atom)