Forum Replies Created

Viewing 15 posts - 2,626 through 2,640 (of 2,917 total)

  • RE: Are the posted questions getting worse?

    Chad Crawford - Monday, April 24, 2017 1:20 PM

    Thom A - Monday, April 24, 2017 7:18 AM

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

  • RE: SQL Server 2012 with VMWare

    For the licensing, a good read is:
    http://download.microsoft.com/download/C/3/7/C37F243B-0246-493E-ABFC-41A7FFD6DE38/SQL_Server_2012_Virtualization_Licensing_Guide.pdf

    I misunderstood the licensing model.  What I was stating was licensing for maximum virtualization.  The advantage of using this is...

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

  • RE: SQL Server 2012 with VMWare

    If you were willing to spend some money, I'd do it with 4 separate VM's and then load up a tool like DxEnterprise (similar to Polyserve back in the day)....

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

  • RE: SSRS Report Schedule - getting info from the DB - What do these numbers mean ? -

    mw112009 - Thursday, April 20, 2017 2:36 PM

    The one below works..... Can someone help me extract the [days] and [January]... please

    declare @xml...

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

  • RE: SQL Server detected a logical consistency-based I/O error: incorrect checksum

    GilaMonster - Thursday, April 20, 2017 12:04 PM

    bmg002 - Thursday, April 20, 2017 11:21 AM

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

  • RE: SQL Server detected a logical consistency-based I/O error: incorrect checksum

    Just because the "Events" table has information you don't care about, there was also  8 consistency errors in database 'ACSA'.

    Running that could drop things you DO care about.  It...

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

  • RE: SQL Server detected a logical consistency-based I/O error: incorrect checksum

    Pretty sure that means your DB is corrupt.  I'd run
    DBCC CHECKDB
    and see if it is bad.  If so, I'd run it on your live one...

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

  • RE: SSRS Report Schedule - getting info from the DB - What do these numbers mean ? -

    SQLRNNR - Wednesday, April 19, 2017 4:15 PM

    bmg002 - Wednesday, April 19, 2017 4:13 PM

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

  • RE: Ssrs 2014 migration to 2016.

    If you are not using Enterprise Edition, you should check the ReportServer.dbo.Keys table.  Actually, even if you are using enterprise edition, might not hurt to check that.  Standard will fail...

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

  • RE: SSRS Report Schedule - getting info from the DB - What do these numbers mean ? -

    Here ya go:
    USE [ReportServer];
    GO;

    --View all of the SSRS jobs
    USE [ReportServer]
    SELECT
            [Schedule].[ScheduleID] AS [SQLAgent_Job_Name] ,
            .[Description] AS [Description] ,
            [Catalog].[Name] AS [Report Name]...

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

  • RE: SSRS Report Schedule - getting info from the DB - What do these numbers mean ? -

    If you want to know when the subscription is scheduled to be run, look at the SQL Agent Jobs.  Those are what are triggered to start a subscription.  The names...

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

  • RE: SQL help - Need to know the first date of previous month and last date of previous month...

    mw112009 - Wednesday, April 19, 2017 10:06 AM

    mw112009 - Wednesday, April 19, 2017 10:04 AM

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

  • RE: SQL help - Need to know the first date of previous month and last date of previous month...

    Lynn Pettis - Wednesday, April 19, 2017 9:13 AM

    mw112009 - Wednesday, April 19, 2017 8:09 AM

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

  • RE: query puzzle

    jcelko212 32090 - Tuesday, April 18, 2017 10:36 AM

    David Walker-409102 - Friday, April 14, 2017 3:02 PM

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

  • RE: A little tale and a seven questions about SQL partition

    Grant Fritchey - Tuesday, April 18, 2017 12:08 PM

    bmg002 - Tuesday, April 18, 2017 10:47 AM

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!
    I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.

Viewing 15 posts - 2,626 through 2,640 (of 2,917 total)