You can also start up SQL Server using the -T3608 and -T3609 flags, then open SQLCMD and run the ALTER DATABASE tempdb MODIFY FILE...

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

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

GO 2

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

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

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

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

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.

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

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

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

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

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

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

Fun question, thank you.