Forum Replies Created

Viewing 15 posts - 301 through 315 (of 2,436 total)

  • RE: Swings in Page Life Expectancy

    Is this SQL Server 'Standard' or SQL Server 'Enterprise' edition ???

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

  • RE: Online T-SQL Scripts and Copyright

    Brad, not to nitpick but your link is from MSDN:

    http://msdn.microsoft.com/en-us/cc300389.aspx.

    This represents a far wider scope of products, not limited to SQL Server alone. Below is about the only link...

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

  • RE: Online T-SQL Scripts and Copyright

    Good article ... one for the lawyers and intellectual property folks for sure.

    However, just think about how ludicrous it can be.

    How many DBAs have freely copied and implemented the scripts...

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

  • RE: Lassoing a Cloud

    Cloud, internal network ...

    Cloud, scalability ...

    Cloud, application independence ...

    Cloud, thin client ...

    Cloud, external network ...

    hmmm ...

    It sounds like the same 'terminology re-inventions' plague that have been wrought upon us...

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

  • RE: Database design and FK relationships

    For that matter look at the SQL Server system databases.

    Not so much anymore in 2005 and moving forward.

    Check out master in a SQL 2000 or earlier version - it'll really...

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

  • RE: memory question

    lest we not forget:

    DBCC MEMORYSTATUS

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

  • RE: T-SQL Operators

    '-' is also a part of 'wildcard' characters ...

    http://msdn.microsoft.com/en-us/library/ms179884(SQL.90).aspx

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

  • RE: Best practices Password Change - SQL Failover cluster (3 or 4 node cluster)

    Welcome to my world ... we have enterprise level products that do software patching and password changes for service accounts and the like. They work sell for OS based things...

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

  • RE: Error backing up specific SQL 2000 database

    Let's start from square one here ...

    Try the following command and post the results.

    BACKUP DATABASE [Navision Live] TO DISK='D:\test_navision.bak'

    GO

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

  • RE: The Disappearing DBA

    Very well written and oh so true. All too often a company only knows they have a 'good DBA' when the rare occasion arises that he or she was the...

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

  • RE: SQL Server 2005 xp_logininfo error message

    Scott - this makes sense only when one is checking accounts that are local server only, and only if both nodes local accounts are not the same. Since it is...

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

  • RE: Re-size TempDB files

    The -m parameter is definitely needed to prevent any other dbo or administrator type access - this is especially true during outages on production SQL servers.

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

  • RE: Split backup using LightSpeed

    Good information to know about 2008 Ed - we are bypassing it for now - maybe by 2010 MS will get it fixed ...

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

  • RE: Database mail with @query issue!

    Can you post the entire send mail command with the @query please ...

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

  • RE: SQL Server 2005 xp_logininfo error message

    I would have youe AD folks compare the two accounts - my guess is that 0x5 is an access denied message.

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

Viewing 15 posts - 301 through 315 (of 2,436 total)