Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,861 through 7,875 (of 59,091 total)

Reply To: Establishing SQL server tables Relationships without knowledge of DB and tables

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...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 22, 2020 at 1:17 pm

#3717358
Reply To: Require Recommendations | Index Rebuild

JigarShah wrote:
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...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 22, 2020 at 12:45 pm

#3717347
Reply To: Pivot: Rows to Column and Values as rows

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...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 21, 2020 at 3:27 pm

#3717070
Reply To: how about explaining your RegEx logic?

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...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 19, 2020 at 7:09 pm

#3716634
Reply To: Pivot in multiple inner joins

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...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 19, 2020 at 7:02 pm

#3716632
Reply To: Migrating SQL Server 2014 databases to Oracle 19.

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...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 19, 2020 at 6:56 pm

#3716630
Reply To: I need to move database with 500 tables from SQL Server to Oracle 19

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...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 19, 2020 at 6:55 pm

#3716629
Reply To: is WITH (ROWLOCK) hint a culprit in this code?

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...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 19, 2020 at 6:08 pm

#3716623
Reply To: is there anyway to send an email if no record has been submited during the day

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...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 18, 2020 at 9:47 pm

#3716568
Reply To: Exporting Data with PowerShell

Thanks, Frederico. I appreciate it.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 18, 2020 at 9:23 pm

#3716564
Reply To: Require Recommendations | Index Rebuild

webrunner wrote:
Can you recommend a starting point for a scalable way to find out these insert/update patterns across dozens or hundreds of SQL Servers?
The answer there is "Yes" but I'm...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 18, 2020 at 9:13 pm

#3716563
Reply To: Require Recommendations | Index Rebuild

ScottPletcher wrote:
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...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 18, 2020 at 8:13 pm

#3716558
Reply To: Require Recommendations | Index Rebuild

webrunner wrote:
... 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)...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 18, 2020 at 8:11 pm

#3716557
Reply To: Exporting Data with PowerShell

Teaching a man to fish...
frederico_fonseca wrote:
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...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 17, 2020 at 11:18 pm

#3716456
Reply To: With SQLAudit you cannot track HostName or IP address.

Grant Fritchey wrote:
This would all output to an XML file. You can query it using SSMS or load it into a table using extended stored procs and XQuery.
...which is why I...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

January 17, 2020 at 11:06 pm

#3716454

Viewing 15 posts - 7,861 through 7,875 (of 59,091 total)