Are you referring to dbWarden?

http://www.sqlservercentral.com/articles/Monitoring/98106/[/url]

What are the data types of the columns? Wondering if you're not suffering from a collation issue. A litmus test for this would be one of the instances may churn...

If you want to display the result that way in the SQL output, then yes.

What you're seeing there is what SQL server is passing back, or the "output". I'm assuming you're looking at the profiler event RPC:Completed and not RPC:Started? The later may give...

Are you looking for uniqueness for:

1. a AND b (a,b) = 8 rows, which includes the one you said it doesn't

2. a OR b = 1 row (7,10,'j')

3. a UNION...

Here's a sample code you can run which will show you what we're talking about. Notice you're also using only the date portion of the datetime, so there may be...

OH! I re-read and if you're only looking to get 'c' column values here's an approach that can do it using a CTE:

declare @a table (a int,b int,c...

Here's one way to do it:

declare @a table (a int,b int,c char(1))

insert into @a

select 1,17,'a' union all

select 1,15,'b' union all

select 2,15,'c' union all

select 3,14,'d' union all

select...

Or in other words, converting it to a DATETIME rather than a VARCHAR(10) is undermining what you're trying to do.

This may come in handy.

http://www.sql-server-helper.com/tips/date-formats.aspx

I think you want this:

SELECT CONVERT(VARCHAR(10), GETDATE(), 110) AS [MM-DD-YYYY]

One question - how often are you backing up your log?

You may want to consider dummy variables to prevent parameter sniffing, that could explain what you're seeing. Here's one article about parameter sniffing:

http://blogs.technet.com/b/mdegre/archive/2012/03/19/what-is-parameter-sniffing.aspx

This is a great article, but it appears there's some confusion over various standards that float within UPC-A depending on the prefix. Where the article states the following, "The three...

Well, here's the thing, perhaps context will help point to why I'm asking. And if there's not a good article on this perhaps I'll do the research myself and post...

Figured I'd update my findings in case anyone ever runs into the same issue. After interrogating the DMV's and further review, we determined that the high volume of "Other" waits...