Forum Replies Created

Viewing 15 posts - 42,286 through 42,300 (of 49,552 total)

  • RE: Profiler shut down database?????

    Grant Fritchey (12/18/2008)

    From where I sit, there's still a bit more to learn here.

    I think this is one of the areas of the internals where the more info 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

    December 18, 2008 at 6:34 am

    #914471

  • RE: Spot the incorrect syntax please..!

    Ninja's_RGR'us (12/18/2008)

    Well not really, it would almost be correct in Access which is probably where that all started.

    I haven't worked in Access for so long I can't remember anything about...

    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

    December 18, 2008 at 5:51 am

    #914444

  • RE: Data encryption

    thatok (12/18/2008)

    Decryption By Password = N'HRTestPassword'

    I hope you're going to make that password a little more complex in production.

    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

    December 18, 2008 at 5:51 am

    #914443

  • RE: Spot the incorrect syntax please..!

    Your syntax is completely incorrect.

    Update TargetTable

    SET TargetColumn = SourceColumn

    FROM TargetTable INNER JOIN ....

    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

    December 18, 2008 at 5:28 am

    #914425

  • RE: SQL SERVER PERFORMANCE

    What do you mean by "performance is slow"

    Is this normal, or is the server unusually slow?

    Have you made any changes recently?

    Are there more users than normal?

    Is there excessive blocking?

    Are 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

    December 18, 2008 at 5:27 am

    #914422

  • RE: DBCC INPUTBUFFER(@@SPID)

    If you are using SQL 2005, rather use the sys.dm_exec_sql_text than inputbuffer.

    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

    December 18, 2008 at 5:25 am

    #914420

  • RE: Data encryption

    Look up the EncryptByKey and DecryptByKey functions in Books Online.

    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

    December 18, 2008 at 5:21 am

    #914419

  • RE: Clustered and Non-clustered Index

    Username is typically a very bad choice for a clustered index. It's wide, it's nowhere near unique and it's not ever increasing. LOG_DATE_TIME may be a good candidate. Still need...

    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

    December 18, 2008 at 5:16 am

    #914416

  • RE: The BackUP of the file Group of file is not permitted

    Did you read the links that Pradeep provided?

    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

    December 18, 2008 at 5:14 am

    #914415

  • RE: Replace trigger due to deadlock - but with what?

    DBCC TRACEON (1222,-1)

    The -1 turns it on globally. Without that the traceflag is only enabled for a single session, the one that turned it on. Since deadlocks are detected by...

    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

    December 18, 2008 at 5:13 am

    #914412

  • RE: Urgent: Shrinking logfile(s) when the db is in "SIMPLE" recovery model...

    Kiran (12/17/2008)

    1. when will the log shrink for simple recovery model?

    Never. The log is truncated on a checkpoint, meaning the inactive log records are discarded and the space made...

    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

    December 18, 2008 at 12:15 am

    #914319

  • RE: Are the posted questions getting worse?

    I haven't seen this for a while.

    is the set "SET CPU_ UTILISATION LOW" is the query to set the cpu utilisation low..

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

    December 18, 2008 at 12:12 am

    #914318

  • RE: System Performance - High CPU utilization--> SQLSRV.exe

    karthikaug18 (12/17/2008)

    is the set "SET CPU_ UTILISATION LOW" is the query to set the cpu utilisation low..

    Um, no. SQL will take what CPU it needs.

    when we are taking 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

    December 18, 2008 at 12:05 am

    #914316

  • RE: Problem Restoring 2000 DB to SQl Server 2005

    kwitzell (12/17/2008)

    Gail,

    I ran the script and received no output (0 rows).

    Ken

    Is that in the AM20 database?

    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

    December 18, 2008 at 12:04 am

    #914315

  • RE: Two questions about the SQLServerCentral forums

    You gain points by posting (1 per post) or by answering the Question Of the Day correctly. Usually between 1 and 3 points

    Forum Newbie - 0

    Grasshopper - 10

    SSC Rookie -...

    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

    December 17, 2008 at 1:25 pm

    #914131

Viewing 15 posts - 42,286 through 42,300 (of 49,552 total)