Good news: there's a SP3 Beta!!

http://www.microsoft.com/downloads/details.aspx?FamilyId=D22317E1-BC64-4936-A14B-7A632B50A4CA&displaylang=en

What's new:

http://download.microsoft.com/download/0/e/5/0e5697be-028a-4da6-89a7-c18a9a1ac3c7/WhatsNewSQLServer2005SP3.htm

Cheers

That's the meaning for "dynamical".

More seriously: usually the port of the instance is the same. But sometimes (i.e. if the port is used by another service) SQL server will chose...

Are there any constraint on the table definition (i.e. identity fields, auto increment...)

Usually if the data you are inserting does not duplicate the key, the udate will success...

Use SQL Server Configuration Manager to check if your instance is configured for dynamic ports:

Under "SQL server network configuration" select Protocols for .

Double click TCP/IP and under the tab...

De gustibus non est disputandum.

I think that without the BEGIN ......

You can also get rid of the "BEGIN...END" stuff: after an IF, if you have a single statement, BEGIN...END is not needed.

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE initTran

...

GilaMonster (10/24/2008)

---

Performance testing code before deploying to production.

I got very tired of devs deploying code to prod without doing any form of performance testing on it. The code frequently performed...

To check indexes status you can use:

DBCC SHOWCONTIG 'tabname' 'indexname'

Or if you have SQL 2005 use the dm_db_index_physical_stats to show the status of your indexes.

For Example:

DECLARE @DB_NUMERO AS INT

-- Select...

supposing your hardware is well dimensioned (enough RAM, processor power...), configured and working,first thing you can do is to Check indexes!

Use profiler to check if the tables has the correct...

in the way proposed by rbarryyoung, I have the message only for the first view that gives an error.

I developed this (modifying some code found on the net).

It uses a...

I think you can, but you need to cluster both version.

So you need to install and cluster sql 2005 and after that install as separate instance and cluster also...

To my knowledge, you can use sp_helplogins: in the result set you have a column called Auser that means:

Yes = LoginName has an associated user name in a database....