Forum Replies Created

Viewing 15 posts - 36,406 through 36,420 (of 49,552 total)

  • RE: Table variable in Dynamic SQL

    Table variables are only visible in the scope that they are created in. They are not visible inside dynamic SQL.

    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, 2009 at 9:14 am

    #1063528

  • RE: shrinked my ss2k5 log file by below option

    Silverfox (10/8/2009)

    not saying I would ever use more than 1 log file.

    Only valid reason for multiple log files is space. If the drive that the log is on has...

    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, 2009 at 8:16 am

    #1063483

  • RE: Query performance

    Shark Energy (10/8/2009)

    I struggle to read the results of that because I get all the data, I summarise it all, but I don't know what it means. internet articles tend...

    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, 2009 at 8:00 am

    #1063468

  • RE: Isn't sysjobs in tempdb a system table because the owner defined while executing sp_help 'sysjobs' returns owner as dbo

    dreamthebest (10/8/2009)

    If this is the case why this tables are defined as system tables for sql server 2000.:hehe:

    Change in architecture. It was a major change SQL 2000 - SQL 2005

    Most...

    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, 2009 at 7:50 am

    #1063458

  • RE: shrinked my ss2k5 log file by below option

    Silverfox (10/8/2009)

    it looks like it just resized back to the free space in the log file and done nothing with the 2nd log file. if that is the case, then...

    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, 2009 at 7:49 am

    #1063457

  • RE: Performance Issue

    gupta1282 (10/8/2009)

    Can somebody guide me to solve this issue.

    Find the slow queries (or the ones consuming lots of CPU). Optimise the queries. This may involve rewriting the code, it may...

    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, 2009 at 5:43 am

    #1063362

  • RE: shrinked my ss2k5 log file by below option

    guptaajay1985 (10/8/2009)

    one transaction log file

    size 11.6 GB (before) now 1MB

    recovery mode full

    daily backup at 9:00 pm

    So no log backups?

    In full recovery you have to do log backups. If 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

    October 8, 2009 at 5:31 am

    #1063352

  • RE: Isn't sysjobs in tempdb a system table because the owner defined while executing sp_help 'sysjobs' returns owner as dbo

    dreamthebest (10/8/2009)

    I think allow update work for SQL Server 2005 as well.

    No it doesn't. The system tables are hidden in SQL 2005 and higher and Allow Update does 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

    October 8, 2009 at 5:29 am

    #1063350

  • RE: shrinked my ss2k5 log file by below option

    Can you answer my questions and explain exactly what you're trying to do and why.

    Please read through this as well - Managing Transaction Logs[/url]

    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, 2009 at 3:22 am

    #1063319

  • RE: shrinked my ss2k5 log file by below option

    guptaajay1985 (10/8/2009)

    Hi Gilla Actually my servers are full of logs and in near future I have to make space on drive....

    That didn't answer anything.

    You're talking about transaction log files (.ldf)?...

    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, 2009 at 3:19 am

    #1063315

  • RE: shrinked my ss2k5 log file by below option

    Silverfox (10/8/2009)

    I take it that you have additional files in your filegroup, because that is exactly what you have done using that option

    He's shrinking the log, so no filegroups. 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

    October 8, 2009 at 3:16 am

    #1063314

  • RE: How I can make look like I expert on SQL Server?

    ItalianOlgi (10/8/2009)

    *It IS possible!*

    Yes, if the company has no DBA staff to do the interview and/or the interviewer was incompetent. Question is, can you do what you claimed to be...

    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, 2009 at 2:52 am

    #1063298

  • RE: shrinked my ss2k5 log file by below option

    Why are you trying to shrink (empty) a log. What's the goal here, what's the reasoning?

    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, 2009 at 2:21 am

    #1063278

  • RE: shrinked my ss2k5 log file

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

    October 8, 2009 at 2:19 am

    #1063276

  • RE: Isn't sysjobs in tempdb a system table because the owner defined while executing sp_help 'sysjobs' returns owner as dbo

    dreamthebest (10/8/2009)

    I was working on enabling and disabling a job. I was directly able to manipulate the values in sysjobs instead of doing it through sp_alterjob. How was that posssible?...

    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, 2009 at 2:18 am

    #1063275

Viewing 15 posts - 36,406 through 36,420 (of 49,552 total)