Forum Replies Created

Viewing 15 posts - 45,796 through 45,810 (of 49,552 total)

  • RE: Indexes & FillFactor

    Perry Whittle (7/10/2008)

    if you are going to shrink, at least do it after the index rebuild as pages will be moved around. If you specified a fill factor of 50...

    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 10, 2008 at 10:18 am

    #840958

  • RE: Date Function

    Jeff Moden (7/9/2008)

    Nicely done, Gail... It shows that the Convert method takes about 4 times longer than the DateAdd/DateDiff method...

    If I hadn't done a test, you probably would...

    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 10, 2008 at 9:37 am

    #840930

  • RE: Database Stack dump problem any ideas ??

    You may be able to get some info from the text file that accompanied the dmp. There's usually a section which contained the input buffer, but there are many cases...

    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 10, 2008 at 9:21 am

    #840920

  • RE: Database Stack dump problem any ideas ??

    I suggest you contact Microsoft's customer support services. They can help you with stack dumps.

    The mdmp is a mini memory dump. If you have the windows debugger, you can open...

    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 10, 2008 at 9:12 am

    #840911

  • RE: Invalid Class String Error

    Please don't cross post. It just wastes people's time and fragments replies. Many of us read all the forums.

    No replies to this thread please. direct replies to:

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

    July 10, 2008 at 9:10 am

    #840909

  • RE: what is effect of Go in stored procedure

    GO is not a T-SQL command. It's understood by client tools only, and signals the end of a batch.

    You can't put a GO into a stored procedure, because as soon...

    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 10, 2008 at 9:09 am

    #840908

  • RE: moving database to another machine

    BAD-DBA-DAB (7/10/2008)

    Hi,

    Copying mdf & ldf is a bad practice.

    Why?

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

    #840895

  • RE: failed login attemps as sa from multiple ips

    BAD-DBA-DAB (7/10/2008)

    Reference:

    http://support.microsoft.com/kb/319930

    That's for MSDE (SQL 2000). The Original Poster is using SQL Express (SQL 2005)

    ltoso: You can rename the sa account the same way you rename any other account....

    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 10, 2008 at 8:57 am

    #840893

  • RE: moving database to another machine

    JeeKay (7/10/2008)

    When you attach the .MDF file back at the destination, you can manually remove the log file from the list and after attaching put the DB in FUll Mode...

    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 10, 2008 at 8:55 am

    #840891

  • RE: failed login attemps as sa from multiple ips

    Not from within SQL.

    Are you running with mixed authentication mode?

    If you are, you can in SQL 2005 disable or rename the sa account. That gives you a little...

    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 10, 2008 at 5:03 am

    #840723

  • RE: is startup time held in any view?

    It's not stored anywhere alone that I know of.

    I usually query sys.dm_exec_sessions and get the login time of session_id 1. It's the Resource Monitor and it starts when SQL starts...

    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 10, 2008 at 4:28 am

    #840717

  • RE: DBCC commands

    It checks the integrity of your database to ensure you have no corruption present.

    CheckDB includes all the checks done by checkAlloc, so it's not necessary to run 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 10, 2008 at 4:16 am

    #840713

  • RE: Automation migration from access to SQL server

    Please don't cross post. It just fragments replies and wastes people's time. Many of us read all the forums

    No replies to this thread please. Direct replies to:

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

    July 10, 2008 at 4:14 am

    #840711

  • RE: Create a package to migrate daily from mc access to SQL server

    Please don't cross post. It just fragments replies and wastes people's time. Many of us read all the forums

    No replies to this thread please. Direct replies to:

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

    July 10, 2008 at 4:14 am

    #840710

  • RE: dynamically create a database everymonth with db name as db_month_year

    Please don't cross post. It just fragments replies and wastes people's time. Many of us read all the forums

    No replies to this thread please. Direct replies to:

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

    July 10, 2008 at 4:13 am

    #840709

Viewing 15 posts - 45,796 through 45,810 (of 49,552 total)