Hi Ian,

I like your script and I have started incorporating it into my tool kit.

One comment on SpaceUsed. The Transaction Log Record count is certainly useful but I think the...

Hi John,

Lot's of good ideas and code snippets that I plan to put to good use. Thanks,

You should look into sys.dm_os_volume_stats(<database_id>, <file_id>. This is a great little function added...

When the Major Release cycle is ~2 years and the license model changes and the recommendation to apply the ~bi-monthly CU's, and Patch Tuesday, it seems that MS is driving...

The attitude of many developers toward SQL and relational databases has always puzzled me.

The database provides data persistence, can help enforce data integrity, and simplifies many relationship oriented patterns.

All interesting...

Hi Arun,

I am a bit confused by your configuration data, specifically RAM. Is 24GB the Total RAM on the server? or is it just the Server Max Memory for...

This is just an aside and certainly not a criticism of your well crafted code 🙂

I have always been "amused" by the "set-based mafia" who insist that my use of...

Thanks for the reply Lowell.

I received the "WARNING: Error initializing default drive: 'Unable to find a default server with Active Directory Web Services running.'." message.

I was trying to run the...

andre.quitta (3/31/2016)

---

when I tried to run the code in Powershell, I got the following error.

[font="Courier New"]Import-Module : The specified module 'ActiveDirectory' was not loaded because no valid module file was...

Thanks Jack,

I must have looked at a couple of dozen pages searching for release info. I don't know how I missed this one.

I am sorry that I fall short of your expectations and apologize for not meeting your standards.

I will of course, bow to your superior knowledge and refrain from future contributions.

The OP question was not about performance. It was about syntax

What's your point? The Original post still pops up in searches and is still valid.

I realize the first reply "solved" the problem...

The syntax error was because you have a select sub-query

Select @Return = Select ....

Your second Select needs to be in parens

Select @Return = (Select ..........

dbeggs57 (12/22/2015)

---

After reading just the first section "The Horror Begins", I thought you were talking about a Microsoft Dynamics application. With a slight bit of exaggeration added, just slight....

"but I also truly believe that the pressures of getting software released overwhelm the concerns and dangers that exist overall. "

You can talk about "the idiots that design" or "trusting...