Forum Replies Created

Viewing 15 posts - 46 through 60 (of 5,684 total)

  • RE: variable char

    peter478 (11/10/2014)


    can you post me a link for passthrough queries you mean?

    http://support.microsoft.com/kb/303968/

    Or simply google: microsoft access passthrough query

  • RE: Report Duration

    As far as I know up to 2k8R2 there isn't an option for that. It's possible 2012/14 has it, I haven't played there.

  • RE: Script Component help

    Not sure I understand the intricacies of what you're doing, I'm a little lost in your explanation, but if it's a 1:1 from Description to code, a Lookup Component with...

  • RE: Is Shrinking Log Files Good or Bad?

    Alvin Ramard (11/10/2014)


    I'd like to know where so many people got the idea that the database should be set to Simple Recovery Mode first.

    Bad habits from DTS when I used...

  • RE: variable char

    The single or multiple SQL User doesn't matter, just FYI. Most webapps run that way with hundreds of thousands of unique users on the far end.

    What's happening with #amp...

  • RE: Standard List Of Items To Check

    Keeping query tuning to the side is like asking to create a sentence without verbs.

    Queries are what puts the pressure on systems. Knowing which queries hurt can point you...

  • RE: variable char

    Groups is a character string. So, you've lost your wrappers for it being text.

    You need something like @sql = @sql + ' WHERE groups =...

  • RE: Any reason why same non clustered index would be better than clustered index?

    Depends on how much else is in the table. The Clustered Index carries the entire table at the leaf level, the Non-Clustered only carries included columns and information needed...

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (11/4/2014)


    We made a few forum changes today. If you notice something, let us know.

    Recent Posts dropdown doesn't seem to want to work on IE9 through...

  • RE: Service Broker Question

    JeeTee (11/3/2014)


    I have a proc [...] the application is very spikey, in that it will sometimes fire off tens - if not hundreds of thousands of messages all at once....

  • RE: SSIS loop with query of keys as variable

    I agree with Phil on this one, but I'd take it one step further. You're building what I usually nickname a "Mainframe File", where row ordering is important to...

  • RE: SSIS Parameter Vs Variables

    As a side note, if you haven't gotten yourself upgraded (like my shop) past 2k8R2, I still use variables and configurations... I just configure the variables, then share that config...

  • RE: Managers: who needs them?

    PatrickIndex (10/28/2014)


    Don't managers create the politics in the first place? So if you didn't have managers then there would be no politics to deal with. Allowing managers to deal with...

  • RE: CI and CD Aren't Magic

    Doctor Who 2 (10/27/2014)


    That makes sense Craig, thank you. But what about management? They don't debug anything. They may test software, but are as likely as not to test anything.

    Management...

  • RE: Full outer join question

    N_Muller (10/27/2014)


    I need to rebuild this query such that it filters out records that are of no interest (PID = 1 in table @T1 and Process = 0 in table...

Viewing 15 posts - 46 through 60 (of 5,684 total)