nsaireddymca (6/15/2011)

---

dear sir

char(10) means it accepts upto 10 charecters but i am using 1.sai 2.siva it means 7 bytes,6 bytes memory will be wasted ok

if i am using varchar(10)...

golden-1131024 (6/15/2011)

---

The column data type is varchar(15).

In fact, I have the index rebuild and statistics update just after the restoration from the backup.

FYI, after i change the cost of threshold...

You can do a blank run with @execute = 0 and @Print = 1.

You can try with maybe just the 75% and 1000 pages and then go down gradually to...

Ya I read the same info about heaps (if you were not the teacher about that topic). It would certainly be a good idea to find all the tables...

Craig Farrell (6/15/2011)

---

Ninja's_RGR'us (6/15/2011)

---

I can't wrap put my head around the fact that I single handedly beat that figure alone, while having a job and actually providing value (no offense...

Top month for The Thread :

201091613

I can't wrap put my...

A fast san can fill up 30 GB of log in less than 15 minutes.

Sounds like you are doing everything right.

I would check these 2 options out :

What's the...

Then if it's the case I'd make sure to check for fragmentation, make damn sure those stats are updated daily, maybe even more than once.

And finally I'd use option recompile...

sqldba_icon (6/15/2011)

---

GilaMonster (6/15/2011)

---

As Grant said, the plan is generated and cached before execution starts. It's the plan for the batch, SQL doesn't compile statement by statement.

Run the statements individually, you'll...

Well me 15 times over and Gail 25 times over. SHould be enough to...

SQLRNNR (6/15/2011)

---

Steve Jones - SSC Editor (6/15/2011)

---

OK, here are the current top posters:

SQLRNNR - 2567

GilaMonster - 1957

Lynn Pettis - 1775

Alvin Ramard - 1745

Steve Jones - SSC Editor - 1434

Grant Fritchey...

What I posted WORKS. So that means you have more code or a new error.

Please provide whatever you left out... including the [new]...

There once was a forum like this. I got a "free" look after being the first one to 10K posts and the first and only poster to ever beat...

All I can offer is my debug mechanism. Maybe it'll spark you on your way.

#1 Change all first() expressions with a static text or number.

Make sure that works.

Then add...

#1 I'm...