Forum Replies Created

Viewing 15 posts - 4,381 through 4,395 (of 8,753 total)

  • RE: Do not see full backups in the specified Backup folder

    Quick questions, are the backups successful (check the log)? Any cleanup tasks scheduled or running? Is it the right drive?

    😎

  • RE: Like Statement With Parameters

    Thanks Jason, nice job testing this.

    😎

  • RE: IN clause very slow - was OK in previous versions

    erb2000 (10/4/2015)


    Yes, it is a huge IN clause with hundreds of elements.

    Quick suggestion, have a look at this article When is a Seek not a Seek? by Paul White, sounds...

  • RE: IN clause very slow - was OK in previous versions

    erb2000 (10/4/2015)


    Our application has serious problems after upgrading to Sql Server 2014. We tracked it down to the huge IN clauses running very slowly. It's not easy to...

  • RE: Conditional Join between two tables

    Two possible solutions

    😎

    USE tempdb;

    GO

    SET NOCOUNT ON;

    --- First Create two tables

    IF OBJECT_ID(N'dbo.tabA') IS NOT NULL DROP TABLE dbo.tabA;

    CREATE TABLE dbo.tabA

    (

    cola1 NVARCHAR(100) NULL

    ,cola2 NVARCHAR(100) NULL

    ...

  • RE: Conditional Join between two tables

    Quick question, can you supply some more details, the data and query posted need a little bit more explanation as the result is simply a Cartesian produce of the two...

  • RE: Query for duplicates

    sqllearner1234 (10/3/2015)


    I'm using this to create a view for duplicates , but no of records coming out of this view are more than I'm passing in:(this query works fine in...

  • RE: Random number !

    farax_x (10/3/2015)


    I have a function which generate random number in range :

    CREATE FUNCTION Func_Rand

    (

    @max-2 BIGINT ,

    ...

  • RE: Like Statement With Parameters

    Jason A. Long (10/3/2015)


    Eirikur - I'm with Chris on this one... VERY slick solution.

    I have to confess that I'm baffled by optimizer's ability to do an index seek with leading...

  • RE: Alternative query which can have better performance

    Quick question, is this query really producing the desired result set when it is missing the filtering in the XML subqueries?

    😎

  • RE: Today's Random Word!

    DonlSimpson (10/2/2015)


    djj (10/2/2015)


    anthony.green (10/2/2015)


    whereisSQL? (10/2/2015)


    crookj (10/2/2015)


    anthony.green (10/2/2015)


    eccentricDBA (10/2/2015)


    anthony.green (10/2/2015)


    BWFC (10/2/2015)


    anthony.green (10/2/2015)


    SQLRNNR (10/1/2015)


    pish

    annoyed

    Always

    Developers

    Tycoons

    Zoo

    ...lander

    Movie

    Trivia

    Knowledge

    Understanding

    Perception

  • RE: Are the posted questions getting worse?

    Lynn Pettis (10/2/2015)


    Eirikur Eiriksson (10/2/2015)


    Lynn Pettis (10/2/2015)


    How do I clear the DMVs without restarting SQL?

    Why?

    😎

    Because I don't necessarily want to restart SQL just to clear some of the DMVs I...

  • RE: Are the posted questions getting worse?

    Lynn Pettis (10/2/2015)


    How do I clear the DMVs without restarting SQL?

    Why?

    😎

  • RE: SPID Causing Locks With No Query Text Shown

    joshdbguy (10/1/2015)


    I just ran into an issue with cascading locks due to a SPID on one of my production servers. When researching the lock, I noticed that there was no...

  • RE: Are the posted questions getting worse?

    ChrisM@Work (10/2/2015)


    dwain.c (10/1/2015)


    Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Eirikur Eiriksson (10/1/2015)


    ChrisM@Work (10/1/2015)


    Oh, and maple beer - yuck.

    This made me spill my...

Viewing 15 posts - 4,381 through 4,395 (of 8,753 total)