ScottPletcher (9/10/2012)

---

Lynn Pettis (9/7/2012)

---

The real test will be against a 1,000,000 (or so) table. I will try and set up such a test tonight at home. One of...

The query string for OPENQUERY is restricted to 8KB, for BOL:

http://msdn.microsoft.com/en-us/library/ms188427(v=sql.100).aspx

Ajdba (9/10/2012)

---

Hi,

I have a variable of @sql_str nvarchar(max) and it is giving me error saying '...it is too long and maximum length is 8000'; when I do select LEN(@sql_str),...

So, is it wrong to code these processes to do the clustrered index first if it needs to be rebuilt as well as any nonclustered indexes?

GilaMonster (9/10/2012)

---

Lynn Pettis (9/10/2012)

---

One more thing, if you need to rebuild a clustered index and a nonclustered index on the same table be sure to do the clustered index first....

One more thing, if you need to rebuild a clustered index and a nonclustered index on the same table be sure to do the clustered index first. Otherwise the...

Phil Parkin (9/10/2012)

---

Lynn Pettis (9/7/2012)

---

Phil Parkin (9/7/2012)

---

Lynn's solution is the way to go.

In her solution, basedata is a CTE - effectively a subquery in this case - from which...

Probably, but I am still new at writing pivot/unpivot queries...

Easy question, especially after working another post on SSC regarding exactly this issue.

Raghavendra Mudugal (9/10/2012)

---

Hugo Kornelis (9/10/2012)

---

Raghavendra Mudugal (9/10/2012)

---

Hugo Kornelis (9/10/2012)

---

Good question - though I am waiting for the first person to claim that "error, error" should also be considered correct because...

Sean Lange (9/10/2012)

---

hehe I hadn't looked at today's question of the day. Seems to be in conjunction with this post. Same issue exactly. We should all three get this one...

I helped support PeopleSoft HR and Finance systems for 5...

Fragmentatioin is not something that can be prevented, it has to be managed.

I would start by reading the following articles:

http://www.sqlservercentral.com/articles/Indexing/68439/

http://www.sqlservercentral.com/articles/Indexing/68563/

http://www.sqlservercentral.com/articles/Indexing/68636/

sstteevvee22 (9/10/2012)

---

Thanks Lynn. Using your code, now I get this:

Msg 4145, Level 15, State 1, Line 24

An expression of non-boolean type specified in a context where a condition is...

spin (9/10/2012)

---

hi

i have a proc which i need to include/exclude specific the account codes based on the being free of charge accounts

so....

if @FOCYN = 1

set @foc1 = '40015'

set @foc2...