I bet it's a cache in VS.

visual studio creates a local *.data file with cached data so that it doesn't have to go back and forth to the server a...

maybe the databases they are creating have large space assignments?

i know if you have not set up instant file initialization, you can see some delays, right?

https://blogs.msdn.microsoft.com/sql_pfe_blog/2009/12/22/how-and-why-to-enable-instant-file-initialization/

glad you've got it sorted out.

I have to use both in my environment;

we have some tunnels to another domain where the AD accounts are not trusted, so I've got to...

ElementZero (11/21/2016)

---

I don't see where it says that you may use Windows Authentication only...? In fact on the "Create a Registered Server" Page it even says you can use...

without reinventing the wheel?

it's much easier to add it:

it's in the zip...

DelimitedSplit8K is a TSQL function.

Find the article with the string splitter named DelimitedSplit8K here on SSC and download it;

it makes spitting things like this a lot easier.

once split, you just filter for items that...

here's the script i use to generate the CREATE VIEW scripts for all extended events on the server:;

it has a reference to master.dbo.DelimitedSplit, which is a version i made of...

I've created views for all my Extended Events, so they are a little slow, but orders of magnitude easier to use.

yes the views shread the XML, but once written they...

In Registered Servers, "Local Server Groups", save Credentials with either SQL or Windows;the data is stored in your %appdata% folder, so it is user specific and not shared.

Central Management...

I've seen this happen recently on a Web/WPF app where the SQL Instance was using SQL Express;

as a resource conservation attempt, the express version defaults databases to auto close,and...

this is what i've used for quite a long time:

I wanted both server uptime and the SQLService uptime.

i made a simple stored proc, sp_help_uptime and put it in master,...

well, sp_who/sp_who2 should at l least show what is connecting to that database, I would just force the database off line then.

in 2005 and above, i know we could do...

The SSRS Service is always active in the database, even when it's not really doing anything.

SQL Server Reporting Services has two parts:

The Service and the Databases it points to and...

at the time i was answering, i had tunnel vision.

i swear, it looked like...