According to the link provided in the answer, the query with the GROUPING SETS equals the query with the GROUP BY and UNION ALL.

The correct answer of QotD should be...

What way(s) did you try? Didn't it work? What errors did you encounter?

I will start with a combination of two approaches. First I will run a trace for a week or two that captures all statements with the tablename(s). If no statements...

If you suggest this, I know another approach. Rename all tables and change it...

I also thought of triggers. The downside of triggers is that they don't act on SELECTs. So if a table is only accessed by SELECT statements (for reference or archive...

If you have a snapshot, you can recover the table from the snapshot. Else I suggest to restore the database with another name and export the table to the original...

Maybe you can use the WITH (NOLOCK) hint in your SELECT statement. This will read the data even if an exclusive lock is set on the record.

:exclamation:But beware: a query...

It's a bit hard to understand your question. Can you post the complete query?

You can try to use the computed phrase to fill your column:

For instance if your computed column...

Doesn't give the description of the error a clue what the source is?

Can you post more information so we can help you better...

This is not easy for a numeric value, because you have to code '00'+@number everywhere in your code (see post of Nary). Better to convert to a string.

declare @number char(10)

set...

All values in a DMV will be removed. After the restart of SQL all logging of index-usage etc. will start from scratch.

To select all SP's with a specific versionnumber:

select * from sys.objects where type = 'P' AND name LIKE '%_268000'

To see all used versions (including how many SP's are available in...

Did you allready fill your table with data?

If so, are the values in the varchar() column unique? --> required for PK!!

For performance it is better to NOT shrink the LOG-file. It takes lots of I/O for the log-file to expand each time. When a full- or logfile-backup is taken, completed...

Or, with the sample you are giving, you can just use a nested REPLACE function in your query...

REPLACE(

REPLACE(

Table2.CategoryCode

...