tonyarp05 61903 (8/26/2011)

---

Hi everyone,

Declare @testquery varchar(1000),

@test-2 varchar(200)

set @test-2 = '*Ma.01.01'

select @testquery =

'select code,id...

hehe. David Ortiz's first game back after being on the DL with a bum ankle. 1st to home on a Crawford double (ended on third) to right field. I remember...

Garfield and Jon

I don't usually buy food at ballparks. On a hot day, I'll get a slushy. Maaaaybe fries if I got some money burnin' a hole in my pocket. It's just...

Tom.Thomson (8/8/2011)

---

The key to the difference in the section you quote is the phrase "leaf level" in the description for Reorganising Indexes. I'll try to explain what happens, why...

Thomas Abraham (8/8/2011)

---

Thanks for the great question.

I thought that "Rebuilding an index drops the index and creates a new one. In doing this, fragmentation is removed, disk space is...

For the sake of clarification, your question is which operation removes page splits. Are you referring to page splits as the fragmentation (logically or physically ordered pages/extents?) that gets removed...

I thought the same thing as Markus, that is was a mapping issue between user and login since you mentioned overwriting the database and scripting the users/logins.

sp_change_users_login will work, but...

GSquared (8/4/2011)

---

Steve Jones - SSC Editor (8/4/2011)

---

Jack Corbett (8/4/2011)

---

GSquared (8/4/2011)

---

GilaMonster (8/3/2011)

---

Tom.Thomson (8/3/2011)

---

which stopped happening 11 years ago) because US immigration control has deteriorated to the point where no-one in his...

minds

2 minutes into the 12th and final round, calvo was beaten and bloody. His manager about to throw in the towel when Calvo suddenly showed a little spark! SharePoint had...

edit: see below

Mine, where I said it would duplicate, is because I was doing it through the GUI. When you make changes through the GUI, it produces a script that gets executed...

Ninja's_RGR'us (8/2/2011)

---

calvo (8/2/2011)

---

Ahh... that explains the disappearing...

correct