Forum Replies Created

Viewing 15 posts - 316 through 330 (of 2,436 total)

  • RE: Slow Backups after Migrating to 2005

    I'd look at VM-Ware and the SAN. VM-Ware should be relatively easy to check. However the SAN, dependent on vendor, architecture and overall usage could be a bit more involved.

    We...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Split backup using LightSpeed

    Just to add to Ed's comments - we did benchmarking of all of the encryption options available and found no noticable difference in execution time, backup size or CPU utilization....

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Portable Data Centers

    ... August 14th, 1997 ... 2:14 am EST ... SkyNet became self-aware ...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Forcing mirroring to use specific connection(s)

    NIC Teaming should work. I have used it reliably for a number of years although not in this specific situation. We used to have two teams (4 NICs). One team...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Portable Data Centers

    Sliding a unit in and out of a building will only work if your datacenter is on the 1st or 2nd floor. The places where the most 'green' is needed...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Split backup using LightSpeed

    We are currently using LiteSpeed as well - we are getting about 70% reduction in file size and using 128 bit RC4 encryption. A backup of a database consisting of...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Enumerate SQL Agent job name from job itself

    Check out BOL and search for "Using Tokens in Job Steps" - maybe this will help. This is a feature that has been around since v7.0. However the syntax changed...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: cluster issue

    If your cluster configuration is correct, more specifically the dependencies for each instance and the failover order I would next look at your storage subsystem. Examining the System and Application...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Portable Data Centers

    Security anyone ? Think of the ramifications for even the most basic security needs - access alone for starters. Imagine what the SOX and HIPPA auditors would think and say...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: How to find last accessed Date of a database ??? on sql server 2000

    There is one sitiation that this SQL will miss. Executing SP in database A to access database B via 3 part naming - I know because we have lots of...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: User without mapping

    I think you want orphaned logins. I've attached a sscript for 2005 for this. It exevn generates a script to drop them !

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Unused Databases, Last accessed DB

    A somewhat non-intrusive method is to set the databases to 'AUTO CLOSE'.

    Then all you have to do is scan the errorlog to see which ones are used !

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Are We Wasting Too Much Time Social Networking?

    Honor Above All ...

    Kudos to life and you Jason !

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Are We Wasting Too Much Time Social Networking?

    I have not used LinkedIn for almost 2 years - I stopped after I started getting 10+ emails a day - that alone took too much of my time. So...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: function to identify the special characters in a table

    If it does not need to be a function per se, then why reinvent the wheel ...

    sp_validname

    http://msdn.microsoft.com/en-us/library/ms189525.aspx

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

Viewing 15 posts - 316 through 330 (of 2,436 total)