Hi DBAs, I have a performance issue with one hierarchy processing related query. Here is the scenario: I have following two temp tables with sample data: #temp_Mainhier (It is...

Where are linked servers?

No linked server is indicated in your script.

My current the approach is using the IF EXIST(Select...  , but, even with a properly formed index is still too slow. I am going to try the Upsert suggestion...

Verifying backups is another story. Well, it's kinda connected, but still another one.

It's possible to do robust verification of SAN backups as well as SQL backups.

So, I would not put...

SAN backup is a backup of a server with everything on it.

SQL backup is a backup of a specific database.

SAN backup is a blunt and, I'd say' dumb, tool.

If you...

I don't know what's the internet and how to unbreak it, but I could participate mostly on the go, from my Apple mobile devices.

previous upgrade made it very difficult to...

Look at the progress we've got in SQL over the years!

what used to be 13 years ago a short inline formula using system functions and integer arithmetic is now implemented...

How should the following sequence be presented?

30 December 2019 Business

31 December 2019 Holiday

1 January 2019 Holiday

2 January 2019 Business

Can the actual PARCEL_AREA value possibly have any decimal digits?

What's the idea behind choosing the data type decimal(18,5) for storing its value?

Shouldn't it be some CHAR(6), or at least INT...

Are you sure users will use only latin letters for their passwords?

Someone with the last name "Shilovich" must be well aware of other alphabets and code pages.

You may deploy a named instance of SQL Server on a virtual machine with only one (or how many they need) database required for the application.

Make sure the sysadmin account...

Here is the shorter version, but still better:

create table #Location

(
ShortCode varchar(4)
)
insert into #Location(ShortCode) values('HC')
insert into #Location(ShortCode) values('CH')
insert into #Location(ShortCode)...

Modify this statement:

UPDATE dS

ET price = t.price

FROM product_details d

JOIN (SELECT *FROM #tmp AS T1WHERE IdentityID BETWEEN @StartID and @EndID) t ON d.id = t.i

By adding

WHERE d.price t.price or...

How long the jobs take if there is no deadlock?

Create a trigger to record values from inserted and deleted tables into a "trace" table.

Something like this:

Create trigger ....

for update

As

Insert into BATCHJOBHISTORY_ALERTSPROCESSED_trace

(TraceTime, ALERTSPROCESSED_old, ALERTSPROCESSED_new, pk_col)

Select GETDATE(), d.ALERTSPROCESSED,...