Jeff Moden (7/29/2011)

---

😀 Not...

Jeff Moden (7/29/2011)

---

ericwenger1 (7/28/2011)

---

I have a request to allow the user to search on a converted datetime column(i.e. convert(varchar,column_name,101) mm/dd/yyyy). Is there

any trick to indexing this column. I guess if...

Thanks, but these are Estimated plans. We need the Actual plans 🙂

Ctrl+M to turn on Actual, then execute the queries. Pipe the results into a temp table using SELECT...INTO to...

Ninja's_RGR'us (7/29/2011)

---

opc.three (7/29/2011)

---

Apparently 🙂

PS I have been called Crazy, but my nick is opc.three. SSCrazy is...

Jayanth_Kurup (7/29/2011)

---

a clustered index on this column would result in slow inserts and updates coz the day comes first in the var char column and every time a day is...

Philip Yale-193937 (7/29/2011)

---

The most likely culprit is the SET ARITHABORT option.

By default in SSMS, this is OFF. Most applications will run with ARITHABORT ON. You will...

Apparently 🙂

PS I have been called Crazy, but my nick is opc.three. SSCrazy is just my...

This is me not taking the bait Jeff 😛

zlthomps (7/29/2011)

---

Yes, it does - But I would ideally be...

For the record, anything you can run from a CmdShell prompt you can run in a PowerShell session...so that can be your fallback. That said, there are better replacements for...

Elegant, thanks for posting back and sharing your PS experience :satisfied:

I agree with Michael, any indexes on the datetime column will be negated by surrounding the column with a CONVERT function in a search predicate.

I guess if it were in...

xp_CmdShell is one way to do it from within T-SQL. Kicking off a SQL Agent job that contains a CmdExec step is another.

Is "from T-SQL" a requirement?

PowerShell is much better...

Hi again Sqlsavy 😛

Take a look at this on 2005. You may have a different view after filtering out the ms-shipped tables:

SELECT DISTINCT

...

Not much to go on DIB IN...see if this fits:

http://www.sqlservercentral.com/Forums/FindPost490875.aspx