Forum Replies Created

Viewing 15 posts - 6,181 through 6,195 (of 7,505 total)

  • RE: Restore v Detach/Attach

    you can query inter-collation !

    but you have to convert to the same collation in the query :

     

    http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=4&messageid=95954

    July 12, 2006 at 11:55 pm

    #648870

  • RE: dbcc showcontig

    can you run sp_updatestats and dbcc updateusage , just to make sure the statistics are OK ?

    July 11, 2006 at 11:44 pm

    #648628

  • RE: How to enable connection pooling for ODBC source?

    afaik this is set with the connection !

    Connection Pooling in .NET Applications

    conn.ConnectionString = "...;Min Pool Size=50";

    perfmon can show you the counters.

    you may want to...

    July 11, 2006 at 1:13 am

    #648371

  • RE: SQL Server Copy not working

    just my 2ct

    - I use this step in a job:

      execute @ReturnCode = msdb.dbo.sp_add_jobstep @job_id = @JobID , @step_id = 9, @cmdexec_success_code = 0, @on_success_action = 1, @on_success_step_id = 0,...

    July 11, 2006 at 1:07 am

    #648369

  • RE: dbcc showcontig

    - how many files are in the filegroup ?

    - how many columns compose your clustring index key ?

    July 10, 2006 at 11:37 pm

    #648360

  • RE: No enough Storage?

    can you provide some config info ?

        SQLServer version and sp

        Server OS and sp

        Memory

    If you can reproduce this or know the interval this recurs, start profiler to capture...

    July 10, 2006 at 12:53 am

    #648164

  • RE: Select on table not working

    just to add to David's reply :

    When you are logged in as member of the sysadmin fixed server role, internaly the user is switched to "sa" which defaults to schema...

    July 10, 2006 at 12:50 am

    #648162

  • RE: dbcc showcontig

    from BOL :

  • Understanding Logical Scan Fragmentation and Extent Scan Fragmentation values.

    Logical Scan Fragmentation and, to a lesser extent, Extent Scan Fragmentation values give the best indication of a...

July 10, 2006 at 12:46 am

#648161

  • RE: SQL Memory ! What is the best setting ?

    "Buffer Cache Hit ratio is around 65% on average."

    That's still surprising on a 1.8 Terrabytes system with only 1,7Gb ram for sqlserver.

    Maybe you can optimize by investigation partitioned tables...

    July 10, 2006 at 12:36 am

    #648160

  • RE: SQL Memory ! What is the best setting ?

    every litle bit of ram helps in this case !

    Keep in mind windows itself needs some memory, I guess the 500mb you're leaving will do if it's a dedicated...

    July 7, 2006 at 7:00 am

    #647958

  • RE: SQL Memory ! What is the best setting ?

    In the servers Boot.ini file add :

    [operating systems]

    multi(0)disk(0)rdisk(0)partition(1)\WINNT="whatever windowssystem " /fastdetect /3GB

    You will have to reboot the server to activate it

    July 7, 2006 at 6:32 am

    #647947

  • RE: SQL Memory ! What is the best setting ?

    By default windows only allows an application to use up to 1,7Gb ram.

    Adding the /3Gb windows startup parameter, for systems up to 4Gb ram, windows will allow an application to...

    July 7, 2006 at 5:09 am

    #647924

  • RE: SQL Memory ! What is the best setting ?

    Seems to me that your server is on the small tiny side

    Adding /3Gb to your startup parameters of Windows may have your sqlserver...

    July 7, 2006 at 4:47 am

    #647920

  • RE: Function for Time Conversions

    What I mean is that if you want to e.g. select data with a where-clause which has your UTC time used as a predicate, it's best to convert your search-criteria...

    July 6, 2006 at 11:43 pm

    #647881

  • RE: Function for Time Conversions

    keep in mind that if you access an indexed column to which you apply a function, will make the predicate non-sargeble. Meaning the index will not be used and the function...

    July 6, 2006 at 1:33 pm

    #647824

    • Viewing 15 posts - 6,181 through 6,195 (of 7,505 total)