Forum Replies Created

Viewing 15 posts - 8,521 through 8,535 (of 19,560 total)

  • RE: Are the posted questions getting worse?

    GilaMonster (9/27/2011)

    Enough? Please????

    For a minute I thought this was a dup post;-)

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    September 27, 2011 at 11:08 am

    #1387362

  • RE: Today's Random Word!

    crookj (9/27/2011)

    Ray K (9/27/2011)

    clouds

    Carebears

    (Sorry - got young grandkids...)

    Stare

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    September 27, 2011 at 10:11 am

    #1387305

  • RE: Today's Random Word!

    diatribe

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    September 27, 2011 at 9:38 am

    #1387267

  • RE: summing the sum of 2 colums

    Besides the expected result, what is the problem with the result set?

    Do you have sample data to go with this problem?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    September 27, 2011 at 12:00 am

    #1386934

  • RE: Loading the 100 files(.csv) from folder along with file name

    Try this tutorial

    http://www.sqlis.com/post/Looping-over-files-with-the-Foreach-Loop.aspx

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    September 26, 2011 at 11:16 pm

    #1386922

  • RE: identify applications using sa

    You could use a logon trigger that logs the connection to a table.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    September 26, 2011 at 11:14 pm

    #1386921

  • RE: Use of BETWEEN and DATETIME

    Thanks for the question.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    September 26, 2011 at 10:06 pm

    #1386910

  • RE: chart scaling?

    dup question - post response here.

    http://www.sqlservercentral.com/Forums/Topic1181290-1063-1.aspx

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    September 26, 2011 at 1:58 pm

    #1386782

  • RE: Sql server Functions

    I think you mean DDL.

    One main purpose of a function is to manipulate data and return the result. That can be done without altering structures. If you need...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    September 26, 2011 at 10:12 am

    #1386636

  • RE: DTA... profiling statetment with variables..

    NJ-DBA (9/26/2011)

    eh, I did oversimplify. The problem is that there are a large variety of statments... various delete and selects which are formatted as above. I wanted to...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    September 26, 2011 at 10:04 am

    #1386633

  • RE: Rebuild index -Timeout error

    What is the raid level on your drive? How many spindles? Is it SAN or Direct attached? What is the allocation unit size (8k, 64k other)?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    September 26, 2011 at 9:58 am

    #1386626

  • RE: what component should I use ?

    I would recommend trying either SQL Compare by Redgate or the free tool DBDiff from codeplex.

    http://dbdiff.codeplex.com/

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    September 26, 2011 at 9:56 am

    #1386625

  • RE: Browse for Network SQL Servers Only Shows Machine Name Not Instance Name

    You may want to check Windows Firewall as well. Also, when looking for the UDP, you will be looking for 1434 specifically.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    September 26, 2011 at 9:51 am

    #1386618

  • RE: Today's Random Word!

    bopeavy (9/26/2011)

    Ray K (9/26/2011)

    bopeavy (9/26/2011)

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

    Ray K (9/26/2011)

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

    bopeavy (9/23/2011)

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

    Ray K (9/23/2011)

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

    Daniel Bowlin (9/23/2011)

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

    bcsims 90437 (9/22/2011)

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

    Dragon Warrior

    The girl with the dragon tatoo

    .

    The girl with the flaxen hair

    ????????????????

    No...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    September 26, 2011 at 9:43 am

    #1386609

  • RE: Power of implicit conversion

    Thanks for the question.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    September 26, 2011 at 9:42 am

    #1386607

Viewing 15 posts - 8,521 through 8,535 (of 19,560 total)