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

Don't spare him/her, not even a little bit.

What you might be seeing is the Business Intelligence Design Studio (BIDS), which is basically all the tools needed to create SSIS packages and SSAS cubes and is run through...

Have you tried setting the procedure to run using sp_procoption? That will enable a procedure to run when SQL Server starts up. You can also schedule jobs to run when...

Dan.Humphries (4/22/2010)

---

With all respect

How would writing 20 Million rows to a temp table not be part of the problem even with the for-mentioned query problems. I would be very surprised...

CirquedeSQLeil (4/22/2010)

---

Alvin Ramard (4/22/2010)

---

CirquedeSQLeil (4/22/2010)

---

Grant Fritchey (4/22/2010)

---

Alvin Ramard (4/22/2010)

---

You've got things on your property you want to get rid of? Gail did a great job of that this morning....

Temp table or not, this code:

((LTRIM(RTRIM(lt.name))

Is going to kill your performance. It's going to prevent any indexes on the tables from being used and you'll see nothing but table...

yoacer (4/22/2010)

---

Hi Atif,

I need to find a different solution Dynamic SQL is not what I want, I want another kind of solution even if I need to create a filter...