quote:

---

http://dictionary.reference.com/search?q=byte

---

So like I said: a byte's a byte.

In C/C++ and other HLL, there is a...

Consider using indexed views on the tables if the data is relatively static. The server materializes a physical table with the values as columns. The computation is performed...

My limited understanding is that the config switch merely enables the >2Gb memory on your server. I'm not sure that it really limits the OS to 1Gb or not.

...

My experience is that a clean build is better than an upgrade. I upgraded from NT4 -> 2k -> XP and had some weirdness. After a reformat/reinstall, smooth...

There are some "undocumented" stored procs that let you format and print the transaction log. It would show the time of events like this. But, again, it's undocumented.

...

delete

...

where code = 'a'

or code='b'

or code='c'

works too.

the "rowID" can be calculated with a subselect similar to:

select RowID=(select count(*)

from Table where xyz.Keys < Keys)

from Table xyz

For your 1000 rows, you will have an additional 1000 selects to...

I second the "no views in views" position. It's easy enough to break things with the broken things breaking other things too!

Like most open ended questions: It depends.

As noted, farming out responsibility can be a good thing. It offloads the app design tasks to the folks who know the app. Your...

If you don't already, I would subscribe the newsletters from Microsoft. I get 5-6 of them and they overlap quite abit. But better too many notices about...

Like most open ended questions: It depends.

As noted, farming out responsibility can be a good thing. It offloads the app design tasks to the folks who know the app....