michael.wiles (7/2/2010)

---

Grant Fritchey,

You alluded to the fact that you look at work history with applicable knowledge in order to give someone a position. How does someone usually get work...

michael.wiles (7/2/2010)

---

If the bar is a test to get a job, then getting a degree should be made irrelevant and not be a requirement. If someone can pass a...

Dan.Humphries (7/2/2010)

---

If you where a box of crayons what color would you be and why?

I love when these types of questions get asked!

Can someone tell me how this tells...

Really? Huh. I haven't had the chance to test it, but I would have sworn it would work. Ah well, not first time I've been wrong. Sorry for offering hope.

Jack Corbett (7/2/2010)

---

Grant Fritchey (7/2/2010)

---

Look at who is doing those pre-cons. Adam, Paul, Kim, Kalen, Itzik... That's...

saad_Ahmad1 (7/2/2010)

---

Thanks for the reply.

We don't have access to the Production Database that is cutting the T-logs. The production database is with a third party. They simply provide...

Look at who is doing those pre-cons. Adam, Paul, Kim, Kalen, Itzik... That's the A-List pretty much....

Jack Corbett (7/2/2010)

---

Grant Fritchey (7/2/2010)

---

Did that blog post upset...

From the sounds of things, I'd be looking at the queries more than I'd be worrying about the amount of memory. Yes, you're hitting the cache & the buffer hard,...

I've never had a problem getting a block this way. Open one query window:

BEGIN TRAN

UPDATE TableX

SET Col = 42

WHERE Id = 66

Open a second query window:

UPDATE TableX

SET Col = 92

WHERE...

Although, thinking about it, if the database is in Standby mode, you should be able to run a backup and use the COPY_ONLY option to avoid breaking the log chain.

Since the Standby server is just holding a copy of the production backups, I'm not sure why you'd want to also backup the Standby server. At that point you're creating...

Same way you troubleshoot & tune anything else. Identify the most costly statement and tune that first. One way to identify this would be to set up a server-side trace,...

You would only move to another location if that other location is bigger. More...

I'm not so sure about testing. The interview process where I work includes considerable time at the white board. We talk about queries & table structures & TSQL. I'll put...