Showing posts with label sqlserver. Show all posts
Showing posts with label sqlserver. Show all posts

Wednesday, March 21, 2012

Differnce between SqlServer 2000 and 2005

Hi,

I want to know major functionalites differences between Sql server 2000 and 20005..Am expection ans as soon as possible

With Best Regards

C.Rajesh

Read the Books On Line as soon as possible.

Books On Line 2000:http://www.microsoft.com/downloads/details.aspx?familyid=a6f79cb1-a420-445f-8a4b-bd77a7da194b&displaylang=en

Books On Line 2005:http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

Questions like this will not solicit any replies unless you have specific questions or ask more politely rather than demand.

Friday, March 9, 2012

Different version of SQL Server (DTS)

Can I get high confidence that DTS packages (Saved as a *.DTS File) using SQL
Server Enterprise Manager 2000 (Based Version 8.00.194) on Windows XP Service
Pack 1 would run using SQL Server DTSRun.exe (Based Version 8.00.194) on
Windows 2000 Server SP3, if I can confirm that the DTS packages worked O on
DTSRUN.exe (Based version 8.00.194) on the same Windows XP Professional SP1
workstation?
Furthermore, if the DTSClients are upgraded later to SP2 or SP3, would there
be much issues?
Am I also right in thinking that the DTSRun.exe version can be of a
different (lower) version from the SQL Server 2000 database to which the DTS
packages will access and update?
That worked for me.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Patrick" <questions@.newsgroup.nospam> schrieb im Newsbeitrag
news:BE1EF7BB-F9FF-4AD6-9D3F-5D4A919BA10D@.microsoft.com...
> Can I get high confidence that DTS packages (Saved as a *.DTS File) using
> SQL
> Server Enterprise Manager 2000 (Based Version 8.00.194) on Windows XP
> Service
> Pack 1 would run using SQL Server DTSRun.exe (Based Version 8.00.194) on
> Windows 2000 Server SP3, if I can confirm that the DTS packages worked O
> on
> DTSRUN.exe (Based version 8.00.194) on the same Windows XP Professional
> SP1
> workstation?
> Furthermore, if the DTSClients are upgraded later to SP2 or SP3, would
> there
> be much issues?
> Am I also right in thinking that the DTSRun.exe version can be of a
> different (lower) version from the SQL Server 2000 database to which the
> DTS
> packages will access and update?
|||> Can I get high confidence that DTS packages (Saved as a *.DTS File) using
> SQL
> Server Enterprise Manager 2000 (Based Version 8.00.194) on Windows XP
> Service
> Pack 1 would run using SQL Server DTSRun.exe (Based Version 8.00.194) on
> Windows 2000 Server SP3, if I can confirm that the DTS packages worked O
> on
> DTSRUN.exe (Based version 8.00.194) on the same Windows XP Professional
> SP1
> workstation?
Yes

> Furthermore, if the DTSClients are upgraded later to SP2 or SP3, would
> there
> be much issues?
No

> Am I also right in thinking that the DTSRun.exe version can be of a
> different (lower) version from the SQL Server 2000 database to which the
> DTS
> packages will access and update?
Yes, you're right.
Regards,
Kevin
"Patrick" <questions@.newsgroup.nospam> wrote in message
news:BE1EF7BB-F9FF-4AD6-9D3F-5D4A919BA10D@.microsoft.com...
> Can I get high confidence that DTS packages (Saved as a *.DTS File) using
> SQL
> Server Enterprise Manager 2000 (Based Version 8.00.194) on Windows XP
> Service
> Pack 1 would run using SQL Server DTSRun.exe (Based Version 8.00.194) on
> Windows 2000 Server SP3, if I can confirm that the DTS packages worked O
> on
> DTSRUN.exe (Based version 8.00.194) on the same Windows XP Professional
> SP1
> workstation?
> Furthermore, if the DTSClients are upgraded later to SP2 or SP3, would
> there
> be much issues?
> Am I also right in thinking that the DTSRun.exe version can be of a
> different (lower) version from the SQL Server 2000 database to which the
> DTS
> packages will access and update?
|||Why have you not applied any services packs? Build 8.00.194 works, but there
are of course bugs otherwise MS would not have released 4 service packs
since then. You should apply service packs to clients as well as the server,
so that you get the benefit for the client components such as DTS.
Darren Green
http://www.sqldts.com
http://www.sqlis.com
"Kevin" <anonymous@.discussions.microsoft.com> wrote in message
news:eAsFI7oWFHA.1240@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
using[vbcol=seagreen]
> Yes
>
> No
>
> Yes, you're right.
> Regards,
> Kevin
> "Patrick" <questions@.newsgroup.nospam> wrote in message
> news:BE1EF7BB-F9FF-4AD6-9D3F-5D4A919BA10D@.microsoft.com...
using
>

Different version of SQL Server (DTS)

