Forum Replies Created

Viewing 15 posts - 34,411 through 34,425 (of 49,552 total)

  • RE: Update a filed in the group

    Biz (1/26/2010)

    Thank you for your reply.

    Thats giving me the real data i want.

    But

    When I tried all values for Rank as false, its giving me NULL as value.

    How can...

    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

    January 26, 2010 at 7:30 am

    #1108661

  • RE: DBCC shrinkfile()

    Sourav-657741 (1/25/2010)

    -- Is it suggestible to opt for datafile shrink since it gives birth to fragmentation.

    No.

    Shrinking causes massive fragmentation and will just result in the data file growing again next...

    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

    January 26, 2010 at 2:03 am

    #1108507

  • RE: [Help] Optimize report query

    I'm not sure if you want help writing a query or optimising an existing one.

    If you want help writing a query, please post table definitions, sample data and desired output....

    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

    January 26, 2010 at 2:01 am

    #1108506

  • RE: Looking the best way to storing NOT NULL in table

    miss.delinda (1/25/2010)

    My reason to make it Remarks is Not Null because it'll allow me to index this column

    if me make it this Remarks allow Null, this column can't be indexing

    Create...

    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

    January 26, 2010 at 1:54 am

    #1108504

  • RE: understand following concepts of resouce database:

    andrewkane17 (1/25/2010)

    isn't this a point of failure that cannot be easily be remedied whenever the mssqlsystemresource.mdf and mssqlsystemresource.ldf ever become corrupt?

    Yes, but since those only change when service packs/hotfixes...

    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

    January 26, 2010 at 1:50 am

    #1108501

  • RE: sql server 2005 query

    Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.

    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    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

    January 25, 2010 at 1:47 pm

    #1108378

  • RE: Are the posted questions getting worse?

    Think I've found the crystal ball... Doesn't seem to be showing much though.

    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

    January 25, 2010 at 1:24 pm

    #1108366

  • RE: Db level trigger

    You can't actually do that.

    DML triggers, the type that fire after data changes, are per-table and have to be created on a table.

    The database-level triggers are DDL triggers, they fire...

    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

    January 25, 2010 at 1:20 pm

    #1108363

  • RE: Looking the best way to storing NOT NULL in table

    My honest opinion...

    If a column is optional and it's valid and allowed for there not to be an entry in that column, make it nullable and let null stand for...

    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

    January 25, 2010 at 1:18 pm

    #1108362

  • RE: alloc_unit,type question

    gmamata7 (1/25/2010)

    So here, the bold text lines, even if the index type is clustered & non clustered, the alloc unit showing as IN_ROW_DATA

    Correct

    because it show IN_ROW_DATA for only heap right?...

    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

    January 25, 2010 at 1:06 pm

    #1108349

  • RE: can synchronous mirroring cause long running transactions?

    The principal should detect that the mirror's not accessible and go into the disconnected state. Should.

    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

    January 25, 2010 at 12:44 pm

    #1108339

  • RE: can synchronous mirroring cause long running transactions?

    winston Smith (1/25/2010)

    If i get a network issue between my mirror and primary, and am using synchronous mirroring, is this a sure way of getting long running transactions.

    Maybe. Depends whether...

    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

    January 25, 2010 at 12:16 pm

    #1108324

  • RE: rebuilding Indexes Online?

    You can't. Indexes that contain XML or the MAX datatypes must be rebuilt offline. That includes the clustered index of a table that has one of those columns in it.

    You...

    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

    January 25, 2010 at 12:10 pm

    #1108319

  • RE: A dumb question about Distinct - I posted this in the wrong forum earlier by mistake

    The_SQL_DBA (1/25/2010)

    Gail, I think I missed it completely. I removed the distinct from the second query now..

    Nope. You've fixed one out of 3.

    Why have you left the brackets around the...

    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

    January 25, 2010 at 12:05 pm

    #1108316

  • RE: Urgent development question

    Greg Edwards-268690 (1/25/2010)

    Just a thought...

    If this is development, you may want to review the design.

    Absolutely. Comma-delimited lists in a column are a violation of 1st Normal Form and are...

    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

    January 25, 2010 at 12:03 pm

    #1108315

Viewing 15 posts - 34,411 through 34,425 (of 49,552 total)