Not efficient? Converting every date in every row to 8000 bytes of CHAR formatted as 'mon dd yyyy hh:miAM/PM' and expecting it...

tarr94 (5/21/2012)

---

I'm running into a weird problem. I'm trying to do a simple select statement, which looks a little like this:

SELECT *

FROM MyView

where ({fn convert(MyDateField,...

Yes. SQLSaturday Wellington was...

Regarding the execution plan you posted (which I am going to assume is an example of slow running):

As...

HowardW (5/21/2012)

---

It is indeed annoying, but with Red Gate SQL Prompt at least, you can enable intellisense, but disable Auto List Members (which is the bit than generally interferes and...

Assuming the table is a heap, you need ALTER TABLE REBUILD. SQL Server does not properly clean up removed columns from heaps, even with DBCC CLEANTABLE and ALTER INDEX...

Ah, I wish it had been clearer that the partitions were ordered by date.

Of...

dwain.c (5/21/2012)

---

Very cryptic, but I get your point that...

Gullimeel (5/20/2012)

---

I have added some 4 points at the start of the script and I hope it will be enough to make sure that when this can be used and...

Different semantics (see HowardW's two observations earlier).

CREATE TABLE table2

(

key1 char(3),

[date] ...

If you think that was 'pleasant', you're lucky Joe Celko didn't see your post :laugh:

The fact that the database engine was completly rewritten does...

c2k (5/20/2012)

---

I have a simple table with two columns containing integer values. I would like to compute a third column that is a ratio of the first two columns but...

Jeff Moden (5/20/2012)

---

The articles are missing a lot of information and even have some perceived errors in them (talking about page splits with no indexes on the given test table,...

This is where I would start, comparing actual plans for a 2-second...