WITH CTE (...

Agreed, you'll have to use a calendar table and a simple if statement to block / let the subscription run.

Keep in mind that those jobs are rebuilt every time the...

TheSQLGuru (8/2/2011)

---

1) I would shut down sql server and other processes on the box and run chkdisk.exe (you can use -? to get options) to find possibly bad sectors on...

Note to self, always follow you gut feelings ;-).

and what a gut if I say so myself.

Gianluca Sartori (8/2/2011)

---

If I have to take the cell phone into account, I'm paying something like 50/60 Euros a month.

You add the ADSL line and there you are: 100 Euros/month....

Good point Jeff, what do you want to get out of the indexed view that a normal view can,t give you?

WOW that's nice :w00t:.

If it's really faster it's 6 ms per 1M rows...

Yes everything counts but that's really squeezing every last bit out of the cpus!

Jeff Moden (8/2/2011)[hr

I haven't actually done a performance test but I know enough about machine language at the cycle level to say that it will always take fewer cycles to...

I assure you nobody wanted to insult you.

The bottom line is that each server / app is different and that I rarely if ever see something really standard accross the...

Koen Verbeeck (8/2/2011)

---

Gianluca Sartori (8/2/2011)

---

Ninja's_RGR'us (8/2/2011)

---

Jack Corbett (8/2/2011)

---

Man, reading about phone problems in other countries makes me less upset at what I consider poor customer service in the U.S. ...

Gianluca Sartori (8/2/2011)

---

Ninja's_RGR'us (8/2/2011)

---

Jack Corbett (8/2/2011)

---

Man, reading about phone problems in other countries makes me less upset at what I consider poor customer service in the U.S. Like most...

calvo (8/2/2011)

---

That there is a beastly script. It does a whole lot more than just reorg/rebuild when needed. That script will create functions, tables, procedures and do your laundry all...

Nope, I was going with round 2.

I always wait 24H before actually posting anything in case this is an exam or cert or late homework.

I was hoping for an evolution...

Forgot part of the question.

Yes it does online indexing.

It does BETTER than maintenance plan because it reindex only what needs to be, not everything.

You can set delays between index operations...