My other question, which has still been unanswered is... can we create another database for the...

Nice job, Mike.

One of the biggest problems is that there are a huge number of common circumstances where lowing the FILL FACTOR will do absolutely nothing to prevent the page...

OK... You still haven't answered my question but, based on your acceptance of Jonathan's good code, I'll assume the answer is "Yes, that's all correct".

You asked for correction if you...

I prefer "implicit transaction", they are more safe than "begin tran" in case you use "GO" in the script.

SET IMPLICIT_TRANSACTIONS ON
;with a
as
(
SELECT * FROM dbo.account WHERE...

Yep... you said that from the git.  Can you answer my previous questions so I can best help...

Did you actually try the solution you found?  I ask because it may be that the package isn't actually running as you as you think.  I'm not an SSIS kind...

Hi Jeff,

as you mentioned in the previous thread, you came across this situation and you have solved this issue in different way. would you be able to pitch in...

I'll be the first to admit that I'm a bit of a T-SQL zealot when it comes to doing things with data.  A part of the reason is that I've...

to go along with what the other folks have written...

The biggest difference is that it will not be possible to get index seeks on the 3 column index if the...

We had that happen to us the other day... exact same symptoms.  It turned out to be a cable where a partial connection in an RJ-45 jack finally backed out...

What's really stupid is that Jonathan is absolutely correct (and, NO, I'm NOT saying Jonathan is stupid... Jonathan is far from stupid and only occasionally resorts to RBAR :D...

I guess I'm different... perhaps, a lot different.  AG is nice and all but, to me, AG has NOTHING to do with DR and vice versa.  To me, DR is...

What Jeff wrote is enough to scare me away from even trying this approach.  Using internal locking could enable end-users to do things which produce unpredictable performance.  You wrote...

Can the database be set to the BULK LOGGED recovery model?  If not, can we put this table in a new, single table database that can?

Also, how up to date...

Hello,

i have a table called Codes and having below columns

Declare table Codes(IdCode int identity(1,1) primary key, EmpCode varchar(10) unique key, AllotedStatus bit default 0)

i will get...