Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,506 through 5,520 (of 59,089 total)

Reply To: Database list and the last access date
The SQL would look like the following... 😀
```
   WITH ctePreAgg AS
(--==== Pre-aggregate the relevant columns to make display easier.
 SELECT  DBName   ...
```
--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)
March 17, 2021 at 9:27 pm

#3859161
Reply To: Every IT Organization is a Snowflake

There are several different "broad categories" of real snowflakes. From what I've seen, each shop really is unique even if they fit one of the broad categories. To wit, 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)

March 17, 2021 at 2:23 am

#3858757
Reply To: Is there room for independent SQL or Data Integration based User Groups?

David Burrows wrote:
One advantage of virtual meetings would be, if permissible, for us this side of the pond attending. Would love to see you presenting Jeff 🙂
Lordy... I'm sorry, David... 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)

March 16, 2021 at 2:17 am

#3858291
Reply To: Help with non-clustered index fragmentation

rando wrote:
That seems to have done the trick. Thanks!
Be careful of "the trick". I may be causing unnecessary rebuild of the clustered index and a wad of non-clustered indexes, to...
--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)

March 15, 2021 at 5:21 pm

#3858111
Reply To: Distributed SQL Databases

Sergiy wrote:
No code can fix performance issues caused by faulty database design.
If you think otherwise - try to fix performance (and scalability) issues on msdb.
I'll be the first to agree...
--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)

March 15, 2021 at 2:44 pm

#3858018
Reply To: Errors using XML value method

wrote:
However, that's true only when returning the entire XML value. The query() method retrieves a subset of untyped XML from the target XML instance. location within the document, 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)

March 15, 2021 at 6:23 am

#3857839
Reply To: Bulk Insert not working for dataset

logan.keister wrote:
Hello all,
Maybe this is my own ignorance showing, but I think I've hit a brick wall. I can't seem to bulk insert a dataset. I create a temp table...
--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)

March 15, 2021 at 1:18 am

#3857776
Reply To: Bulk Insert not working for dataset

sudishnch wrote:
Let try below 2017 version
I'm not sure I understand what you're saying. If you mean to try it on something less than 2017, then here's what you get...
Msg...
--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)

March 15, 2021 at 12:23 am

#3857765
Reply To: parse files in folder

I don't know of any EDI spec that doesn't use an"*" as a delimiter but people are known to make up stuff as they go along and so understood on...
--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)

March 15, 2021 at 12:06 am

#3857764
Reply To: Sql query - Projected Monthly Revenue

ScottPletcher wrote:
The linked article states that "If a date is neither a holiday, nor a weekend day, it is a workday." But that's not true. Businesses may be shut because...
--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)

March 14, 2021 at 10:32 pm

#3857735
Reply To: parse files in folder

Thanks for the feedack, Jeffrey...
I totally agree that trying to fully parse EDI files in SQL Server is a bit crazy and even I probably wouldn't go there, especially since...
--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)

March 14, 2021 at 7:29 pm

#3857698
Reply To: parse files in folder

I have to agree with Jeffrey Williams here. The files are EDI files and the "*"s are actually delimiters. If you use positional notation instead of the element ordinal after...
--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)

March 14, 2021 at 4:22 pm

#3857643
Reply To: How to Structure Data table/fields when using Multiple Select Drop Down

rjjh78 wrote:
Hi Many thanks both for your help on this!
For some reason, I get the message Invalid object name 'dbo.DelimitedSplit8k'. Could I need an update for this?
See my post right...
--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)

March 14, 2021 at 1:36 am

#3857480
Reply To: Ransomware trojan enters via Powershell script contained in Word macros

Oooooo... now that's interesting... I did a quote of an existing post at 1:58PM and the SPAM deletion that had to have occurred AFTER that is marked as having occurred...
--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)

March 13, 2021 at 10:58 pm

#3857447
Reply To: parse files in folder

Jeffrey Williams wrote:
Jeff Moden wrote:
Bruin wrote:
The above lookups are in the 1st record in file using criteria above. I need some help ...
THanks.
What's stopping you from reading the first two rows using...
--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)

March 13, 2021 at 10:53 pm

#3857446

Viewing 15 posts - 5,506 through 5,520 (of 59,089 total)