Forum Replies Created

Viewing 15 posts - 43,936 through 43,950 (of 49,552 total)

  • RE: Shrinking the log file

    Ray Mond (10/8/2008)

    Inserting dummy records is no longer necessary in SQL Server 2005, as shown in the example. SQL Server handles that for you when you attempt to shrink...

    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

    October 8, 2008 at 11:59 am

    #882489

  • RE: FTP problem

    Please don't cross post. It just wastes people's time and fragments replies.

    No replies to this thread please. Direct replies to:

    http://www.sqlservercentral.com/Forums/Topic582765-148-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

    October 8, 2008 at 11:59 am

    #882488

  • RE: Sql server performance issues

    What are the specs of the two servers (memory, disk)?

    What's the max memory setting on the new server?

    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

    October 8, 2008 at 11:56 am

    #882486

  • RE: DBCC shrinkfile

    If the fragmentation is low (< 30%) then reorganise instead of rebuilding. If you can, switch the DB into Bulk logged recovery for the duration of the rebuild. Index rebuilds...

    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

    October 8, 2008 at 11:55 am

    #882483

  • RE: Changing sql keywords to lower or upper

    The fastest way would be to buy a copy of SQL Refactor (from RedGate). Otherwise you're going to be spending hours doing replaces of the various keywords and fixing any...

    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

    October 8, 2008 at 9:31 am

    #882397

  • RE: Sql server performance issues

    Not enough information to say anything useful.

    What were the specs of the old server. What OS, what version of SQL?

    What are the specs of the new server. What OS, what...

    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

    October 8, 2008 at 9:29 am

    #882394

  • RE: Query Tuning in TSQL

    TheSQLGuru (10/8/2008)

    1) Can anyone give me some justifications for the apparent agreement that table variables should be used for 100 rows??

    I use it as a rough thumb-suck 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

    October 8, 2008 at 9:23 am

    #882390

  • RE: Changing sql keywords to lower or upper

    Lynn Pettis (10/8/2008)

    I have to deal with the same thing where I work. If I need to modify a procedure, that is when I make any changes to formatting...

    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

    October 8, 2008 at 9:12 am

    #882375

  • RE: Changing sql keywords to lower or upper

    Dugi (10/8/2008)

    very easy ...CTRL+H then you have the options Find What = select ...Replace with: SELECT! then Find Next and you will find all them and if you want...

    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

    October 8, 2008 at 8:31 am

    #882330

  • RE: sqlserver 2005 Express

    Is there a chance that this DB ever was published in the past (transactional replication)? Could it have been restored/moved from a server where there was replication?

    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

    October 8, 2008 at 8:24 am

    #882321

  • RE: Need to created table with 2000 columns in sql server 2005

    SQL 2008 allows 30000 columns if a table is 'wide'. A wide table is one that contains a set of sparse columns (defined as a columnset, see Books Online 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

    October 8, 2008 at 8:22 am

    #882320

  • RE: Take the Plunge

    Depends where you are.

    Not all places in the world have bandwidth that's sufficient for this kind of thing.

    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

    October 8, 2008 at 8:20 am

    #882316

  • RE: DBCC shrinkfile

    sanjeev_krs2004 (10/8/2008)

    Hi,

    I have never deleted/archived anything from DB but when I ran DBCC shrinkfile command, size of DB has gone down from 80 GB to 45 GB. Could you please...

    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

    October 8, 2008 at 8:01 am

    #882284

  • RE: Few interview questions

    free_mascot (10/8/2008)

    2) If I have 350 columns in a table, how can I index each n every column?

    If performance is not a problem and by hook or crook you would...

    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

    October 8, 2008 at 7:37 am

    #882257

  • RE: urgent help needed

    What database are you trying to add the extended proc 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

    October 7, 2008 at 2:30 pm

    #881976

Viewing 15 posts - 43,936 through 43,950 (of 49,552 total)