I add an extra jobstep to check the db role!

This step will quit reporting success when the raiserror is executed !

It will proceed to the next step if this step...

Once you actually get it that you need to work with OFFSET instead of pointers, handling bitwise operations will start working.

I always have such problems when I'm in the US...

Have you ever investigated MS Query Tuning Assistant  ?

It will avoind storing every sqlplan in the plan cache.

Queries that run only once do not polute your plan cache when this setting is on.

The article below holds all information:

ref:...

Did you enable contained db authentication at instance level?

exec sp_configure 'show advanced', 1
GO
RECONFIGURE
GO
exec sp_configure 'contained database authentication', 1;  
GO  
RECONFIGURE;  
GO

( edited: added...

• This reply was modified 2 years, 6 months ago by Johan Bijnens.

This version also handles most cross database queries:

SET NOCOUNT ON;

IF OBJECT_ID('tempdb.dbo.#invalid_db_objects') IS NOT NULL
BEGIN
    DROP TABLE #invalid_db_objects;
END;

CREATE TABLE #invalid_db_objects
     ...

I'd think it is better to really recompile all the procedures / triggers / views / functions etc. instead to hope, that the sys.dependencies-table is always 100% correct.

            
March 13, 2023 at 9:50 am
            
#4160057

            
            
                                                
        

you are validating two unrelated columns, right?

you need to correlate starttime and endtime

e.g. by adding ' and STARTTIME < ENDTIME '

double post !

https://www.sqlservercentral.com/forums/topic/select-rows-on-time-criteria

I would use datalength(v.String) so the training space at the end shows up too, so nobody checking your script actually has to doublecheck the behavior of trailing spaces.

( btw: this...

• This reply was modified 2 years, 6 months ago by Johan Bijnens.

did you check this article "SQL Server Performance Counter are Missing"

Did you try this ?

Declare   @tb table ( varcharcol varchar(10) not null )

insert into @tb 
values ( '23:01'),( '00:01'),( '00:02'),( '00:03'),( '22:00')

;with cteTimes as (
Select...

Looking at the provided data, someone had to produce XML, but missed the moint of it

<GrpID>Group ID: 14080.</GrpID>

should in fact be <GrpID>14080</GrpID> ( unless the "." has an actual significance,...

As you noticed, something went wrong somewhere in 2011.

Did someone forget to:

• automate for new partitions?
• removal of old data?

Anyway, Whenever I implement a partitioned table, I implement boundary constraints,...

I haven't encountered a developer yet, who wrote such a query himself, without using the "query designer".

I've seen some cases where it actually provided a performance advantage, however, I plead...