Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sreehari
Starting Member
37 Posts |
 Posted - 2006-05-22 : 07:40:32
|
| Hii am a new guy to sql server 2000, could u explain me the importance of service pack, i also heard like sp2,sp3,sp4..etc.what is the difference.Thanks in advance |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-05-22 : 08:05:59
|
| service packs contain fixes for bugs and sometimes new functionality.It is usually important to keep up to date - especially with the early service packs as they usually fix problems that prevent sql server from working properly.They are cumulative i.e. sp4 containes everything in sp1, sp2, sp3.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-05-22 : 08:27:49
|
| Note that the Service Pack usually covers the Client tools (like Query Analyser) as well as the server side stuff.So normally you need to run the Service Pack on both the server and on any client that has the client tools installed.There is sometimes an update to the documentation (referred to as "Books Online") too - this needs installing on all clients that need it [it basically just makes a new installation, overwriting any existing help file, so its not restricted to only upgrading an existing installation]And finally the "database communication layer" [ADO] is sometimes upgraded as part of a service pack, and also sometimes upgraded separately. This needs to be installed on any machine that will communicate with the SQL Server - which could, for example, be every PC running an application that connects to the database server.You need to make an opinion as to whether a given service pack is required. We have taken the decision NOT to implement SP4 on SQL2000 because it changes some characteristics of how some queries are run, a nd we don't have the resource to retest [stress test] the application to be certain that there are no adverse implications, and the rest of the "fixes" in SP4 are not of great concern to us.Kristen |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-05-22 : 08:32:49
|
And Kristen will now get 20 people jumping on all his posts saying "are you sure it does that with sp4?" ==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-05-22 : 08:40:48
|
Its not a problem Nigel, so long as they run a full set of tests before rollout  Kristen |
|
|
|
lesnic
Starting Member
8 Posts |
Posted - 2006-05-23 : 12:07:15
|
| Kirsten,I was interested to see your assertion that SP4 changes the way in which some queries are run. We have run sp4 for about 2 weeks now and we are getting a type of deadlock previously unseen, involving PAGLOCKs.The deadlock involves an insert in one spid and a SUM of rows on the other side. The insert has IX on the data page and is requesting IX on the index page. The SUM, which has an index hint to force the index, holds S on the index page requested and want S on the data page.Where do you get your info on the changed way queries are run?Les |
|
|
|
Kristen
Test
22859 Posts |
|
|
lesnic
Starting Member
8 Posts |
Posted - 2006-05-24 : 04:31:58
|
| Yes, Kirsten,I had already posted to that thread. Seems we're getting affected by the changes in locking involving PAGLOCKs mentioned several times in that thread. Can't wait to move to 2005.Les |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-05-24 : 05:00:26
|
| "I had already posted to that thread"Ah ... recursive-thread-syndrome - sorry about that!Kristen |
|
|
|
|
|
|
|
|
what is the use of Service pack in SQL Server