You can grant execute to a...

I don't think there's any tools out there that will do quite what you're looking for. You can get bits & pieces of it. For example, a good ER diagramming...

Excellent. See you...

You're stepping into a minefield of sorts here. This is the long-standing discussion between natural keys and artificial keys. I don't want to kick up too much mud, so I'll...

If you're planning on storing the entire file, I wouldn't recommend using SQL Server. Instead, I'd store it on the file system. If you're using 2008, you could use the...

Without bringing in other langauges such as PowerShell or C#, you're probably doing the best you can, especially when you consider that gathering information on 2008 is really different from...

jeardilam (9/23/2009)

---

HI, Actually I need to update a Fact Table, I´m trying this statement

while (select id_promotionSub FROM dbo.sipFTdataStage)=5

begin

...

I've talked to her offline. She's...

Sorry I'm late to the party Lynn. This is a fantastic article. It's practically a how-to on writing a good performance test article. Well done.

Jack Corbett (9/22/2009)

---

Grant Fritchey (9/22/2009)

---

Jack Corbett (9/22/2009)

---

Anyone want to take a look at this one? It's about statistics aging and query performance. I gave an answer, but I'm...

Jack Corbett (9/22/2009)

---

Anyone want to take a look at this one? It's about statistics aging and query performance. I gave an answer, but I'm not sure that I'm...

SSSolice (9/22/2009)

---

There is a Where clause. It is indeed an "old-style" join. What I'm looking for is the term used to describe the old-style join. I've seen it used here...

Just an insert is not a cause for deadlocks. You've got to have more than one process attempting to get exclusive access to a row or page. Two shared locks...

jcrawf02 (9/22/2009)

---

Grant, Bitbucket just pointed out to me that you're coming to my hometown in a couple weeks! Can't wait to see you speak in Columbus, recruiting the rest of...

Hello Threadites. Can someone check this. I can only see a single SPID in the deadlock information posted here, but someone else is seeing lots more. Is something wrong with...