Forum Replies Created

Viewing 15 posts - 45,301 through 45,315 (of 49,552 total)

  • RE: The text, ntext, and image data types are invalid in this subquery or aggregate expression.

    Is there a question here?

    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 1, 2008 at 8:09 am

    #851902

  • RE: Full Receovery Model BUT NO LOG BACKUP FOR PERFORMANCE

    Paresh Randeria (8/1/2008)

    We have real time OLTP application where data is continously written into the database. Very high Insert.

    This database is full recovery and we are not talking Log back....

    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 1, 2008 at 7:58 am

    #851892

  • RE: SQL Server 2005 Developer x Windows Vista Business

    Could you be a bit more specific about the problem 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

    August 1, 2008 at 7:41 am

    #851875

  • RE: SQL Server 2005 Developer x Windows Vista

    Duplicate post. Direct replies to the following thread please.

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

    August 1, 2008 at 7:41 am

    #851874

  • RE: SQL 2005 Database Integrity Check Error

    Simon (8/1/2008)

    Hi Gail, saw your reply to this thread, does this mismatch between the metadata and the physical allocation have any impact any the data resturned by any operations on...

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

    #851871

  • RE: Trace Flags 1204 and 1205 output changed?

    1204 and 1205 write deadlock graphs and associated info into the SQL error log. If you aren't having deadlocks, you won't see anything written. I wouldn't usually suggest using both....

    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

    July 31, 2008 at 1:17 pm

    #851502

  • RE: Implemetation of Large SQL Server DB(550 GB) on Blade/SAN

    Adam Bean (7/31/2008)

    I'd recommend making 1 data file per CPU (hyperthreading doesn't count, nor should be used anyways), preallocate a few gigs per data file, and enable the -T1118...

    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

    July 31, 2008 at 1:10 pm

    #851497

  • RE: Cannot shrink my db's log file

    Both full and bulk-logged recovery models require log backups. If you don't have log backups, the transaction logs will grow without bound (as you've noticed). You can have a look...

    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

    July 31, 2008 at 11:32 am

    #851441

  • RE: Cannot shrink my db's log file

    Full recovery mode?

    Any log backups running?

    Any replication running?

    Do you have a point-in-time recovery requirement for these databases?

    If you run the following query, what does it say for the offending databases?

    SELECT...

    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

    July 31, 2008 at 10:26 am

    #851406

  • RE: Missing Temp Tables Without Disconnecting

    lee.vance (7/31/2008)

    Hey Gail,

    What you are saying is exactly what is happening. When my stored proc ends, it deletes the temp tables even when I remark out the DROP statement.

    Because...

    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

    July 31, 2008 at 10:23 am

    #851403

  • RE: ldf File growing 100M per day...

    Don't forget to set the DB to simple recovery mode or schedule log backups.

    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

    July 31, 2008 at 10:04 am

    #851377

  • RE: Missing Temp Tables Without Disconnecting

    Temp tables are dropped when the connection closes or when the stored procedure that created them ends. You can create global tables, but that's a little messy and if more...

    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

    July 31, 2008 at 10:02 am

    #851375

  • RE: JOINING OF TWO TABLES

    Not enough information. Please post your table structure and give us an idea what the data looks like and what you want returned.

    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

    July 31, 2008 at 9:57 am

    #851370

  • RE: Transaction Deadlock

    rbarryyoung (7/31/2008)

    (actually, I cannot rememebr if you can use the mirror for reporting or not).

    You can, using database snapshots. The mirror DB itself is not usable (recovering).

    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

    July 31, 2008 at 9:52 am

    #851363

  • RE: Implemetation of Large SQL Server DB(550 GB) on Blade/SAN

    kokila (7/31/2008)

    We are not having plan to implement Cluster.

    we can afford only 15 mins downtime.

    A 15 minute downtime limitation and no cluster? What do you plan to do if 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

    July 31, 2008 at 9:52 am

    #851362

Viewing 15 posts - 45,301 through 45,315 (of 49,552 total)