Steve Jones - Editor (7/17/2010)

---

Has MS really done enough research on alternatives? The read-ahead mechanism seems designed to pre-fetch data and prevent further interrupts of the CPU needing to wait...

It's not exactly what you need, but interesting and handy anyway:

My favourite way to see which databases are in use by any user sessions (even if they just have it...

I'd say 'just about impossible'. Even if a piecemeal restore was done, and the unneeded file groups were marked defunct, there would be no way to remove...

A 64-bit operating system is certainly required. Whether the Xeon processor is capable of running 64 bit software...

That would explain a lot. Thanks, Gail.

The clue to this odd-looking behaviour is...

Can't be done, I'm afraid. Once the database has been upgraded, the files cannot be attached to an earlier version.

If you tell us more about why you need to...

A small modification, to allow for input strings that include one or more trailing spaces, and which will also work with a Unicode input string:

DECLARE @strVariable VARCHAR(100) = 'J:\SQL 2008...

vedpsoni (7/17/2010)

---

IN SQL 2000

1.Right click onto your server node, - an SQL Server Properties dialog will popup, In server setting

2.Enable "Allow modifications to be made directly to the system catalogs"...

doobya (7/7/2010)

---

where datediff(day, [field], getdate()) < 240 will force a scan (instead of a seek) but if the optimizer knew that the output of datediff decreases as [field] increases

(which is...

I have never known Gianluca to post otherwise 🙂

Good enough.

See the link I posted two posts back.

edit: here it is again, just to make it easy:

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

🙂

Tom.Thomson (7/16/2010)

---

...But a claim that any form of try-catch construct that alters the behaviour under some error conditions of code executed in the context of the try block is bad...

Lozenge! 😀

http://www.oxforddictionaries.com/page/103