Raghavender (12/21/2009)

---

Hi All,

Can we defrag the clustered indexes ?

when I am running query:

select * from sys.dm_db_index_physical_stats(DB_ID(), NULL, NULL, NULL, 'DETAILED')

I am getting the same index two or more times on...

I am not certain I follow your question.

The code does do a select top 26, and then an additional insert after that for 27. The insert for 27 is...

You're welcome.

The best answer is - as a safeguard - but...

Gus has some valid points. Amongst those is the double posting. When posting the question, if you double post - it will just add to your frustration as...

Given the updated information, the solution provided by Lynn is what you need.

Curse you Lynn for beating me to the punch again 😉

HAHA

Lynn Pettis (12/21/2009)

---

Joe-420121 (12/21/2009)

---

The following procedure is OK?

1. Create Table [backup12212009] with BIGINT Indentity

2. using SSIS export data from old table to [backup12212009]

3. Delete old table

4. Rename backup12212009

Can do as...

Sounds like a riddle - are you plucking petals from a flower as you count the ways? I...

Or look at the other thread on that rahulsony111 started

http://www.sqlservercentral.com/Forums/Topic837454-148-1.aspx#bm837479

Thanks - will do.

Lynn Pettis (12/21/2009)

---

CirquedeSQLeil (12/21/2009)

---

I'm curious what the need is to convert a date to a Number. I would leave the date as one of the datetime datatype in sql...

Thanks Gus. I was hoping for that kind of response.

Along the code copy comment - It would be nice to be able to use the ifCode for SQL code...

I'm curious what the need is to convert a date to a Number. I would leave the date as one of the datetime datatype in sql 2005.

Now to get...

Good to know.