Interesting debate. I agree that hotel room numbers are often not numerics, but strings. Numerics are used when we need some ordering, but if there wasn't a 505 on that...

I'm not quite clear what you're trying to do with #userpermission and the execute. You get to execute one statement. If you want to do a couple things, then run...

I assume this works correctly for you:

DECLARE @dbname VARCHAR(50);
DECLARE @statement NVARCHAR(MAX);
DECLARE db_cursor CURSOR LOCAL FAST_FORWARD FOR
SELECT name FROM master.sys.databases WHERE state_desc = 'online';
OPEN db_cursor;
FETCH NEXT FROM db_cursor
INTO...

There are no production builds yet.

The OP had a SPAM post.

@akhil you cannot explain this only in words. You need to provide some DDL of the table(s) structure and a few inserts to show sample...

Please follow the link in Jeff's signature and post some DDL and sample data to help us understand your structure and data.

We can "sell" PTO back to the company for pay each year. Capped at 5 days, but on the years I haven't used all mine, it's a nice benefit.

That would be my approach, but management doesn't always support that. And if management doesn't agree with that, then the DevOps process fails.

That's most of my point about people. Both...

I think you just proved my point that this...

Definitely a problem these days. Had to get staff...

Nope, fixing that

The car analogy is a good one In general, a 20 (or 30) year old car does what a current one does. Get you from place to place. Most of...

The case against patching (of SQL Server CUs) is that all databases are updated with a single thread during the CU update process, during which the SQL Server is...

Thanks for the article Steve.

...

I've worked with DBA's who dragged their feet on patching every...single...month and couldn't get IT management to support me on patching. So again, less technical...

An update every 30 minutes is a bit much, but depends on the situation. If I'm with a real time system, then I might want this. Certainly I've had incident...