Viewing 15 posts - 15,781 through 15,795 (of 22,211 total)
While the SELECT is running, and using an index, it will prevent another process from dropping that index. Same with any other object in the database. Is there a way...
February 24, 2010 at 8:44 am
By master tables do you mean the system tables?
Or maybe what you're looking for are lookup tables, tables that contain relatively static data for use as referential integrity to provide...
February 24, 2010 at 8:39 am
Indexes are very unlikely to cause read queries to slow. They may not help read queries run faster, but they won't slow them down. Indexes can negatively affect inserts/udpates/deletes because...
February 24, 2010 at 8:35 am
GSquared (2/23/2010)
Elliott W (2/23/2010)
GilaMonster (2/23/2010)
Are we geeks or not?Yes, nerds NO!
I have a shirt that proclaims "GEEK" accross the front, just so there is no question..
CEWII
By derivation, a "geek" is...
February 24, 2010 at 6:14 am
RBarryYoung (2/22/2010)
February 22, 2010 at 6:58 pm
CirquedeSQLeil (2/21/2010)
Another option would be check out this puzzle roundup[/url] by Grant Fritchey.
Nuts. I was just going to point out that article I wrote several years ago. The comments in...
February 22, 2010 at 4:24 am
GilaMonster (2/21/2010)
Jack Corbett (2/21/2010)
Following MVP's on twitter last week during the MVP Summit made me wish I was there.Me too.
Add one more to the list of longing....
February 22, 2010 at 4:21 am
If I'm getting the question right, you're asking if you should have seperate tables for phones & emails from your contact table. Well, let me ask you a question. Do...
February 20, 2010 at 6:41 am
Without an execution plan, this is just idle speculation, but it does sound like you've already hit the nail on the head. Increasing I/O and decreasing CPU is a good...
February 20, 2010 at 6:32 am
GilaMonster (2/19/2010)
Grant Fritchey (2/19/2010)
February 20, 2010 at 4:07 am
CirquedeSQLeil (2/19/2010)
Grant Fritchey (2/19/2010)
CirquedeSQLeil (2/19/2010)
Grant Fritchey (2/19/2010)
Thanks for the great idea for a blog post:
Thanks for both the affirmation of fears on the topic...
February 19, 2010 at 1:21 pm
Steve Jones - Editor (2/19/2010)
Grant Fritchey (2/19/2010)
February 19, 2010 at 1:15 pm
CirquedeSQLeil (2/19/2010)
Grant Fritchey (2/19/2010)
Thanks for the great idea for a blog post:
Thanks for both the affirmation of fears on the topic as well as...
February 19, 2010 at 1:14 pm
tstaker (2/19/2010)
Grant Fritchey (2/19/2010)
Thanks for the great idea for a blog post:
@Grant
Awesome blog post. There was a time that I would of been...
February 19, 2010 at 1:09 pm
February 19, 2010 at 12:52 pm
Viewing 15 posts - 15,781 through 15,795 (of 22,211 total)