Can I get high confidence that DTS packages (Saved as a *.DTS File) using SQ
L
Server Enterprise Manager 2000 (Based Version 8.00.194) on Windows XP Servic
e
Pack 1 would run using SQL Server DTSRun.exe (Based Version 8.00.194) on
Windows 2000 Server SP3, if I can confirm that the DTS packages worked O on
DTSRUN.exe (Based version 8.00.194) on the same Windows XP Professional SP1
workstation?
Furthermore, if the DTSClients are upgraded later to SP2 or SP3, would there
be much issues?
Am I also right in thinking that the DTSRun.exe version can be of a
different (lower) version from the SQL Server 2000 database to which the DTS
packages will access and update?That worked for me.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Patrick" <questions@.newsgroup.nospam> schrieb im Newsbeitrag
news:BE1EF7BB-F9FF-4AD6-9D3F-5D4A919BA10D@.microsoft.com...
> Can I get high confidence that DTS packages (Saved as a *.DTS File) using
> SQL
> Server Enterprise Manager 2000 (Based Version 8.00.194) on Windows XP
> Service
> Pack 1 would run using SQL Server DTSRun.exe (Based Version 8.00.194) on
> Windows 2000 Server SP3, if I can confirm that the DTS packages worked O
> on
> DTSRUN.exe (Based version 8.00.194) on the same Windows XP Professional
> SP1
> workstation?
> Furthermore, if the DTSClients are upgraded later to SP2 or SP3, would
> there
> be much issues?
> Am I also right in thinking that the DTSRun.exe version can be of a
> different (lower) version from the SQL Server 2000 database to which the
> DTS
> packages will access and update?|||> Can I get high confidence that DTS packages (Saved as a *.DTS File) using
> SQL
> Server Enterprise Manager 2000 (Based Version 8.00.194) on Windows XP
> Service
> Pack 1 would run using SQL Server DTSRun.exe (Based Version 8.00.194) on
> Windows 2000 Server SP3, if I can confirm that the DTS packages worked O
> on
> DTSRUN.exe (Based version 8.00.194) on the same Windows XP Professional
> SP1
> workstation?
Yes

> Furthermore, if the DTSClients are upgraded later to SP2 or SP3, would
> there
> be much issues?
No

> Am I also right in thinking that the DTSRun.exe version can be of a
> different (lower) version from the SQL Server 2000 database to which the
> DTS
> packages will access and update?
Yes, you're right.
Regards,
Kevin
"Patrick" <questions@.newsgroup.nospam> wrote in message
news:BE1EF7BB-F9FF-4AD6-9D3F-5D4A919BA10D@.microsoft.com...
> Can I get high confidence that DTS packages (Saved as a *.DTS File) using
> SQL
> Server Enterprise Manager 2000 (Based Version 8.00.194) on Windows XP
> Service
> Pack 1 would run using SQL Server DTSRun.exe (Based Version 8.00.194) on
> Windows 2000 Server SP3, if I can confirm that the DTS packages worked O
> on
> DTSRUN.exe (Based version 8.00.194) on the same Windows XP Professional
> SP1
> workstation?
> Furthermore, if the DTSClients are upgraded later to SP2 or SP3, would
> there
> be much issues?
> Am I also right in thinking that the DTSRun.exe version can be of a
> different (lower) version from the SQL Server 2000 database to which the
> DTS
> packages will access and update?|||Why have you not applied any services packs? Build 8.00.194 works, but there
are of course bugs otherwise MS would not have released 4 service packs
since then. You should apply service packs to clients as well as the server,
so that you get the benefit for the client components such as DTS.
Darren Green
http://www.sqldts.com
http://www.sqlis.com
"Kevin" <anonymous@.discussions.microsoft.com> wrote in message
news:eAsFI7oWFHA.1240@.TK2MSFTNGP14.phx.gbl...
using[vbcol=seagreen]
> Yes
>
> No
>
> Yes, you're right.
> Regards,
> Kevin
> "Patrick" <questions@.newsgroup.nospam> wrote in message
> news:BE1EF7BB-F9FF-4AD6-9D3F-5D4A919BA10D@.microsoft.com...
using[vbcol=seagreen]
>

Saturday, February 25, 2012

Different locking behavior..

This might not be an sqlserver issue but i dont know where to post it..

We got two sqlsevers dedicated for system testing, the only difference between the two is that server 1 is equipped with a Pentium III proc. Server 2 has an Xeon proc. Service packs, database versions are exactly the same.

All traffic goes through MTS = Serializeble.

From one quite long save operation the servers behave completely different. On te Xeon server the transaction takes less than one sec while on the pentium III server it takes up to 20 sec.

Ive used performance monitor to see whats happening and the "SQLServer:Memory:allocated locks" value is showing a completely differnet value.

On Xeon it goes up to 1050 locks, on pentium III it explodes up to 1 234 881 locks!!

My guess is that it can take up to 20secs to allocate all those locks!?

We have swithed MTS server and sqlservers but the behaivor remains for sqlserver 1..

Nothing strange in the eventlogs..

Should the execution plans differ between xeon and pentium III procs?

Im totally lost here..hope you can understand the problem :)Have a look at the query plans and see if they are different. Could be due to out of date or different statistics.

This is a lot easier to diagnose and optimise if all your access is via stored procs.

Tuesday, February 14, 2012

Differences between sqlserver 2000 and sqlserver 7.0

Hi Friends,

Can some please let me know the differences between sqlserver 2000 and sqlserver 7.0

The most important two are in SQL Server 2000 DRI(declarative referential integrity) is built in and Unicode collation in down to column level and no need to reinstall to enable Unicode collation. There is the limited implementation of XML and the query processor was improved to correct some join operations returning wrong data. The differences between SQL Server 7.0 and 2000 are minor, major changes are between SQL Server 6.5 and 7.0 and SQL Server 2000 and 2005. Run a search for what is new in SQL Server 2000 BOL(books online). Hope this helps.