Forum Replies Created

Viewing 15 posts - 4,606 through 4,620 (of 5,685 total)

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (12/10/2010)

    Craig Farrell (12/10/2010)

    I'm failing to see the problem with this... I'd purposely go out of my way to wander through said lounge on the way....

    December 10, 2010 at 3:37 pm

    #1261231

  • RE: Are the posted questions getting worse?

    WayneS (12/10/2010)

    CirquedeSQLeil (12/10/2010)

    jcrawf02 (12/10/2010)

    CirquedeSQLeil (12/10/2010)

    Alvin Ramard (12/10/2010)

    WayneS (12/9/2010)

    CirquedeSQLeil (11/30/2010)

    For any that might be interested in an opportunity to heckle a threadizen, check this out[/url].

    Bummer... user group was locked out of...

    December 10, 2010 at 2:15 pm

    #1261216

  • RE: Query not showing needed results

    doug 40899 (12/10/2010)

    Craig,

    Sorry about not getting the data right on that. I tested your query and it works the way that I need it to.

    Thanks

    Doug

    Great to hear it's working....

    December 10, 2010 at 2:12 pm

    #1261214

  • RE: Getting Started in SQL Server

    FargoUT (12/10/2010)

    This was an excellent article! I even forwarded it on to the manager of a company who was asking me for help in determining what sort of skill requirements...

    December 10, 2010 at 2:04 pm

    #1261212

  • RE: Getting Started in SQL Server

    Grumpy DBA (12/10/2010)

    Great article, Craig!

    Not only did I enjoy the content of the article I applaud your writing style - clear, concise, well organized. Looking forward to more articles.

    Thank...

    December 10, 2010 at 2:04 pm

    #1261210

  • RE: Passing a table between Data Flows

    Dan Guzman - Not the MVP (12/10/2010)

    Yes, Craig, your descriptions does summarize it very well.

    Well, there's the Recordset Destination available in the data flow, as you already mentioned. There's...

    December 10, 2010 at 12:08 pm

    #1261169

  • RE: Getting Started in SQL Server

    CirquedeSQLeil (12/10/2010)

    Thanks for the article Craig. One note is that too many times people read DBA or Database Developer and pigeon hole a candidate into being exclusively a production...

    December 10, 2010 at 11:56 am

    #1261167

  • RE: Can I tune this?

    LutzM (12/10/2010)

    Brandie Tarvin (12/10/2010)

    LutzM (12/10/2010)

    A similar option would be adding another table CoverageVersionsHistory with the current CoverageVersions structure and move all outdated versions into this history table on a scheduled...

    December 10, 2010 at 11:34 am

    #1261158

  • RE: Passing a table between Data Flows

    As I stated in the original post, I have a for each loop container that loads all of the files in a folder into a table in the db. ...

    December 10, 2010 at 11:32 am

    #1261156

  • RE: Data from Multiple Data sources into Single Destination

    Pulivarthi Sasidhar (12/10/2010)

    How to import data from 4 servers to my local server Database.

    My local server DB has 4 tables for 4 server's Data

    Use four data flows, or use the...

    December 10, 2010 at 11:21 am

    #1261152

  • RE: Optimizing This Query

    A couple of things I can see offhand:

    dibbydibby (12/10/2010)

    inner join Nodes N on N.NodeID = substring(CA1.NodeID,2,len(CA1.NodeID)-2)

    This destroys the sargability against ConfigArchive1, forcing a scan and scalar before anything is...

    December 10, 2010 at 11:01 am

    #1261143

  • RE: How to Calculate Total Monthly time worked

    autoexcrement (12/9/2010)

    Wayne, yes, thank you. That explains it completely. So, using your example of a time "80101", the code would (working from the inside out) transform it thusly:

    80101 (original)

    10108 (reversed)

    10:108...

    December 10, 2010 at 2:08 am

    #1260921

  • RE: Query speed is slow

    If there's been no changes to indexing or data volume, you've either got stale statistics, or you need to double check your system for memory, cpu, or drive pressure.

    December 10, 2010 at 2:01 am

    #1260919

  • RE: Using Scope_Identity for insert

    vbradham (12/9/2010)

    Thank you, I kind of see what you are doing..but in the table insert that requires the identity is like this

    INSERT INTO dog_name

    (

    dog_ID --Identity from...

    December 9, 2010 at 5:45 pm

    #1260855

  • RE: Accumulate Hours and Generate finish date

    You're not the only one. Where'd the 12/13 for Name A come in? That's a 4 day gap.

    Please check my sig for the first link. It will...

    December 9, 2010 at 4:10 pm

    #1260845

Viewing 15 posts - 4,606 through 4,620 (of 5,685 total)