A few questions:

1. Is Length always in minutes?

2. Wouldn't you exclude Id 10 since that individual session starts at 11:30 which is the end of the overall session and therefore...

Great question!

No. Place the file where you want and then when attaching via the gui, just browse to it.

No, you can specify the new location of the log file after you've selected the MDF file. Use the GUI in SSMS, it's fairly easy.

Yes.

Sure, but...

andreas.brandsteidl (9/14/2015)

---

Hello!

Thx for the way how to call several script files!

My question is: How can I or what is the best way to catch an error in one...

But that's not in SSMS. 🙂

Risky? It doesn't run any code. It simply creates the code for you. We've used in production for over a year now and it...

Just a thought, but do you have Max memory set for each Instance as to not choke the OS out?

Are you able to RDP in/is windows unresponsive too or is...

Personally, I'd set both to automatic and let SQL Server manage them both.

One addition to the really old post.

Load your database into a Database Project in Visual Studio (SSDT - SQL Server Data Tools free add-in for VS). Then you can...

ZZartin (8/28/2015)

---

Jeff Moden (8/27/2015)

---

Heh... you guys are all missing it. You should encourage all manner of ad hoc queries from the masses so that you can better justify a...

That's generally a discussion between the DBA and management, but some key questions that come to mind...

1. Can they perform their job duties without said access or is this "just...

sleipner (8/13/2014)

---

Easy to fix this - make it an setting that one can change in options. That way DBA purists can see their NULL text and people who have...