Forum Replies Created

Viewing 15 posts - 22,141 through 22,155 (of 49,552 total)

  • RE: Shrinking The log file from 250 GB to 10 GB

    Doesn't matter if you shrink in chunks or once off (except in the time it takes the shrink to run). If you shrink below the size required, the log will...

    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 17, 2011 at 5:24 am

    #1409101

  • RE: Sp failed

    The error's pretty clear. You're trying to throw error 50001, but no such error message exists.

    You either need to add that message to sys.messages, then you can call Raiserror with...

    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 17, 2011 at 5:21 am

    #1409099

  • RE: Index using Include for Join

    sami.sqldba (11/17/2011)

    i just want to ask how to create index over the query which have joins do i need to create sepreate index for each table or there is 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

    November 17, 2011 at 5:16 am

    #1409096

  • RE: creating an index on multiple table

    In that case my indexing suggestion stands and should be sufficient.

    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 17, 2011 at 4:04 am

    #1409069

  • RE: Compressed Backup Issue, anyone?

    stevescanlan (11/16/2011)

    I hem and haw, try a bunch of stuff, CONTINUE_AFTER_ERROR, yada, yada. no go. I do a test restore on 7 databases on different server, all fail miserably.

    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 17, 2011 at 3:31 am

    #1409058

  • RE: creating an index on multiple table

    An index consists of one or more columns from a single table only.

    For that query I suggest an index on EmployeePersonalDetail (EmpName. EmpID)

    Is EmpID the primary key of 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 17, 2011 at 3:28 am

    #1409057

  • RE: Incorrect syntax near 'GO'

    Take the GO out. It's not a T-SQL statement, it's a management studio batch breaker.

    p.s. Stop doing this to you logs. If you want the log in auto-truncate, set 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 17, 2011 at 1:28 am

    #1409009

  • RE: what causes a database turned into a Recovery State

    pavargasq (11/16/2011)

    1.I suppose when you stop the instance (stop the engine and the agent)even when are running processes could cause the recovery. doesnt it ? is there any other reason?

    Running...

    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 17, 2011 at 1:26 am

    #1409007

  • RE: Application gets installed but creates only one table in SQL - Please help..!

    A fresh installation of SQL will very do exactly the same thing, this sounds like a bad code problem, not a SQL settings problem. Have you spoken with the vendor?

    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 17, 2011 at 1:24 am

    #1409005

  • RE: DBCC Shrinkfile

    derekr 43208 (11/16/2011)

    GilaMonster (11/16/2011)

    derekr 43208 (11/16/2011)

    For instance: I need it to check the size, check the free space, if the free space > a certain % - it needs 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 17, 2011 at 1:21 am

    #1409003

  • RE: Table space usage 2

    Edit: Whatever...

    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 16, 2011 at 2:59 pm

    #1408909

  • RE: Catch Query Timeout attention event. Is it possible?

    Again, SQL doesn't consider this an error, so there's nothing to catch here. The application is the one that knows it's a timeout (as opposed to say a developer clicking...

    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 16, 2011 at 1:46 pm

    #1408860

  • RE: index record count difference

    SELECT COUNT(*) FROM SomeTable WITH (INDEX = idx_Filtered)

    Msg 8622, Level 16, State 1, Line 1

    Query processor could not produce a query plan because of the hints defined in this query....

    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 16, 2011 at 12:14 pm

    #1408798

  • RE: Schedule profiler to run a user template...

    Script out the trace (option on the File menu of Profiler), set the file location and set the stop time for 9 hours after the current time (dateadd(hh, 9, getdate())...

    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 16, 2011 at 11:16 am

    #1408770

  • RE: Is this correct use of WITH (NOLOCK, READUNCOMMITTED) in delete?

    Michael Valentine Jones (11/16/2011)

    My preference is to set the database to read_committed_snapshot and never have to worry about any of this again.

    use master;

    alter database [MyDB] set allow_snapshot_isolation on;

    alter database [MyDB]...

    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 16, 2011 at 11:09 am

    #1408769

Viewing 15 posts - 22,141 through 22,155 (of 49,552 total)