Forum Replies Created

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

  • 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...

  • RE: Dexterity Matters

    Anyone else here have problems with accidentally IMing their passwords out to coworkers? It's so easy to think you are in one application, but instead you have Lync or...

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