After I do an Insert from one table to another ms sql 2005 consumes several
GB of memory.  After the process is done it does not seem to release the
memory back into the OS, unless I restart the ms sql service. The indexes in
both tables are disabled at the time of the Insert. ...

How can I regen the Id number in the PK field say starting from 250000. I
did some import for some millions of records and the starting seed was
wrong. So using the below code will change the Seed what other code can
change the ID Number for all records.

I can't imagine why it's so hard to find expressions or statements that
one has put into sprocs etc. Like if I have created a sproc named
procMyProc, and I want to locate all references to it in a sql server
2005 database, sql server management studio express seems about useless. ...

I have 4 fields below I want to concatenate into 2 fields, in the SQL
statement.
BeginTime               EndTime
1/1/1900 3:30:00 PM     9/1/1999 12:00:00 AM

I have a main SQL 7 stored procedure that accepts different parameters each
time and calls 15 child stored procedures which search for data and populate
some output tables.
The first time that the main stored procedure is called each day then it

I want to lock the records I got in my Select query from the time they where
selected until the end of the transaction (in the middle of the transaction I
do update) How do I do that?

Is it possible in SQL Server 2005 to debug a stored procedure? How?
Many thanks.

I have a 64 bit sql server. On it i need to set up a linked server to a
sybase 12 server - the sybase server is 32 bit.
now sybase have a driver for 32 bit operating systems however it does not
work on the 64 bit platform.

I have a db backup requirement. As shown in the attached image current system
is as follows:
  1. There are three source databases such as DB001, DB002 and DB003. Each
DB having one table as dbo.EMP and same table schema.

I recently upgraded to SQL 2008 Dev. Edition. When I attached a SQL2K
database with SQL 2008 SSMS, I noticed that SQL 2008 converted SQL 2000 to
the new SQL 2008 format.
Once a 2005 or SQL 2K database has been attached to SQL 2008, can it be

I have a column called PlaceID and it's an INT datatype.  I have a Case
statment to see if PlaceID is NULL or does it have a value.  Here is my
CASE:
CASE MoxyFIXPlaceOrder.PlaceID WHEN NULL THEN '*' ELSE 'abc' END

This is really helpful information about Generic Cialis.I found
another good one that helped me find a great website for
<a href="http://cheapgenericcialis.org/index9.html">Cheap Generic
Cialis</a>

I want to find out if a subset is contained in another subset.
The business case is: I want to find all materiel that may be added to a bom (Bill of Materiel).
Example:
Bom 1 can be used by departments 1 and 2.

I need some help setting up a user defined function.that will combine data
in a table into a single string.   I can do this all day long in VBA with
access but for performance reasons want to do this at the sql server.
Below is some detail on what I'm working with.

I need to select up to the 10th record for every primary key value in a table.
If I could add an IDENTITY column to the query & have it restart numbering
with every change in the promary key, the SQL query to achieve what I want is
simple. How do I create such an identity column?