Forum Replies Created

Viewing 15 posts - 23,836 through 23,850 (of 49,552 total)

  • RE: Memory almost 90 % using in SQLSERVR.EXE

    What's the setting for max server memory? Is AWE enabled?

    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

    August 29, 2011 at 4:34 am

    #1374431

  • RE: HOW to Delete multiple log file of a db

    Ivan Mohapatra (8/28/2011)

    how to remove 1 log file dear

    p.s. That term of address is becoming offensive. I am not your 'dear'

    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

    August 29, 2011 at 4:32 am

    #1374430

  • RE: Are the posted questions getting worse?

    Jeff Moden (8/28/2011)

    Understood, but the infringer needs only file a counter notice and "boom", the ISP has to put the material back within 10-14 days.

    They can, but if...

    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

    August 29, 2011 at 4:24 am

    #1374425

  • RE: HOW to Delete multiple log file of a db

    Steve already told you how to remove it.

    Steve Jones - SSC Editor (8/28/2011)

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

    The log file you want to delete cannot have active VLFs and it must be empty. So if...

    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

    August 29, 2011 at 4:19 am

    #1374424

  • RE: View vs Ad-hoc T-SQL

    Or... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    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

    August 28, 2011 at 6:57 pm

    #1374360

  • RE: Encrypt SQL tables

    Depends. What are you trying to protect against?

    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

    August 28, 2011 at 5:31 pm

    #1374354

  • RE: Are the posted questions getting worse?

    Jeff Moden (8/28/2011)

    Something else I've found out is that most people just ignore you because they think that once it's on the internet, it's public domain even if there...

    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

    August 28, 2011 at 5:29 pm

    #1374352

  • RE: Clustered Indexes? Sedimentary, my dear Watson

    Ken Lee-263418 (8/28/2011)

    OK, in my case there was a tinyint field, in the entire table, and that field had only one value. I know what that value is. The second...

    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

    August 28, 2011 at 5:26 pm

    #1374351

  • RE: Clustered Indexes? Sedimentary, my dear Watson

    Ken Lee-263418 (8/28/2011)

    In a telephone directory, I can know that the second of 5 books would have "Lee" in it. When I find the 300+ pages of Lee's, I 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

    August 28, 2011 at 3:20 pm

    #1374339

  • RE: HOW to Delete multiple log file of a db

    Ivan Mohapatra (8/27/2011)

    so,as i also want to know that why there are 2 log file for 1 db.

    Short answer: because someone added a second file. It's not necessary, it's not...

    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

    August 28, 2011 at 1:43 pm

    #1374325

  • RE: Clustered Indexes? Sedimentary, my dear Watson

    Ken Lee-263418 (8/28/2011)

    In order to set up a partitioned view (not indexed) you MUST define a value that has a check constraint in the primary key. I figured since all...

    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

    August 28, 2011 at 11:36 am

    #1374310

  • RE: Are the posted questions getting worse?

    WayneS (8/28/2011)

    Jeff Moden (8/27/2011)

    Gosh... outright theft of articles just keeps getting worse and even more blatant. Take a look at the following and then click on the Feb/Mar 2009...

    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

    August 28, 2011 at 8:49 am

    #1374295

  • RE: script need for Index size belongs to HEAP, clustered, non clustered index

    Remove the filter and idx.index_id < 2 if you want nonclustered indexes as well.

    index_id 0 = heap

    index_id 1 = clustered index

    index_id >=2 = nonclustered index

    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

    August 27, 2011 at 7:30 am

    #1374235

  • RE: Getting NULL for Object Name when trying to decode sys.dm_tran_locks.resource_associated_entity_id

    Or loop through and create a temp table with all of the sys.partitions (partition_id, database_id, object_id, index_id) in it and join to 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

    August 27, 2011 at 6:14 am

    #1374228

  • RE: Need help configuring FreeNAS 8.0 for a "lab rat" SQL Server cluster for home use

    It's part 1, Jonathan hasn't written the rest yet.

    It mentioned the storage in the list of things needed only (so far)

    While we are covering downloads, the following additional items will...

    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

    August 27, 2011 at 6:12 am

    #1374227

Viewing 15 posts - 23,836 through 23,850 (of 49,552 total)