Forum Replies Created

Viewing 15 posts - 121 through 135 (of 247 total)

  • RE: What do you do when you inherit a mess at work?

    What really sucks is when you're supporting a mess that is a back-end for third party software. You are powerless to fix any of the code and are limited...

  • RE: Managing SQL Server with PowerShell

    That's pretty crappy documentation on Microsoft's part. I also found the answer on https://msdn.microsoft.com/en-us/library/hh231286.aspx, where it shows the example as

    #Import the SQL Server Module. ...

  • RE: Type INT

    GO 2

    I've actually never seen this before, never knew you could tell it how many times to execute.

  • RE: CREATE TABLE and Indexes

    Oh, I missed the part about this being SQL Server 2016. When I run this on our 2008 R2 instance, I get:

    Msg 1018, Level 15, State 1, Line 5

    Incorrect...

  • RE: Using OVER() to Fix Bad Version Numbers

    You can easily put a StartDate and EndDate (as well as a current flag) into what you call the traditional row model of a data warehouse. I can't imagine...

  • RE: The Attribute

    The real question here is whether Prescott should continue starting for the Cowboys after Romo comes back from his injury. If you're the Cowboys, I think you trade Romo...

  • RE: CONCATENATE in DAX

    Good to see a DAX question. I'm getting into some Power BI development here at work and I've got to say, it can be quite confusing.

  • RE: Proportional Fill

    That was a good question. I assumed that the algorithm looked at the percentage free by file instead of the percentage of total space free on each file. ...

  • RE: How Far Have You Traveled for a SQL Saturday?

    I live in a northern suburb of Milwaukee and have traveled down to Chicago for SQL Saturday twice in the last three years. According to Google maps it is...

  • RE: Too Much Information for Sports

    -1 for talking about the She-Hawks. Go Niners!

  • RE: The basic Aggregate function

    I think this kind of makes sense if you come at it from the Oracle perspective. In Oracle, to select values you have to go against the SYS.DUAL table,...

  • RE: Use Tools

    I'm only 31 years old, so I don't have the level of experience of many others here, but I've never met someone who automated themselves out of a job. ...

  • RE: Stress Testing

    Since I work almost exclusively with third party software, I generally don't need to do any kind of stress testing since all hardware requirements come from the software publishers. ...

  • RE: ORDER BY ASC and NULLs last

    Fun question, thank you.

  • RE: Is PowerShell Intimidating?

    I made it a goal to get into Powershell this year, and have so far not done much. I just haven't run into many problems that make sense to...

Viewing 15 posts - 121 through 135 (of 247 total)