you can execute that in batches like on every go 10000 rows will get...

@eseosaoregie,

Not all people ( including me ) can understand exec paln iin any format (here xlsm format) . i found it all impossible to read it. so always try to...

eseosaoregie (4/21/2010)

---

I created the computed column and the index on that column. The computed column is as follows

--Add Computed Column

ALTER TABLE MyTable

ADD comp_column AS substring(LineRead,2,4) varchar

--Create Column

CREATE INDEX IX_COMPColumn...

yes it should be non clus. index

Isn't it working fine ?

i think...

Better way would be; test or analyze everything at test server/environment; set your benchmarks then hit the production

Better way would be , create a DTS package and schedule it.

RakeshRSingh (4/21/2010)

---

I further analyzed the problem on a test database and found that the culprit is SQL Server VSS Writer running while I am taking ntbackup of the database backup...

Performance tunning is very VAST area. it will taker years of practice.

You can tune your db thru

1. SQL Server profiler

2. DTA (Database Engine Tuning Advisor)

3. DMVs(Dyanamic management views)

4. DBCC commands

but...

To implement mirroring across the domain , you need to make domain trustable (using certificates)

see the below links

http://www.mssqltips.com/tip.asp?tip=1705

http://www.codefound.com/implementing-database-mirroring-in-sql-server-2005-across-domains/

rafa.aborges (4/20/2010)

---

We turned on the row level versioning on our database. It's on for almost 15 days. But this morning the tempdb transaction log got full.

My question is if...

@shilpa

If you are not satisfied with lowell post.

Please post sampla data with desired output(i got bit confused with your problem).

Post your sql query which you are using to export data

can you post some probable reaons...

i am not sure about your comment but , out dated statistics...