Forum Replies Created

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

  • RE: iPad? Good for monitoring SQL servers?

    Thanks Bob & Steve. I'll give a try to these apps.

  • RE: When is Update Stats Required?

    Jai-SQL DBA (5/28/2012)


    Hi All,

    I just wanted to know how to check and Apply Update Stats on a DB.

    I know how to check the last modified date for stats .....and My...

  • RE: how to copy sql2005 msdb ssis packages to sql2008 msdb

    John Mitchell-245523 (5/28/2012)


    Yes, open, convert, save.

    There may well be a quicker method, but I'm not aware of it. The internet is a great resource for stuff like this, if...

  • RE: iPad? Good for monitoring SQL servers?

    Could anyone give the name of apps that we can use to monitor/RDP our SQL Servers from iPhone/iPad ?

  • RE: Setting alert when CPU usage 100% for continous 1 minute

    S_Kumar_S (5/25/2012)


    Honestly I already had tried this query but the DMV doesn't seem to give satisfactory result .

    e.g. I ran a query on test server which made the CPU 100%...

  • RE: Valid Backup

    Lynn Pettis (5/23/2012)


    ken.willekens (5/23/2012)


    I have to agree that the safest way to verify a backup is by actually restoring it somewhere. If this is not possible or you are looking...

  • RE: New features in SQL 2012, the contained database

    David in .AU (5/22/2012)


    Just wondering how this works if I need to join tables between different databases, or is that one of those cases where it is listed as unsupported?

    thanks!

    yes,...

  • RE: measure PAE using or not?

    ananda.murugesan (5/22/2012)


    OS - Win 2003 Enterprise Edition

    Database - SQL 2008 Enterprise Edition

    Memory - 4GB

    please tell me, how to measure /PAE really using or not after configured as below boot.ini...

  • RE: New features in SQL 2012, the contained database

    Nice article Daniel. It is always good to know about new features. It would have been nice to put some more details in the topic like how contained databases can...

  • RE: AWE Changed - Maintenance Plan not working

    thunderousity (5/18/2012)


    "Address Windowing Extensions (AWE) requires the 'lock pages in memory' privilege which is not currently present in the access token of the process."

    Check Database integrity on Local server connection

    Databases:...

  • RE: Memory Usage is high

    Saggy (5/18/2012)


    SQL Server 2008 R2 express edition

    OS: Windows SBS Server 2011 and 64 bit edition.

    thnx..........

    Okay, as you said you have 64 bit OS I assume you have installed 64 bit...

  • RE: smart work with select

    Ian Scarlett (5/18/2012)


    If this is just a case of wanting to reduce the amount of typing, you can get SSMS to do most of the work for you...

    If you expand...

  • RE: Memory Usage is high

    Saggy (5/18/2012)


    Hi..... Guys,

    Is sql server using 25% RAM of total memory available?

    for eg: if 10 GB of total RAm is der then SQL Server going to use 2.5 GB...

  • RE: SQL New Login can't see domain users

    seb 30496 (5/18/2012)


    Hi

    I'm trying to set up Windows-based SQL logins on an existing SQL 2008 installation. The installation was created by cloning a previous virtual machine, and where and...

  • RE: Why table is not created?

    halifaxdal (5/17/2012)


    I need to use the temp table for further data processing so defining it as global is the only way.

    Lynn has explained you clearly why the temp table is...

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