at a high level, this query will show you how TEMPDB is being used:

-- space usage summary
SELECT SUM(unallocated_extent_page_count) AS FreePages,
    CAST(SUM(unallocated_extent_page_count)/128.0 AS decimal(9,2)) AS...

If you don't want to use a view, computed columns may be an option since it looks like you just want a simple concatenation of other columns in the same...

I started my career as a developer way back in the mid 90's, so it's difficult for me to think of it any other way.  Of course at college they mainly...

A problem with using dbcreator is that it allows people that have that role to drop databases, even if they weren't the ones who created them.  Maybe you could just...

I've been having copy and paste issues too in the new forums... I've been pasting my queries into Notepad, then copying from that to paste into the forums, seems to...

As the DBA where I work, I had to introduce my own code review step into the developer's process, because I got sick of seeing bad queries and patterns at...

there may be an easier way to do this, but I got stuck trying to figure out how to shift the values leftwise:

WITH sortvals AS

looks good that you're handling NULL, the only change I'd make is reference OCD instead of the full table name, and the WHERE clause is redundant with your JOIN condition:

you can do a join in an UPDATE statement, just reference the alias of the table you want to update, something like this:

UPDATE b SET RotationCount...

should be able to do something like this:

SELECT C2.personID,C2.enrollmentID
  ,attributeID = CASE WHEN C1.value = 'N' THEN 3371 ELSE 3370 END
  ,C2.value, C2.[date], C2.customGUID,...

if you're just trying to test permissions to a query or update or something through management studio, you could possibly use the EXECUTE AS command to impersonate a different login...

When I've used Windows Task Scheduler to setup items like this, I tend to use a CMD script file, with code like this in it:

ECHO Backup Database...

"Do I need to "lengthen" this table by making every single forecast value it's own row with a new column to demarcate it's MONTH/YEAR value, or do I leave it...