Forum Replies Created

Viewing 15 posts - 91 through 105 (of 147 total)

  • RE: Performance issue for a query with order by clause in SQL 2005 SP2

    As for the reason why it runs quicker the second time through it's because the execution plan has been cached.

  • RE: Best Way to Calculate Age

    Jumping on the bandwagon here: only the second statement returned the correct value for my birthdate. Gimme my point! ARGH!

    😛

  • RE: Location of System Databases

    Oh how I wish I worked in a perfect world! If so, I'd have my logs on a dedicated RAID 1, my tempdb on another and my data on...

  • RE: Delete of Login

    I suggest removing rights to any databases that this login may have first prior to deleting the login. As suggested this can all be done in SSMS. Right-click...

  • RE: Who is responsible for databases: DBA or Admins

    Like Lowry, in our environment (both SQL 2000 and 2005) I am responsible as the DBA to make sure all databases are being backed up correctly and am responsible for...

  • RE: Growing tempdb

    What do you consider "abnormal"? What is your tempdb spec'd at currently? Are we discussing SQL 2000 or 2005? Optimizing tempdb in 2005 is quite different than...

  • RE: Trying to move the entire SQL install to another drive

    No matter what you specify for the location of program files and for data files, SQL will still place files in C:\Program Files\Microsoft SQL Server\80 (or 90 if this is...

  • RE: Moving databases to different locations (paths)

    Detach/Attach v. Backup/Restore is really a matter of personal preference. So long as you copy/paste the data/log files in the Detach/Attach instead cut/paste you can recover by re-attaching the...

  • RE: Good book on SQL 2005

    I completely forgot about that! The other contributing authors are no slouches either.

  • RE: FTP script from one SQL server to SQL another

    Henry, I believe your FTP commands would be in the .txt file referenced here in the script:

    [font="System"]-- FTP for the file list

    SELECT @SQL = 'FTP -n -v -s:C:\FTPCmdFile.txt' [/font]

  • RE: Limiting views on shared servers

    Definitely agree Brandie, just wanted to explain for any lurkers out there so that they just don't go around giving out dbo under the belief that they need to in...

  • RE: Limiting views on shared servers

    Brandie, I took this as the individual has SSMS and should be able to "see" only a specific database(s) in the Databases node of the Object Explorer and not "see"...

  • RE: Limiting views on shared servers

    Once you revoke the View Any Database, if you then execute sp_changedbowner for database X for a given login that login should see that database, as well as master and...

  • RE: Trace Cannot be Stopped

    I really would not disable the default trace if I were you. Think of it as SQL's "black box". The load it places on the server should be...

  • RE: sql DB for SCOM 2007

    The documentation should tell you what the initial size will be; very small initially. The size of the database really depends upon how many servers you plan on monitoring,...

Viewing 15 posts - 91 through 105 (of 147 total)