If you are using parameters on the procedure, there should be no need to validate the data length or data type.

For example:

CREATE PROCEDURE dbo.MyProcedure

...

Although not required - I would recommend patching to the latest patch level for each instance before installing the next. 2005 is at SP4 and you should have at...

Here is a script I use to identify the unused space allocated to a table. I have used this to identify HEAPS that have a lot of unused space.

...

After you restart SQL Server, it will start allocating memory as needed - up to the max memory setting. Once it hits the max memory setting, it will not...

cdumont (10/14/2011)

---

Every night when my SQL 2008 R2 does its nightly maintenance task to backup the DB's, it wont release the system memory after it completes.

The Maintenance job...

Yes, it will affect performance because it needs to read the database and move pages around. It...

No, this will not be possible because it isn't a backup. If you had a backup - then you could perform a partial file restore, but then again -...

Here is how I would do this:

1) Create two tables for the process - an odd/even pair (MyTransformedDataOdd, MyTransformedDataEven).

2) Create 2 synonyms - one for the current data, one for...

meghna.bhargav (9/10/2011)

---

Daily Backup is already taken of dev server but as it is 200GB, it occupies a lot space so I was wondering if we stop it , what will...

Another option is CROSS APPLY. Example:

select c.case_id

,m.description

,m.seq_num

from case_table c

cross apply (select top...

One trick I learned a while ago is to modify SSMS to change tabs to spaces and to change the default tab size to 8 characters instead of the default...

You can turn on SQLCMD mode which will allow you to use SQLCMD syntax. The one I think you are looking for is:

:r filename

That will load the SQLCMD code...

I wouldn't call it an active/active cluster. It is really a multi-instance cluster in the Windows/SQL Server world.

To create a multi-instance cluster, you need to create separate resources for...

The default connection settings for Oracle is explicit transactions. Which means you have to specifically issue a commit or rollback.

In SQL Server, the default is implicit transactions - which...

webtekkie (8/31/2011)

---

I am with you on being reluctant to shell out for Ent licenses, especially as you are working on an archiving process.

Is is necessary to reindex every index on...