IF there are any stored procedures, the joins in those store procedures can provide some important clues.  I suspect that, because of the  lack of keys, there probably aren't many...

Hi All,

The DBA who was before me had used the Ola's code in the sql job. But as i found out, it did not removed fragmentation. So i tried...

It would be nice if you told us what column you added and what it contains.  It would also be nice if you posted readily consumable data so we can...

I'm not sure whether or not you meant this to be a separate post or a post on some other thread, but I absolutely agree.

I'll also state that RegEx, especially...

I personally don't advocate the use of the PIVOT operator because it's not friendly and it's frequently almost twice as slow as the old "Black Arts" method of doing a...

Dude!  There's no need to triple post!  It just spreads out answers and wastes other people's time because they cannot see all that's been posted.

Please folks... no answers here.  Let's...

Dude!  There's no need to triple post!  It just spreads out answers and wastes other people's time because they cannot see all that's been posted.

Please folks... no answers here.  Let's...

From what I can see, the current code tries an update.  If there's nothing to update, it does an insert and then returns to try the same update again.  That...

I don't even know what "powerapps o flow" is.

If the machine hasn't recently been rebooted and the SQL Server Service hasn't recently been bounced, you could check sys.dm_db_index_usage_stats to see...

Thanks, Frederico.  I appreciate it.

The answer there is "Yes" but I'm...

but it seems that DBAs who manage tons of servers have come up with a set of scripts (based on DMVs or other ways of getting insert/update metrics) they...

... but it seems that DBAs who manage tons of servers have come up with a set of scripts (based on DMVs or other ways of getting insert/update metrics)...

Teaching a man to fish...

sample powershell script that I use to copy/move files from a drop folder to dev/tst/prod destinations - dev/tst are "copy" while prod is "move"

some of...

...which is why I...