Do you know where SSMS is storing temp files? I believe the default is %USERPROFILE%\AppData\Local\Temp.

I just ran a really stupid query, returning millions of rows to the screen and...

• This reply was modified 1 year, 9 months ago by  Stephen Rybacki. Reason: Typo

ratbak wrote:

Is TempDB on the C Drive? Is it growing/filling the drive?

Or is it actually SSMS temp files mentioned previously?

Check/tune their queries if possible.

No, TempDB is on it's own drive. ...

Thanks folks, that was the ticket.  I made all of our BIDS their own temp space on our much larger drive, and had them repoint their environment variables to there. ...

• This reply was modified 1 year, 9 months ago by  Stephen Rybacki.

So yes the combination of that plus fixing an underlying problem with the data itself. It turns out that the table that contains the users who have been terminated is...

Solved.

Here's an attempt to refactor the query with functional equivalency (afaik)

insert into [Micros].[UserTerminations]([UserID], [TerminationDateTime])
select u.[HostUserId], getdate()
from [Micros].[Users] AS u
where exists (select 1
    ...

• This reply was modified 3 years, 1 month ago by  Stephen Rybacki.

Actually Jeff, this is to estimate the size of Snowflake real estate we need to plan for as we transition to a warehouse. We have two major Health Care EMRs...

My personal challenge workwise is to learn WhereScape and Snowflake to build a warehouse from our two major Health Care systems plus the myriad of one-off systems we have here...

Thank you Grant for this. I thought as much really, so I pursued a different track; I used date info in the largest tables (billions of rows) to get year...

• This reply was modified 3 years, 2 months ago by  Stephen Rybacki.

I do the same as what Anthony posted.

There might be at least one caveat to be aware of.  My disclaimer is that I've not had to try it and...

I’d do it as an alter database modify file, offline database, move the file, online the database.

This is just to get around the permission changes which happen with a...

Steve, I would agree with you, except in a few situations. For example, I am now 60 and working what will be my last gig as a DBA for...

Turns out that a group had DENY on it, and the reason that was missed at first was because it was highly obscured that the folks involved were even part...

I am checking into that right now actually.  I logged into the secondary node machine with my elevated credentials, then ran SSMS with my non elevated credentials to see if...