Forum Replies Created

Viewing 15 posts - 43,171 through 43,185 (of 49,552 total)

  • RE: Backup at anytime

    Don't backup to a network drive. It's slow and if the network glitches the backup will be useless. Backup locally and then copy the backup to the network drive.

    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 12, 2008 at 7:48 am

    #897539

  • RE: Transaction log filling up - transactional replication issue

    Animal Magic (11/12/2008)

    Thanks for the quick reply Gail, its the transaction log on the publicated database. I have just found out one of the developers has indeed run an...

    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 12, 2008 at 7:45 am

    #897537

  • RE: varchar(255) - syscomments - Update

    Use Enterprise manager to generate a script that contains all of the procedures and then do a find and replace. Even if you have to check each location before doing...

    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 12, 2008 at 7:37 am

    #897530

  • RE: Backup at anytime

    You can backup at any time. The backup adds load to the system, but it doesn't lock any objects.

    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 12, 2008 at 7:31 am

    #897518

  • RE: How To utilize log files

    goodguy (11/12/2008)

    I'm not a pro like all the others who have already ventilated this thread, but what I would do in this case is restore a backup on an independent...

    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 12, 2008 at 7:27 am

    #897511

  • RE: Transaction log filling up - transactional replication issue

    Is the transaction log growing or is the error log growing?

    Did that happen straight after an index rebuild, by any chance? Or an alter table statement?

    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 12, 2008 at 7:26 am

    #897509

  • RE: max nesting level error

    TOR (11/12/2008)

    And have already tried using CTE but seems it doesnt work on sql 2000. Please Advise...

    Please post SQL 2000 related problems in the SQL 2000 forums. If you post...

    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 12, 2008 at 7:21 am

    #897505

  • RE: Full-text search

    Duplicate post.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic601216-149-1.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 12, 2008 at 7:20 am

    #897503

  • RE: varchar(255) - syscomments - Update

    Do not, do not, do not ever directly update the system tables. Doing so is asking for big problems in the future.

    Generate the scripts of the procedures, search and...

    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 12, 2008 at 7:19 am

    #897500

  • RE: Long time running query

    Network latency

    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 12, 2008 at 7:10 am

    #897492

  • RE: Is there a better way for this code?

    Can you please post the table structure, some sample data and what you want as a result?

    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 12, 2008 at 7:10 am

    #897491

  • RE: How to increase the number of connections in SQL Server 2005

    By default the only max for connections is the maximum allowed by SQL which is 32767. If you're reaching that many concurrent connections on a dev system, I think 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

    November 12, 2008 at 7:07 am

    #897489

  • RE: Stored procedure usage statistics

    You can have a look at the sys.dm_exec_query_stats DMV. That contains execution counts and CPU, read, write and duration stats.

    Unfortunately the info's only there while the plan for 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 12, 2008 at 6:52 am

    #897477

  • RE: Securing Data

    That's security through obscurity and it doesn't work. It makes it harder to find the sensitive data, not impossible.

    Plus that now requires file backups synced with DB backups, careful security...

    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 12, 2008 at 6:41 am

    #897473

  • RE: Restoredatabse problem

    Amit Gupta (11/12/2008)

    yes i have other plan in a feature suggest me solution.

    Sorry, I don't understand.

    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 12, 2008 at 6:36 am

    #897471

Viewing 15 posts - 43,171 through 43,185 (of 49,552 total)