Just an additional question on top of it. Lets say that in this case I wanted one more column which is not a part of this index. So in that...

Thanks John and Gail. Now I understood it more clearly after relating to the practical lab results and theory. The clustered index column is present in all non clustered indexes....

Thanks. But...

One option as suggested above is a backup, pretty clean and simple way. copy it over FTP and let your clients use it.

However, if they insist to have the database...

ramana3327 (1/3/2014)

---

Thanks for the reply.

So there is no option to move the database online. Then instead of issuing those commands, we can do the detach & attach method right? Please...

I store them on local drives and make sure they are backed up each night. Keeping them on a local drive, other than the OS drive is still better.

Thanks

chandan

Excel has its own limitations as pointed out but why you need to retrieve millions of rows from the database. Is it going to be used for some reporting? Fetching...

ramana3327 (1/2/2014)

---

Hi,

I am trying to moving the database files while it is online, instead of detach and attach method. I have a database test_copy. I have test_copy data & log...

Grant Fritchey (12/17/2013)

---

And ditch the NOLOCK hint.

If the table has 100K of records, this looks like it's also returning over 100K of records. Is the WHERE clause not filtering at...

MSQLDBA (12/12/2013)

---

Hi Buddies,

I am facing the same problem even my database Auto_close option is False. When the application team running package, database going on suspect mode. rest of the time...

Burned my hands with heavy deletes once, so...

One question here, don't you think the T-log file will keep growing even during the rollback? If the...

Koen Verbeeck (10/25/2013)

---

chandan_jha18 (10/25/2013)

---

Koen Verbeeck (10/25/2013)

---

It might depend on indexes, the physical location of the rows in the pages and how the query plan is generated.

Let's assume it's "random" unless...

Koen Verbeeck (10/25/2013)

---

It might depend on indexes, the physical location of the rows in the pages and how the query plan is generated.

Let's assume it's "random" unless you specify another...

Bhuvnesh (9/25/2013)

---

chandan_jha18 (9/23/2013)

---

Purging data in batches can be considered but considering that the website is a 24*7 environment, there will be locking issues at times plus high CPU and...