should work...let me try this out..

Any help would be much appreciated...

The best book I ever read...it will make your basics rock solid...

Wrox.Beginning.SQL.Server.2005.Administration

Unfortunately, it is an old project and the application cannot not be upgraded to support SS2005 for time being. May be in future. Therefore I need to setup this server...

it is a requirement of a project.

You can do one thing, remove the indexes before you start the operation and once done apply them back. It will be much faster.

See this link for more information..

http://msdn.microsoft.com/en-us/library/ms179314.aspx

this one as well..

SELECT SUBSTRING(text,

-- starting value for substring

CASE WHEN statement_start_offset = 0...

You can get the same information by running following query

SELECT * FROM

sys.dm_exec_query_stats

CROSS APPLY

sys.dm_exec_sql_text(sql_handle)

I hope this helps

No it cannot...

roelofsleroux (2/2/2010)

---

dbo.fnLKPInstrumentExchangeKey is used to find the ExchangeKey of an instrument whether it is JSE, LSE, NYSE.

Its basically to avoid JOIN statements. I have a suspicion that it could have...

sgambale (2/1/2010)

---

I try this command from a query session in sql server 2005 management studio. I tried it both from mgmt studio of my sql server 2005 client and...

dba_neo (2/1/2010)

---

Team,

My Rebuild,Reorganize index job has been failing because of the following error,it is scheduled to be executed in only one db and the db is in simple mode.

ON...

Can you provide more information on your process? Like, what...

roelofsleroux (2/1/2010)

---

I have the following table:

The table stores daily stock market prices for over 8000 instruments(stocks) per day

DateKey INT PK

InstrumentKey INT PK

Op FLOAT

Cl FLOAT

Hi FLOAT

Lo FLOAT

WAVG FLOAT

Vol FLOAT

Status CHAR(1)

Cap FLOAT

I...