Forum Replies Created

Viewing 15 posts - 271 through 285 (of 459 total)

  • RE: Index Scan and Index Seek

    Jack Corbett (7/6/2009)

    The Optimizer uses statistics to determine if a seek or a scan is the likely "best" access method for a given query. It actually takes a very...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

    July 6, 2009 at 11:56 am

    #1020533

  • RE: Are the posted questions getting worse?

    Steve Jones - Editor (7/6/2009)

    BTW, it's good to be back, and I have no idea what happened in this thread, but it certainly has a lot more posts.

    Time to switch...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

    July 6, 2009 at 11:52 am

    #1020530

  • RE: Are the posted questions getting worse?

    GSquared (6/30/2009)

    Roy Ernest (6/30/2009)

    I can hold m ground in English but I am not coming anywhere near you Gus.... 😛

    I read and mostly understood Frank Herbert's "Dune" when I was...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

    June 30, 2009 at 1:55 pm

    #1017933

  • RE: Are the posted questions getting worse?

    WayneS (6/29/2009)

    Hey gang... I'm looking to take "She who must be obeyed" (in this case, both my wife and mother... ) to Niagra Falls. Does anyone here know anything about...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

    June 30, 2009 at 7:36 am

    #1017565

  • RE: Are the posted questions getting worse?

    Regarding the Nth Normal Form, and I guess on a more philosophical level, is it true that the more normalized a database is, the less fragmentation occurs so the more...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

    June 29, 2009 at 8:55 am

    #1016883

  • RE: Are the posted questions getting worse?

    GSquared (6/29/2009)

    GilaMonster (6/28/2009)

    Lynn Pettis (6/27/2009)

    Okay, you were between 6 and 10 when I learned that in University. Not exactly when or which school I was in when I had...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

    June 29, 2009 at 7:27 am

    #1016810

  • RE: Can we take the backups to Multiple drives in SQL Server 2005?

    Steve Jones - Editor (6/26/2009)

    I agree with Gaby. The day your backup fails is likely the same day your disk array will fail. Don't play around. Make sure these work...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

    June 26, 2009 at 9:19 am

    #1016111

  • RE: Can we take the backups to Multiple drives in SQL Server 2005?

    If you absolutely must backup remotely, use a third party backup utility (we use Litespeed from Quest, but SQL Backup Pro from Redgate is also good). The backup is...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

    June 26, 2009 at 7:20 am

    #1016006

  • RE: Trusting Online

    Double-checking a solution suggested by the more seasoned gurus on this or other sites is perfectly fine. If I run it on my own desktop, and it doesn't work,...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

    June 25, 2009 at 11:51 am

    #1015513

  • RE: Common questions asked in SQL Server DBA Interview

    GilaMonster (6/23/2009)

    ...As to whether a DBA needs to know normalisation or not depends on their job. If all they're doing is backups, watching space and monitoring jobs, then no they...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

    June 23, 2009 at 9:40 am

    #1014047

  • RE: Transaction log not shrinking after Maintenance Task

    GilaMonster (6/18/2009)

    jordonpilling (6/18/2009)

    Now, I have a weekly Index rebuild task which may be bloating the log file considerably as you say. What I will do then is, alter my Weekly...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

    June 22, 2009 at 9:53 am

    #1013416

  • RE: Common questions asked in SQL Server DBA Interview

    GilaMonster (6/22/2009)

    Gaby Abed (6/22/2009)

    A deadlock is where two blocks can't make nice (they block each other), and SQL Server kills the one that is taking up less resources?

    That's one...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

    June 22, 2009 at 9:41 am

    #1013402

  • RE: Common questions asked in SQL Server DBA Interview

    Grant Fritchey (6/19/2009)

    Matt Miller (6/18/2009)

    I like your questions Grant. I usually just add in one more, it's actually usually my first (fail is and it's time to call it...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

    June 22, 2009 at 8:58 am

    #1013360

  • RE: Lax Security - Database Weekly (June 22, 2009)

    We've finally gotten serious about updating a whole bunch of our production servers (mainly SQL 2000, SQL 2005 seem to be up to date). But the scary thing is...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

    June 20, 2009 at 1:22 pm

    #1012876

  • RE: Mimicking partitions in SQL 2000

    Steve Jones - Editor (6/17/2009)

    The order of the SELECTs shouldn't matter, AFAIK. The query optimizer is supposed to know what is where in a partitioned view and not query those...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

    June 17, 2009 at 12:00 pm

    #1011180

Viewing 15 posts - 271 through 285 (of 459 total)