Viewing 15 posts - 4,411 through 4,425 (of 14,953 total)
Brandie Tarvin (4/19/2011)
April 20, 2011 at 6:11 am
I'm not clear on what you're asking for here.
Disk I/O capacity is something you'd get from the specifications on the various pieces of hardware involved. It'll depend on what...
April 19, 2011 at 12:27 pm
Lynn Pettis (4/19/2011)
And once again Celko sticks his nose where it really wasn't needed. The OPs question had already been answered.
And Joe's answer, while demanding that others follow published...
April 19, 2011 at 12:22 pm
Joe, what leads you to assume that Project+Vendor+Country is a valid PK for this table? There's nothing in the data from the original question that supports that. Isn't...
April 19, 2011 at 12:21 pm
Craig Farrell (4/19/2011)
Lynn Pettis (4/19/2011)
And once again Celko sticks his nose where it really wasn't needed. The OPs question had already been answered.
Is it bad that after April Fool's...
April 19, 2011 at 12:07 pm
Check this for details: http://technet.microsoft.com/en-us/library/ms175519.aspx
Essentially, an IS lock is "Intent Shared", which allows other shared locks (selects, essentially) to access the same data.
Shared (S) locks allow concurrent transactions to read...
April 19, 2011 at 10:56 am
Scope_Identity works better than @@Identity specifically because of triggers. Can you use that?
April 19, 2011 at 10:47 am
Instead of a computed column based on the UDF, can you use a trigger to simply capture changes to the source-column and store them in a non-computed column? Use...
April 19, 2011 at 9:39 am
They actually both do the same thing. All of the work is the clustered index scan in both cases.
One "looks" more efficient, but only because it's showing the aggregate...
April 19, 2011 at 8:49 am
You say you want to train her "on certain areas", but not what those are.
Are you looking into performance tuning, or admin, or security, or something else?
April 19, 2011 at 8:39 am
Definitely better this year. Last year at this time, I was "temporarily self-employed" (at least, that's how the IRS sees it, because then they can bill me for more).
April 19, 2011 at 8:36 am
I blog an odd combination of movie reviews, religious experiences, and semi-random thoughts. None of it bears on work. None of it has any legal liability. I...
April 19, 2011 at 6:16 am
fname lname-1111520 (4/14/2011)
Craig Farrell (4/14/2011)
fname lname-1111520 (4/13/2011)
I get it: "then", "than", "there's", "there are". Stop reading (and I did), it can't be coherent.
Huh? Could you specifically...
April 18, 2011 at 1:39 pm
Tom.Thomson (4/11/2011)
Stefan Krzywicki (4/11/2011)
April 11, 2011 at 1:12 pm
GilaMonster (4/11/2011)
April 11, 2011 at 1:05 pm
Viewing 15 posts - 4,411 through 4,425 (of 14,953 total)