Forum Replies Created

Viewing 15 posts - 6,046 through 6,060 (of 49,552 total)

  • RE: How soon will relational databases become obsolete, if at all?

    Sure.

    Hahahhahahahahahaha!

    Hehehe..

    *snigger*

    How you store the data and how you process it should be determined by the type of the data, the type of analysis and the type of results.

    Is the...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 5, 2015 at 7:02 am

    #1795578

  • RE: window server 2008r2 and Always on

    Dan121 (5/5/2015)

    Thanks for your reply. It's not Production. Just test servers. don't have plan to use in Prod.

    Cool, so which of the features are you looking to test? Failover clustering...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 5, 2015 at 6:49 am

    #1795568

  • RE: window server 2008r2 and Always on

    First thing.

    AlwaysOn is a marketing term, not a feature. The features are AlwaysOn:Availability Groups and AlwaysOn: Failover Clustering

    Second thing, Developer Edition is licensed only for non-production usage. While it's...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 5, 2015 at 5:45 am

    #1795555

  • RE: Getting Cpu Alert like warnings 99 % and 92 % in a sqlserver instance [no blocking no deadlocks and its occuring nite time when user load is less ]

    Is SQL the thing using the cpu?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 5, 2015 at 5:29 am

    #1795548

  • RE: trigger on Multiple columns

    kd11 (5/4/2015)

    Let me re-word that, I want to fire a trigger when column2, column3, column5 and column9 are updated/insert (not the other six columns) so do I need to use...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 5, 2015 at 2:47 am

    #1795532

  • RE: Stored procedure errors

    karodhill (5/4/2015)

    Im trying to create a procedure that if either one of the parameters are null then the other one will apply

    Please go and read the blog post I...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 5, 2015 at 2:41 am

    #1795531

  • RE: Stored procedure errors

    Ignoring the syntax problems (which is because you're missing a comma between the two parameters), this is generally not a good idea and will probably lead to performance problems in...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 4, 2015 at 2:52 pm

    #1795475

  • RE: can second save transaction t2 be rolled back

    A name specified on a rollback MUST match the name given on the outermost begin tran. You have no name on the begin tran, hence naming the rollback throws an...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 4, 2015 at 10:02 am

    #1795407

  • RE: I'm altering a column type of a table.

    Don't use the GUI.

    The T-SQL query window in SSMS doesn't have a timeout set (the GUI does), so a written query will run as long as necessary. It may be...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 4, 2015 at 10:01 am

    #1795406

  • RE: Where can we download "SQL Server 2012 Enterprise edition" setup ?

    Chat with whoever you purchased it from, they should be able to provide the 2012 media.

    That link is a service pack.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 4, 2015 at 5:00 am

    #1795317

  • RE: Where can we download "SQL Server 2012 Enterprise edition" setup ?

    MSDN downloads or the Volume Licencing page, depending on how your version is licensed.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 4, 2015 at 4:33 am

    #1795313

  • RE: Can we disable any column on profiler

    You can not include it in a specific trace definition, but that's all. You can't stop a trace from ever seeing the column.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 4, 2015 at 4:29 am

    #1795312

  • RE: Round(9.x,0) Error where x >=5 and x <= 9)

    Weird. I suspect because Round returns numeric of the same precision and scale as its input, and 10 won't fit into a numeric (2,1)

    As a workaround:

    select ROUND(CAST(9.5 AS Numeric(3,1)), 0)...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 4, 2015 at 2:57 am

    #1795307

  • RE: DBCC Shrinkdatabase run every week?

    Charles Kincaid (4/30/2015)

    SQL server is a bit vulnerable during a shrink operation. ... If something goes bad during the shrink then a restore is likely to be needed.

    Not really. No...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 4, 2015 at 2:45 am

    #1795306

  • RE: How can I rewrite this in better performance

    All of those functions are likely to cause performance problems if they're called within another select. Data-accessing scalar functions should be avoided whereever possible and especially avoided within another query.

    Try...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 4, 2015 at 2:39 am

    #1795305

Viewing 15 posts - 6,046 through 6,060 (of 49,552 total)