Forum Replies Created

Viewing 15 posts - 241 through 255 (of 526 total)

  • RE: Max Server memory

    We tried.

    Several of our apps are heavily into the COM/DCOM world. We're stuck. Hopefully the vendors will change that with the advent of 2008, but we have to wait.

  • RE: Max Server memory

    .........but if you are getting memory pressure from other applications running on your 32 bit SQL server and you already have 4gb of memory ..........

    That is why I'm looking at...

  • RE: Max Server memory

    Run

    exec SP_configure 'show advanced options' ,1;

    reconfigure with override;

    and you get the following back

    name ...

  • RE: SQL Server Management Studio on XP clients

    The upgrades report success until GDR1 & GDR2. SQL Server 2005 Service Pack 2 (SP2) Re-release and post fixes explained

    So far it is on 2 machines that had the...

  • RE: Leaky Data

    While my company uses a commercial product for encrypting our laptops, we do it. I found an open source product, Truecrypt after we started using the commercial product. It...

  • RE: The DBA Whoops

    I just did a whoops the other day. We have a DB that we load data monthly and then have a "As_Of_" tables to keep the historical data.

    I forgot...

  • RE: It''s All About Timing

    I can't stand DST -- Just a host of problems for people and computers.

    The sync problems have gone away a lot since the days of NT4. We had to rebuild...

  • RE: Are Your Database Backups Current and Available?

    But as I understand it, in SQL2K5 they are really restricting xp_cmdshell. Or has that changed?

  • RE: Backup failure using Maintenance Plan

    CREATE PROCEDURE sp_KillUsers @dbname varchar(50) as

    SET NOCOUNT ON

    DECLARE @strSQL varchar(255)

    PRINT 'Killing Users'

    PRINT '-----------------'

    CREATE table #tmpUsers(

    spid int,

    eid int,

    status varchar(30),

    loginname varchar(50),

    hostname varchar(50),

    blk int,

    dbname varchar(50),

    cmd...

  • RE: hostname doesn''''t match MAC Address (net_address)

    That's the answer. That was the machine that originally linked in the the tables to the Access DB.

    Thnaks

  • RE: The Debacle Continues

    I didn't read all the replies, but I've experienced the same thing with Sears.

    I called them up after returning a manual that I ordered from Sears.com. I didn't even...

  • RE: Christmas Poll

    Following on Chris Hedgate's post, you can also find the same video here.

    This is a house in Mason, OH (Suburb of Cincy). The soundtrack plays over the radio so...

  • RE: 90 Minute TiVo

    I lost the spreadsheet I had built which listed the the price of the movie (on DVD) vs the cost of the movie's soundtrack. But I remember the results. Take...

  • RE: 90 Minute TiVo

    Whichever congressrat came up with this idea needs to be told that his village is missing an idiot.

  • RE: New Poll

    From all that has been said most fail to apply the Six-P Rule: Proper Planning Prevents P**s Poor Performance. Then there is the mission creep problem.

    What needs to happen...

Viewing 15 posts - 241 through 255 (of 526 total)