Forum Replies Created

Viewing 15 posts - 10,501 through 10,515 (of 49,552 total)

  • RE: How to partition table

    arooj300 (1/5/2014)

    whenever we try to upload the data...the application will be hang or it stop uploading data.

    please tell me how to resolve this issue

    No where near enough information. There'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

    January 5, 2014 at 11:59 am

    #1677601

  • RE: How to partition table

    Define: 'not working properly'

    What's the purpose of partitioning? What do you expect to achieve?

    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 5, 2014 at 3:39 am

    #1677581

  • RE: SQL Server Backup Questions

    1 and 2: Google backup log SQL Server

    3: Google index data physical order (and be prepared to weed out the true from the false). Rather weird interview question.

    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 4, 2014 at 10:18 am

    #1677524

  • RE: Sql Server Services Will not Start

    If that's the error you're getting, refer to the section in that article on SQL being unable to access the error log. Last section iirc

    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 4, 2014 at 7:13 am

    #1677510

  • RE: Sql Server Services Will not Start

    See if this helps, or at least lets you narrow down the cause: http://www.simple-talk.com/sql/backup-and-recovery/the-sql-server-instance-that-will-not-start/

    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 3, 2014 at 2:06 pm

    #1677439

  • RE: Which Options I have if I don't want to shrink a datafile due to the known performance issues but I need to re-gain some space that the database won't use ever again??

    Do a once-off shrink and then rebuild your indexes afterwards. Don't shrink to the minimum, leave some space free.

    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 3, 2014 at 2:06 pm

    #1677438

  • RE: Memory Allocation Across Multiple Database Instances

    arrjay (1/3/2014)

    Hi John - I was going to allocate 7.2 gig (36 gig / 5 instances) to each database instance as thought this would be the most efficient way 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

    January 3, 2014 at 3:26 am

    #1677179

  • RE: Memory Allocation Across Multiple Database Instances

    arrjay (1/3/2014)

    I guess the reason for posting this in the first place is that I heard SQL will allocate all the memory to itself (allowing a small amount for OS...

    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 3, 2014 at 3:21 am

    #1677174

  • RE: Optimal size for TempDB files?

    VLFs only apply to log files.

    No, there's no downside to having the TempDB data files (which I assume is what you were asking about) be larger than strictly necessary. 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

    January 2, 2014 at 10:35 pm

    #1677111

  • RE: Memory Allocation Across Multiple Database Instances

    arrjay (1/2/2014)

    In terms of the database instances, I have installed SQL 5 times on the same server. This might not be called a database instance but I have 5...

    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 2, 2014 at 11:32 am

    #1677010

  • RE: Memory Allocation Across Multiple Database Instances

    arrjay (1/2/2014)

    I have created 5 separate database instances within the one physical instance.

    Can you clarify what you mean by 'instance'?

    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 2, 2014 at 9:50 am

    #1676980

  • RE: Optimal size for TempDB files?

    Nope.

    The optimal size for TempDB files is large enough that they don't have to grow under regular operations.

    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 2, 2014 at 7:19 am

    #1676897

  • RE: Question about a process

    Grant Fritchey (1/2/2014)

    Badly written apps provide nothing, or, as in this case, something misleading. But it can be anything.

    Implying that Management Studio is badly written (but we already knew 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

    January 2, 2014 at 6:20 am

    #1676869

  • RE: Logins per Second is over the threshold

    Andy CP (1/2/2014)

    How can I determine the 'normal threshold' for my server?

    Monitor it for a period of time, see what the particular counter you're interested in (logins/sec in this case)...

    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 2, 2014 at 5:53 am

    #1676856

  • RE: Question about a process

    david.alcock (1/2/2014)

    Actually, would a maintenance plan that is scheduled show as management studio rather than a sql agent job.

    Yes.

    A fact that I discovered the hard way the first time I...

    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 2, 2014 at 5:45 am

    #1676850

Viewing 15 posts - 10,501 through 10,515 (of 49,552 total)