Forum Replies Created

Viewing 15 posts - 9,481 through 9,495 (of 9,725 total)

  • RE: Indexed Views - EXACTLY what is stored...

    Sam,

    Don't be too hard on the the people who ask this question.  I myself asked the question when I was first working on my MCDBA.  I had no experience with...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    August 24, 2007 at 9:35 am

    #729322

  • RE: 70-431 simulations question

    Hmm. Very interesting.  So the rhetorical question is: if there is only one way available of doing a sim on the exam, how can you possibly get one wrong other than...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    August 24, 2007 at 6:48 am

    #729246

  • RE: XML Data Types and mathmatical operations

    It would be the pre-summary details kept in that data type, which is why I was concerned about using mathmatical operations on it. 

    I see your point about everything else. ...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    August 24, 2007 at 6:45 am

    #729245

  • RE: 70-431 simulations question

    Yikes!

    I'm not personally worried, but I have to wonder how many people fail the exams because the sims are different from each other...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    August 24, 2007 at 5:22 am

    #729224

  • RE: 70-431 simulations question

    That makes sense.  I just hope whichever technique is used is consistant between the various exams. 

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    August 24, 2007 at 5:05 am

    #729217

  • RE: New Instance

    The short answer is "You can't".

    Standard only installs client tools on a PC / Laptop.  You need Developer version (or Express) to run a server instance on your laptop.  Workgroup might...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    August 23, 2007 at 12:15 pm

    #729069

  • RE: Indexed Views - EXACTLY what is stored...

    It would seem to me, given the number of columns he's accessing, that he probably has an equivalantly large row/recordset being returned to the view.  In that case, an indexed...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    August 23, 2007 at 11:21 am

    #729044

  • RE: TempDB CPU

    Tracey,

    Load is going to be high on Raid 1.  Higher for writing than for reading, because the disks are essentially making two copies of every transaction on the mirror.  Colin...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    August 23, 2007 at 10:44 am

    #729036

  • RE: dtswizard

    Are you looking under the Database Engine or did you actually connect via Object Explorer to the Integration Services object?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    August 23, 2007 at 4:13 am

    #728840

  • RE: TempDB CPU

    Tracey,

    No reason you can't do this in SQL 2000 that I'm aware of.  I just added a file to the TempDB on my local PC version of the database via...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    August 22, 2007 at 8:35 am

    #728588

  • RE: TempDB CPU

    Tracey,

    Look back at the code Colin posted.  Just change the FileName stuff (where it currently points to the D: drive) to your R: drive, path and new filename.  You'll have...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    August 21, 2007 at 7:15 am

    #728285

  • RE: 70-431 simulations question

    Thanks, Steve. 

    I know where to find a lot of stuff on the toolbars and menus, but I don't have either of them memorized and sometimes depend on the tooltips...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    August 21, 2007 at 6:56 am

    #728272

  • RE: TempDB CPU

    Files are objects that reside in FileGroups (think of it like individual sheets of paper in a manilla folder.  The folder is the file group and the sheets of paper...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    August 20, 2007 at 12:21 pm

    #728079

  • RE: In-Place or Side-by-Side Upgrade?

    I'd recommend a side-by-side.  This way you can test everything as you move it and if the move doesn't work, it's a work of moments to turn the old database...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    August 20, 2007 at 12:13 pm

    #728075

  • RE: Cannot connect to SQL Server 2005 on local machine

    Named Pipes is not strictly necessary for SQL Server 2005 to run.  Unless, of course, you don't have any other protocols set up.

    Also, sometimes weird errors happen when you don't...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    August 20, 2007 at 12:11 pm

    #728072

Viewing 15 posts - 9,481 through 9,495 (of 9,725 total)