Forum Replies Created

Viewing 15 posts - 961 through 975 (of 9,244 total)

  • RE: Flipping between SIMPLE and FULL recovery mode

    robinrai3 - Monday, February 13, 2017 7:42 AM

    1) Prior to flipping to SIMPLE mode, if a transaction log back up was taken, ...

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

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

    February 13, 2017 at 8:13 am

    #1928120

  • RE: All disk space used, after deleting rows the table has 6GB "unused"space but I cannot release it or shrink the mdf.

    it's not rocket science :hehe::Whistling:

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

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

    February 10, 2017 at 9:52 am

    #1927839

  • RE: Conditionally execute SHRINKFILE "only" if the file / DB exists

    Express12 - Friday, February 10, 2017 4:38 AM

    I receive this error whenever the DB does NOT exist:

    Msg 911, Level 16, State 1,...

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

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

    February 10, 2017 at 9:49 am

    #1927836

  • RE: Conditionally execute SHRINKFILE "only" if the file / DB exists

    Express12 - Friday, February 10, 2017 8:26 AM

    John and Lowell - thx a million.. Your combined solution worked perfectly:

    DECLARE @SHRINK_DBS NVARCHAR(4000)
    SELECT @SHRINK_DBS...

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

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

    February 10, 2017 at 8:56 am

    #1927812

  • RE: Conditionally execute SHRINKFILE "only" if the file / DB exists

    Express12 - Friday, February 10, 2017 4:38 AM

    The statement I'm using is illegal:

    IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'MySQLServer_DBName')
     ...

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

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

    February 10, 2017 at 6:58 am

    #1927749

  • RE: All disk space used, after deleting rows the table has 6GB "unused"space but I cannot release it or shrink the mdf.

    syen.j - Thursday, February 9, 2017 12:46 PM

    Perry Whittle - Thursday, February 9, 2017 10:03 AM

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

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

    February 10, 2017 at 5:57 am

    #1927737

  • RE: Performance improves after reboot

    RVO - Wednesday, February 8, 2017 10:38 PM

    Example:
    B.Ozar: "Look at the % Usage metric, which monitors how much of the page file...

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

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

    February 10, 2017 at 5:55 am

    #1927735

  • RE: Failover cluster with Mirror server 2008

    check this

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

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

    February 10, 2017 at 5:36 am

    #1927728

  • RE: 2 Select Statements Deadlocking

    GilaMonster - Thursday, February 9, 2017 3:04 PM

    or there's an insert within the transaction that we're not seeing

    This was my train...

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

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

    February 10, 2017 at 5:09 am

    #1927722

  • RE: Massive disk vs. multiple disks?

    dan-572483 - Thursday, February 9, 2017 4:01 PM

    In the "old days" is was common for MDF/NDF files of large databases or MDFs...

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

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

    February 10, 2017 at 5:05 am

    #1927721

  • RE: SSMS 16.3 doesn't run on Windows 10

    i had issues running as a sql server admin user which was not admin on the local pc. I use this

    C:\Windows\System32\runas.exe /noprofile /netonly /user:domain\user "C:\Program Files (x86)\Microsoft SQL...

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

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

    February 10, 2017 at 4:30 am

    #1927717

  • RE: Hardening SQL Server

    i'm not talking about encryption at file system level, i'm talking about securing your NTFS filesystem with appropriate ACLs, inline with best practice.

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

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

    February 10, 2017 at 4:25 am

    #1927716

  • RE: Failover Cluster - Better option

    ok thanks for clarifying

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

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

    February 10, 2017 at 3:56 am

    #1927713

  • RE: 2 Select Statements Deadlocking

    as i recall it you shouldnt be seeing a lock mode of X for a select statement, SQL Server lock modes
    Can you provide more detail of the...

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

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

    February 9, 2017 at 10:52 am

    #1927602

  • RE: NT SERVICE\MSSQLSERVER - WMI provider Error

    kyssling - Thursday, February 9, 2017 4:40 AM

    Thank you for the tip,

    it is possible do it on domain controller ?

    see : You...

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

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

    February 9, 2017 at 10:37 am

    #1927598

Viewing 15 posts - 961 through 975 (of 9,244 total)