Forum Replies Created

Viewing 15 posts - 361 through 375 (of 463 total)

  • RE: Best Practice: Login to use for Backup Maintenance Plan

    The specific id doesn't matter in as much as it either has rights to do the backups or it doesn't. The backups themselves run under the main SQL service...

  • RE: Can you recover data from transaction log?

    No, you are a little confused. Greg meant :

    1) take the last full backup and restore it as a new database with norecovery

    2) apply all the log backups from...

  • RE: Unicode Question

    Try going to control panel -> regional and language options -> languages tab and checking the options in supplemental language support (you might need the OS disks).

  • RE: Datatype for US Money

    Jeff Moden (2/15/2008)Heh... it's deja-vue all over again... and a bit ironic... that's exactly what I used to recommend... (Matt, PLEASE take no offense... I'm NOT picking on you......

  • RE: Should the DBA be a Local Administrator?

    Thanks for that information; we have a mix of 2000 and 2003 servers and this means I can lock some of them down tightly and use the local policies to...

  • RE: Datatype for US Money

    I would say use whatever datatype is appropriate - if the potential range of stored values falls within smallmoney then go for it. Decimal is useful in situations where...

  • RE: Should the DBA be a Local Administrator?

    In Windows 2003, it's not. If this is what you are running, your network co-workers need to go look up the Remote Desktop Users local group. Now, if they have...

  • RE: Using two Servers t

    Before you say it's not feasible to use mirroring, you may want to test it. I think Microsoft recommend 10 as a max, but if the load is light...

  • RE: sys.dm_exec_cached_plans

    1.) I thought that the info in this DMV's got reset when SQL server services are started BUT books online describes the USECOUNTS column as "the number of times...

  • RE: Is there a way to overcome the limitation of 8k per record in a table?

    Varchar(max) works fine ... from BOL for replicate:

    If character_expression is not of type varchar(max) or nvarchar(max), REPLICATE truncates the return value at 8,000 bytes. To return values greater than 8,000...

  • RE: Performance benifits of MERGE ?

    Thanks Adam, just what I wanted.

  • RE: Developers as sysadmins / no DBA / a trend?

    My point about SAS70 is that your customers want to know their data is safe with you and that you aren't adding people to roles like sysadmin without great care....

  • RE: Developers as sysadmins / no DBA / a trend?

    In my experience, developers will create something that works (for a while) - but they aren't aware of best practises, optimisation techniques, different techniques of accomplishing something and the pros/cons...

  • RE: SQL 2008 sneak peek exam info

    Thanks for posting this Brandie, I didn't check my email for the reminder until after it finished.

    Is the information you provided pretty much everything, or is it still worth listening...

  • RE: The switch to Oracle

    Thanks for the information, plenty to investigate now.

Viewing 15 posts - 361 through 375 (of 463 total)