Viewing 15 posts - 406 through 420 (of 832 total)
Interesting stuff...so even if the NULL bitmap should theoretically grow to accommodate a new column, it won't until some data is actually put into the specified record? Presumably the storage...
February 15, 2012 at 4:18 am
sqlfriends (2/14/2012)
I remember I read before we should give minimum privilage to SQL server /agent service account.
This now becomes confusing
You may be confusing privileges on the host computer with privileges...
February 15, 2012 at 2:32 am
GilaMonster (2/14/2012)
Adding a nullable column is the same.
Is it possible it would have to expand the size of the NULL bitmap to accommodate the extra column, or is that always...
February 15, 2012 at 2:05 am
The LocalSystem account acts as the computer on the network, so if you give permissions for the computer account of the SQL server to the remote folder, SQL server should...
February 13, 2012 at 3:34 am
I would try running the queries you've got in your application in the database directly to see how fast they go--chances are this is a query optimisation issue thanks to...
February 13, 2012 at 3:27 am
Managed to get it right by a process of elimination--the other three answers looked wrong (especially the one about TRUNCATE not being logged!), so got the right one by default!
February 13, 2012 at 3:08 am
As a set in my ways C programmer, I find it irritating enough that SQL overloads the = operator to mean both assignment and a test of equality (I mean,...
February 2, 2012 at 4:21 am
A non-deterministic hash function wouldn't be terribly useful, would it? 😉
January 24, 2012 at 7:00 am
Hugo Kornelis (1/20/2012)
(Would you believe, after all of this discussion, that my largest database is 500 MB in size and lives on my laptop?)
You're right, I did mean 16-bit unsigned...
January 20, 2012 at 6:51 am
Hugo Kornelis (1/20/2012)
(Though I don't understand why MS would choose to use a signed integer to store page numbers; it's not as if...
January 20, 2012 at 5:57 am
Hugo Kornelis (1/20/2012)
January 20, 2012 at 4:46 am
Hugo Kornelis (1/20/2012)
with its current supported maximum database size of "only" 524,272 terabytes, it seriously falls short for this kind of challenge.
What actually imposes that limit? It seems a kind...
January 20, 2012 at 4:21 am
Frankly you'd be better off using something that would run natively on a Unix OS (such as MySQL or Oracle)...virtualisation would work, but you'd have to splash out for a...
January 19, 2012 at 1:13 am
Viewing 15 posts - 406 through 420 (of 832 total)