Forum Replies Created

Viewing 15 posts - 35,641 through 35,655 (of 49,552 total)

  • RE: Create table permission denied

    Make the person a member of ddl_admin, or grant them CREATE TABLE rights in the database and ALTER rights on the schema.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 25, 2009 at 10:57 pm

    #1084452

  • RE: Concentrating in a noisy office environment

    Noise-reducing headphones are wonderful. In addition to their ability to cancel out background noise, they're a great excuse for ignoring irritating people who come to speak to you. Claim that...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 25, 2009 at 10:55 pm

    #1084451

  • RE: Forgot Sql server password

    Jack_Thiru from chennai (11/25/2009)

    If you give one simple and sample example for ALTER users. it will be help every one who looks for a solution for this kind of...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 25, 2009 at 10:39 pm

    #1084446

  • RE: Clustered Index seek

    Please post query, table definitions and index definitions, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    Is the query predicate a left-based subset of the clustered index key?

    This series on indexes may be worth a read...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 25, 2009 at 2:34 pm

    #1084362

  • RE: Are the posted questions getting worse?

    Greg Edwards-268690 (11/25/2009)

    GilaMonster (11/25/2009)

    Bru Medishetty (11/25/2009)

    Thanks Grant for the link, had a nice time reading the thread and of course something about outages / disasters in South Africa.

    We don't...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 25, 2009 at 1:45 pm

    #1084336

  • RE: Are the posted questions getting worse?

    Happy normal working week. 😀

    I'll hold down the fort while all the US people are off stuffing themselves with turkey and whatever else appears on a thanksgiving table.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 25, 2009 at 1:10 pm

    #1084309

  • RE: simple UNION ALL question

    mgodinez (11/25/2009)

    INSERT INTO #Production

    (Item, Description, Price)

    SELECT Apple, Fruit, 1 UNION ALL

    SELECT Orange, Fruit, 2 UNION ALL

    SELECT Pear, Fruit, 3

    GO

    Creating the table is no problem. However, after running the INSERT...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 25, 2009 at 12:30 pm

    #1084275

  • RE: General Question

    Add to the previous list:

    Pacific Telecoms

    NASDAQ (or at least they were last time I heard)

    MySpace

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 25, 2009 at 12:24 pm

    #1084272

  • RE: Are the posted questions getting worse?

    Bru Medishetty (11/25/2009)

    Thanks Grant for the link, had a nice time reading the thread and of course something about outages / disasters in South Africa.

    We don't have lots of...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 25, 2009 at 12:20 pm

    #1084270

  • RE: A welcome message to all Forum Newbies

    Bru Medishetty (11/25/2009)

    What do you guys say ??

    Far from the first time it's been suggested. Some people would read it, but I suspect those would be the kind of users...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 25, 2009 at 12:17 pm

    #1084267

  • RE: Restoration status

    Check the percent_complete column in sys.dm_exec_requests. I think that restore is one of the operations that populates it.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 25, 2009 at 12:13 pm

    #1084264

  • RE: Log File is MASSIVE

    GSquared (11/25/2009)

    So, South Africa has never had riots?

    Frequently. Often associated with strikes and demonstrations.

    Never had a local power outage due to a thunderstorm or some idiot drunk-driving a...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 25, 2009 at 9:37 am

    #1084168

  • RE: Are the posted questions getting worse?

    Alvin Ramard (11/25/2009)

    GilaMonster (11/25/2009)

    ........... (11/25/2009)

    Gila you sound like Doomsday Prophet. This is South Africa.

    Jy ook? So baie mense van Suid-Afrika op hierdie forums.

    I have no clue as to...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 25, 2009 at 9:16 am

    #1084146

  • RE: Query architecture

    http://msdn.microsoft.com/en-us/library/cc280362.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 25, 2009 at 8:29 am

    #1084090

  • RE: Are the posted questions getting worse?

    Alvin Ramard (11/25/2009)

    Bob Hovious 24601 (11/25/2009)

    Maybe y'all should give awards for worst suggestions. I'm sure the competition is tough.

    ........ and the winner is ... (drum roll) ... Oh,...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 25, 2009 at 8:20 am

    #1084078

Viewing 15 posts - 35,641 through 35,655 (of 49,552 total)