Forum Replies Created

Viewing 15 posts - 3,706 through 3,720 (of 8,761 total)

  • RE: Are the posted questions getting worse?

    Grumpy DBA (4/18/2016)


    Ed Wagner (4/18/2016)


    Eirikur Eiriksson (4/18/2016)


    My twin brother is a meteorologist and he says the same, up to 72 hours is normally fine and then you can start to...

  • RE: Performance tuning a query

    Few quick thoughts, why use temporary tables? At the first glance they only seem to add IO and break up the flow.

    The function eufn_e5_eSM_SE_GetCurrentItemLocation is a scalar function, what is...

  • RE: Visual Studio 2015 and SQL Server 2014

    Phil Parkin (4/18/2016)


    Eirikur Eiriksson (4/18/2016)


    Phil Parkin (4/18/2016)


    Eirikur Eiriksson (4/18/2016)


    No insight info but have been playing around with 2014 as target server and so far no problem. Note that I've not...

  • RE: Visual Studio 2015 and SQL Server 2014

    Phil Parkin (4/18/2016)


    Eirikur Eiriksson (4/18/2016)


    No insight info but have been playing around with 2014 as target server and so far no problem. Note that I've not used any version specific...

  • RE: Are the posted questions getting worse?

    jasona.work (4/18/2016)


    Steve Jones - SSC Editor (4/18/2016)


    No more snow here, at least not forecast. It's cloudy, and foggy. Never know. I think weather forecasters are flipping coins half the time.

    Couple...

  • RE: Visual Studio 2015 and SQL Server 2014

    No insight info but have been playing around with 2014 as target server and so far no problem. Note that I've not used any version specific libraries in script components...

  • RE: Function for Shuffling data from Primary Key

    shamshad.ali (4/18/2016)


    Ids could be deleted so they won't match from random generated numbers, I need something like existing Ids only to be shuffled.

    Tried following and it only uses the random...

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (4/18/2016)


    BWFC (4/15/2016)


    Steve Jones - SSC Editor (4/15/2016)


    Eirikur Eiriksson (4/15/2016)


    Steve Jones - SSC Editor (4/15/2016)


    About to head off to SQL Saturday Phoenix. Anyone else going?

    Wouldn't mind...

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (4/18/2016)


    Eirikur Eiriksson (4/15/2016)


    Brandie Tarvin (4/15/2016)


    Eirikur Eiriksson (4/15/2016)


    jeff.mason (4/15/2016)


    Eirikur Eiriksson (4/15/2016)


    Further on Luis's good advice, change

    USE MyWorkplace;

    GO

    to

    USE master;

    GO

    otherwise you'll get the error

    Msg 3702, Level 16, State 3, Line 6

    Cannot...

  • RE: DBCC LOGINFO changes in 2012+

    Quick suggestion, add default values to the new columns

    😎

    ,NEW_COL INT NOT NULL DEFAULT(0)

  • RE: Function for Shuffling data from Primary Key

    Quick suggestion

    😎

    USE Test;

    GO

    SET NOCOUNT ON;

    GO

    IF OBJECT_ID(N'dbo.VNEWID') IS NULL

    BEGIN

    DECLARE @CREATE_VIEW NVARCHAR(MAX) = N'

    CREATE VIEW dbo.VNEWID

    ...

  • RE: Can someone help me with creating queries for the below information at the Earliest ??? Thanks in advance

    djmenon21 (4/17/2016)


    Try to write the simplest query that fully answers the question, avoiding unnecessary complexity.

    These tables from our data warehouse provide enough information to answer (you may not need all...

  • RE: Having a promblem installing SQL 2014 on a Windows 2012 Failover Cluster Servers Nodes

    jharris215 (4/15/2016)


    I have trying everything, Perstaging the SQL Network name with the right permissions and I'm still this error Log Name: System

    Source: ...

  • RE: Are the posted questions getting worse?

    Phil Parkin (4/15/2016)


    Eirikur Eiriksson (4/15/2016)


    Phil Parkin (4/15/2016)


    GilaMonster (4/15/2016)


    Phil Parkin (4/15/2016)


    Anyone have a crystal ball, several hours to kill and feeling masochistic? Dive in!

    I'm going to have to steal "Don't have...

  • RE: Are the posted questions getting worse?

    Sean Lange (4/15/2016)


    Eirikur Eiriksson (4/15/2016)


    Ed Wagner (4/15/2016)


    Greg Edwards-268690 (4/15/2016)


    Eirikur Eiriksson (4/15/2016)


    jeff.mason (4/15/2016)


    Eirikur Eiriksson (4/15/2016)


    Phil Parkin (4/15/2016)


    Anyone have a crystal ball, several hours to kill and feeling masochistic? Dive in!

    Quick fix...

Viewing 15 posts - 3,706 through 3,720 (of 8,761 total)