Forum Replies Created

Viewing 15 posts - 4,786 through 4,800 (of 9,244 total)

  • RE: Shrink of data file - DBCC SHRINKFILE - taking a long time and not completing - stuck at 99% completion

    As i said, you'll need to be patient and run it for longer than 20 mins 😉

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Installation issue

    tut tut, really. A simple google search reveals this link

    Just in case you can't find it :Whistling: here's the Windows 2012 Eval too.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Configure DB Mirroring on 2 SQL Servers on different SPs

    OK, so when it states same edition and version it seems like it only refers to the major build version not the minor build version

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Shrink of data file - DBCC SHRINKFILE - taking a long time and not completing - stuck at 99% completion

    Marios Philippopoulos (10/13/2012)


    I found out that this data file contains data from a text column.

    Could this be the reason I am having trouble shrinking the file?

    why don't you re run...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: accessing sql server in workgroup using windows authentication

    sej2008 (10/13/2012)


    Thanks for your reply but half the problem is solved

    I am log shipping from pc1 to pc2 as

    an pc1\administrator and having same password on the machine still...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Question Can you connect to a database directly without linking to its server?

    Technically, with contained databases in 2012, you are bypassing connections through the server as you are authenticated directly by the user database.

    Under Oracle an instance is a database, its an...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Migrate 2005 system databases to 2012

    greg.huxley (10/12/2012)


    Hello,

    I have two physical servers, one running SQL Server 2005 and one SQL Server 2012. I have been tasked with migrating the 2005 databases to 2012 using the...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: How full is my datafile?

    kevaburg (10/12/2012)


    How do I find out how much of that datafile is actually filled with data and how much is empty and reserved for use using SQL-based queries

    Run this per...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Shrinking a database - convincing management not to do this

    ericwenger1 (10/12/2012)


    I can't seem to be able to convince the development manager, who I report to(which is abnormal in most settings) that shrinking the database will not improve performance. I've...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Large page support, Lock pages in memory

    oh for sure, I don't doubt that. But, all the same, these things can and do happen

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Large page support, Lock pages in memory

    GilaMonster (10/12/2012)


    It will start, it'll just allocate the largest contiguous block it can and will never grow buffer pool after that. Can also take ages to start because it's trying...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Changing Locations of DataFile

    Paul Clark-418949 (10/12/2012)


    😛

    For most of our VM's it is just 1 aggregate as you are correct NetApp best practice....

    But I wanted the separate RAID Groups for the SQL Volumes (I...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Large page support, Lock pages in memory

    GilaMonster (10/11/2012)


    I don't recommend enabling large pages, it can have some effects at startup and it doesn't usually help much, if at all

    + 1

    When you enable large pages SQL Server...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Changing Locations of DataFile

    Paul Clark-418949 (10/12/2012)


    Perry Whittle (10/11/2012)


    Paul Clark-418949 (10/11/2012)


    C: Drive - Operating System - (Filer01 - Volume 1)

    D: Drive - SQL Installation - (Filer02 - Volume 2)

    F: Drive - Page File -...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Changing Locations of DataFile

    runal_jagtap (10/11/2012)


    Hi Paul,

    thanks for providing the answer 🙂

    Currently we have 5 servers...

    For example..

    1 server have 20 databases almost 20GB each.. now the tempdb files & user datafiles & log files...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 15 posts - 4,786 through 4,800 (of 9,244 total)