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...

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 will always get...

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 getting older as...

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 getting older as well. People I...

Script out the database. Like it says above, use SSMS to generate a script. You can also make calls to SQL Server Management Objects (SMO) from code to generate...

It's not something I've run into before. Are you up to date on the service packs? Have you looked to install any of the cumulative updates? I'd start there.

Just a...