Forum Replies Created

Viewing 15 posts - 13,246 through 13,260 (of 22,213 total)

  • RE: Understanding Indexes

    Define a clustered index on the column that appears most frequently in the WHERE clause of SELECT

    statements.

    But not in JOIN criteria? No, no way. The basic rule for...

  • RE: Who created the job?

    sqldba_icon (2/14/2011)


    Grant Fritchey (2/14/2011)


    For a) you want to take a look at the default trace. That's how you can tell who made structural changes to the system.

    As far as b)...

  • RE: Sending data here, there and everywhere

    I'm not that familiar with it. Sorry. It really isn't used much.

  • RE: Varchar and the data dictionary

    From a performance standpoint, if you're moving more data, it's slower by that amount, but we're talking trivia most of the time. I just try to find out what the...

  • RE: sql server on testing server

    Anna_SQL (2/14/2011)


    I would like to test and evaluation sql server 2008.

    I downloaded an enterprise version of sql 2008 and I will install it on a testing machine.

    This machine will be...

  • RE: Who created the job?

    For a) you want to take a look at the default trace. That's how you can tell who made structural changes to the system.

    As far as b) goes, if the...

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (2/14/2011)


    Grant Fritchey (2/14/2011)


    Roy Ernest (2/14/2011)


    GilaMonster (2/14/2011)


    Craig Farrell (2/14/2011)


    GilaMonster (2/14/2011)


    $#%$$#%#@#!!!!!!!

    Another promising looking contract cancelled due to lack of @#$$#@$%$ budget!

    I'm almost at the point of walking away and...

  • RE: restore does not complete.. SQL server shuts down

    mw112009 (2/14/2011)


    After about 2 hours the result was the same. When I logged in I did not see SSMS running.

    Why did it shut down on it's own ?

    That, I don't...

  • RE: restore does not complete.. SQL server shuts down

    Crud. I mean restore. Sorry.

  • RE: restore does not complete.. SQL server shuts down

    Grant Fritchey (2/14/2011)


    mw112009 (2/14/2011)


    Our new retore attempt has taken 1 hour and 17 minutes so far. I am going to give this 2 hours at least and check again.

    Question: Can...

  • RE: Are the posted questions getting worse?

    Roy Ernest (2/14/2011)


    GilaMonster (2/14/2011)


    Craig Farrell (2/14/2011)


    GilaMonster (2/14/2011)


    $#%$$#%#@#!!!!!!!

    Another promising looking contract cancelled due to lack of @#$$#@$%$ budget!

    I'm almost at the point of walking away and going to work in...

  • RE: back up file size

    Raghavender (2/14/2011)


    GUYS FYI: I am not a fake guy, jst asked if I get any help from you guys or not.

    if you think this will encourage the fake guys, np,...

  • RE: Job stops running as per schedule after maitenance?

    Check the schedule on the job. It is probably disabled as well. Instead of disabling the job, if you disable/renable the schedule on the job I think you'l run into...

  • RE: restore does not complete.. SQL server shuts down

    mw112009 (2/14/2011)


    Our new retore attempt has taken 1 hour and 17 minutes so far. I am going to give this 2 hours at least and check again.

    Question: Can we run...

  • RE: Anyone Monitoring SQL Server from a Blackberry ?

    SanDroid (2/14/2011)


    Grant Fritchey (2/14/2011)


    paul.knibbs (2/14/2011)


    It's just that that is all you can do with the native tools. If you want to be able to see other information you can't....

Viewing 15 posts - 13,246 through 13,260 (of 22,213 total)