Forum Replies Created

Viewing 15 posts - 22,096 through 22,110 (of 49,552 total)

  • RE: DBCC SHRINKDATABASE TRUNCATEONLY

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

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1208895-146-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 20, 2011 at 2:20 am

    #1410381

  • RE: i want an expert to deploy for me a databasebase mirroing for an important huge databsae

    What's your budget?

    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 19, 2011 at 1:40 pm

    #1410346

  • RE: Are the posted questions getting worse?

    Jeff Moden (11/19/2011)

    GilaMonster (11/19/2011)

    Um, I don't know what to say to something like this:

    SSIS would be a very simple setup:

    And this is why I don't like it. It stops 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

    November 19, 2011 at 1:16 pm

    #1410344

  • RE: How to store lots of data (1024 columns) for a particular reading

    Jeff Moden (11/19/2011)

    Dev (11/19/2011)

    1.) (Wide solution) Structure a table with 1024+2 columns.

    Pros: the sample reading is held together in the database.

    It’s possible with Wide Tables.

    A...

    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 19, 2011 at 1:04 pm

    #1410343

  • RE: performance issue

    Is it consistently slow or slow at random times? Slow for specific parameter values and fast for others or slow for 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

    November 19, 2011 at 12:50 pm

    #1410339

  • RE: There is insufficient system memory in resource pool 'internal' to run this query.

    checkai (11/18/2011)

    Seemingly, none of the tables have indexing applied.

    Well, there's your problem. Got anyone that knows anything about tuning? Maybe start here:

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

    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 19, 2011 at 10:55 am

    #1410330

  • RE: Why difference is there in Record Count & tables in Manual Log Shipping

    Are the log restores succeeding?

    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 19, 2011 at 10:27 am

    #1410327

  • RE: how to retreive the last login date (the required sql command)

    You'll probably get a better and faster answer at a MySQL site like http://forums.mysql.com or http://dbforums.com

    This is specifically a Microsoft SQL Server site and most people here aren't going 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

    November 19, 2011 at 10:26 am

    #1410326

  • RE: Are the posted questions getting worse?

    Um, I don't know what to say to something like this:

    SSIS would be a very simple setup:

    And this is why I don't like it. It stops the learning curve 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

    November 19, 2011 at 9:34 am

    #1410323

  • RE: Unable to login into my application after Using Hashbytes in Sql code

    Not enough information. I can't see your screen, I can't read your mind.

    What is the code for the login? Where does that error get thrown from and for what reason...

    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 19, 2011 at 6:04 am

    #1410302

  • RE: missing records on table

    Jeff Moden (11/18/2011)

    Walton (11/18/2011)

    It was an interview question. And no other information was provided.

    I'm not going to give you the answer but I will tell you where to look 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

    November 19, 2011 at 5:56 am

    #1410298

  • RE: Compressed Backup Issue, anyone?

    stevescanlan (11/18/2011)

    I ran a checksum (md5deep) on the files before and after the copy over the network and they are different on the destination server. The file is getting...

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

    #1410282

  • RE: Unable to login into my application after Using Hashbytes in Sql code

    No idea with the little that you've shown.

    What did you do with the 'password field'? What's the login error message?

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

    #1410281

  • RE: Compressed Backup Issue, anyone?

    MyDoggieJessie (11/18/2011)

    Regarding the default "server setting for compression"...if it's set up to compress backups in your SQL Server configuration, and you attempt to back it up on a sever 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 18, 2011 at 3:08 pm

    #1410224

  • RE: Compressed Backup Issue, anyone?

    MyDoggieJessie (11/18/2011)

    You'd have the same issues taking a backup from SQL 2008 with compression turned on (or accepting the defaul compression in the maintenance plan) and then attempting to restore...

    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 18, 2011 at 3:04 pm

    #1410223

Viewing 15 posts - 22,096 through 22,110 (of 49,552 total)