WayneS (10/16/2011)

---

Grant Fritchey (10/16/2011)

---

BTW, I've just been deleting Thread emails for the last week. It was easier than trying to keep up. Did I miss anything big? Marriages, deaths, taxes,...

BTW, I've just been deleting Thread emails for the last week. It was easier than trying to keep up. Did I miss anything big? Marriages, deaths, taxes, who won the...

WHOOP! SQL Chuck Norris makes an appearance... and then some goofball sings about reading plans in the wrong direction.

GSquared (10/10/2011)

---

Stefan Krzywicki (10/10/2011)

---

He's not scary! If worse comes to worse, buy him a beer after and...

GSquared (10/10/2011)

---

The computer is my friend.

The computer wants...

She's an ED-9000.... You have 15 seconds to comply... 10 seconds... 5 seconds...

No, you don't have to talk to a sales rep. Just follow the link and download the software. You'll have to leave your name & email address. It's that easy.

Monitoring and development are two, very different things.

I work for a company, Red Gate Software, that makes tools for database development, like SQL Prompt, SQL Compare & SQL Source...

try running a select from sys.dm_exec_requests to see if there are any connections on that database that are active.

Are you, yourself, connected to the database when you try to...

Gianluca Sartori (10/7/2011)

---

Grant Fritchey (10/6/2011)

---

For additional methods of dealing with parameter sniffing, check out Chapter 38 of the SQL Server MVP Deep Dives II[/url] book. It covers things not included...

This is a tough one. It's hard to know what you need to know in that situation. The main thing I'd focus on finding out is, which databases can the...

chandan_jha18 (10/6/2011)

---

Grant Fritchey (10/6/2011)

---

chandan_jha18 (10/6/2011)

---

Grant Fritchey (10/5/2011)

---

paul_ramster (10/5/2011)

---

Your outer query has the WHERE clause:

where PostedDate='1/19/2011'

and PostedDate is defined in the view as:

CAST(CAST(SUBSTRING(WH_Status.StatusHistory,CHARINDEX('Batch posted successfully',CONVERT(VARCHAR(MAX),WH_Status.StatusHistory))-35,26) AS DATE) AS DATETIME) AS PostedDate

You...

Sean Lange (10/6/2011)

---

Jack Corbett (10/6/2011)

---

I refuse to feel old until the president of the U.S. is younger than me. Eventually it will happen, but not yet.

Never really listened to...

Time to start the education. Quintessential Ramones. But my own preference is for this.

Hurry, hurry, hurry...

Stefan Krzywicki (10/6/2011)

---

GilaMonster (10/6/2011)

---

Ninja's_RGR'us (10/6/2011)

---

Grant Fritchey (10/6/2011)

---

Steve Jones - SSC Editor (10/6/2011)

---

If you haven't seen it, his 2005 Stanford Commencement. Excellent talk: http://www.youtube.com/watch?v=D1R-jKKp3NA&feature=player_embedded#!

A sad day, and a reminder that I'm...