Gianluca Sartori (12/20/2010)

---

Yes, that's my post!

I couldn't load Grant's blog today, it seemed to be down, but now it loads and also I got a mail from him.

I can't believe...

So you want move the data between servers without downtime? That's harder than a simple backup & restore.

While you can backup your database in 32bit and restore it in 64bit,...

Check the execution plans on both queries. I'm pretty sure you'll see that they're different. You're hitting a bad parameter sniffing problem. I'd also suggest trying the query within a...

Paul White NZ (12/16/2010)

---

I just typed this successfully in 2008 SSMS with Intellisense on (which it always is):

SELECT ...

GilaMonster (12/16/2010)

---

Likewise....

I know I'm biased, but I really do like SQL Prompt and the way it works. I think SSMS intelisence is a good idea, poorly executed. Red Gate's product on...

SwayneBell (12/15/2010)

---

Grant Fritchey (12/8/2010)

---

That's a big topic. I'd suggest you take a look at this book (it's a free download) on Team Development[/url] from Red Gate. I wrote the chapters...

Jeff Moden (12/15/2010)Having some jitters is not a bad thing. Shaking uncontrolably is a bad thing... especially if you've had lots of water to drink.

I was a...

It's going to sound funny when I say this, but the sore throat must have something to do with how you speak. I really don't do anything in particular to...

traughberk (12/10/2010)

---

That's what I was struggling with. How unique does something need to be in order to be considered "selective"? I have SSN, dates, and some other data,...

SequelSurfer (12/10/2010)

---

Is open Write access on a Production Box a little generous or am I...

I'll pile on to this one a bit.

Should it be removed? Hell no! As others have already pointed out, there are legitimate reasons to shrink databases, especially in some...

jcrawf02 (12/9/2010)

---

Brandie Tarvin (12/9/2010)

---

Anytime a webinar is "sponsored" by a company, there's twenty minutes of advertising at the end.

Didn't...

I'd start with clustered indexes on the most select and most used column or columns. Then add non-clustered indexes from there. Remember if the key in a cluster covers the...

Steve Jones - SSC Editor (12/9/2010)

---

Grant Fritchey (12/9/2010)

---

Jack Corbett (12/8/2010)

---

Hey guys, I don't see any threadizens on the list of submissions to SQLRally yet! What's taking y'all so long....