Notice how both rows have the same index_id. There's only one index there. A row is returned for each level that the index has in the B-Tree. Here's an MSDN...

Yeah, I didn't either. It was a...

What does the execution plan look like?

That's not a standard TsQL function, so you must have written it. Without the code, it's hard to know what's happenning. If you post the code for the function, you...

It sounds like you must have the trace events set up wrong.

BTW, you shouldn't run Profiler directly against production systems, especially if it's a system that is already experiencing performance...

Of course it's going to show a connection problem. You can't connect users when the license is exceeded.

But as Gail says, this won't cause performance issues on SQL Server.

The Dixie Flatline (4/23/2010)

---

Roy, I don't believe you personally have anything to worry about in this community. 🙂

What I can't understand is why some people think that the...

It's probably not an issue. Take a look at this Connect entry.

Dohsan (4/23/2010)

---

This should hopefully do the trick

--Create Our Varchar Date Test Table

IF OBJECT_ID(N'Tempdb..#D', N'U') IS NOT NULL

DROP TABLE #D

GO

CREATE TABLE #D

(

IDINT IDENTITY(1,1),

DateVARCHAR(8)

PRIMARY KEY CLUSTERED (ID)

);

INSERT INTO #D (Date)

SELECT '20100422'...

Are you looking for something like this:

CREATE TABLE dbo.x

(nodatetime NVARCHAR(50));

INSERT INTO dbo.x

(x.nodatetime)

VALUES ('5/5/05')

,('4/4/04')

,('3/3/zz');

UPDATE dbo.x

SET x.nodatetime = NULL

WHERE ISDATE(x.nodatetime) = 0;

SELECT * FROM dbo.X;

trivedi.nikesh (4/23/2010)

---

Dear Sir,

I am heartily thankful to you. I will apply your suggested measures.

Please correct me if I am wrong

Reason behind Query is not performing good due to (in case...

ajrendall (4/23/2010)

---

Wow!

Thanks for all the comments, much of what everyone has said has confirmed my suspicions. Basically I'm going to try a few tests with some large tables and see...

Then try to the SQL Agent. That will only run after SQL Server has completed it's startup.

Adam Machanic (4/22/2010)

---

CirquedeSQLeil (4/22/2010)I am really awe struck still at the comprehensive plagiarism on that site. Steve should also say something since SSC has the rights to some of...

CirquedeSQLeil (4/22/2010)

---

Jack Corbett (4/22/2010)

---

I'm pretty sure this is...