What may be a better approach, is just use the AD groups to identify people, then setup database roles for the levels of permissions you need to give people.  For...

If something isn't a set, it often helps to turn it into a set.  Here's an example:

DECLARE @val1 nvarchar(40) = 'Hello';
DECLARE @val2 nvarchar(40) = 'Treacle';
DECLARE @val3 nvarchar(40)...

it may be possible to find it using sys.dm_db_stats_histogram:

https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-db-stats-histogram-transact-sql?view=sql-server-2016

You could use a query such as:

SELECT OBJECT_SCHEMA_NAME(ss.object_id) AS schema_name, ao.name AS table_name, ac.name AS column_name,
  ...

Have you analyzed what is taking up all your tempdb space?  With this many large data files I find it difficult to believe that after restarting the service this much...

Presently I drive my 9 year old reliable Toyota Camry.  Boring, but a comfortable ride.  None of the bells and whistles (excuse me, safety features) you see in today's...

• This reply was modified 5 years, 9 months ago by Chris Harshman.

One of the hardest things to do when generating test data as opposed to obfuscating production data is the non-normal situations.  I've found in my years in IT that users...

You typically wouldn't want to put a value like quantity on hand in a dimension table.  Dimension tables tend to have many columns but few rows.  Think of it this...

These rowcounts are not too big, but when you take 17,738 rows (the main 3 tables in the query) and CROSS APPLY them to 728 rows (calendar table) then that's...

This query seems to be spending most of its work trying to resolve the self join of dbo.stdord sto to dbo.stord st in ca subquery to do the filter.  Is...

I would imagine whatever your daily process is to update the Warehouse_Fact would have to be able to find what products where shipped from a given warehouse and what products...

The current place I work we have to get 2 week advance notice for anything that requires a schema lock on any of the busier tables. Granted we are...

hahahahahahahahahah you make me cry -'m in the middle of devops at the minute - I've only just got us in source control, our devs just do stuff on...

I guess what confused me about Order_Fact was the Order_Status, so I wasn't sure if there would be multiple rows in here for the same order item at various points...

Here are some initial thoughts, without knowing what type of business you are modeling or what the requirements are:

Time_Dimension

I would expect more columns here than just the key.  I don't...

I think we need clarification on what the desired output of this query is.  To me, the whole Quaters table seems unnecessary if all you are returning in your results...