Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,286 through 3,300 (of 59,086 total)

Reply To: SQL Server 2016 SP3?

Matthew145 wrote:
Looking for a close to issue. Expecting more reply.
Be advised that your post looks and smells like a precursor to spam, especially considering your other replies, which hadspam links...
--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)

June 26, 2022 at 1:17 am

#4054993
Reply To: Creating index for a very huge table

Jonathan AC Roberts wrote:
With a table of that size it might be better to look at partitioning the table.
Heh... yeah... but you'd first have to rebuild the index to partition 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)

June 26, 2022 at 12:05 am

#4054975
Reply To: Creating index for a very huge table

JasonO wrote:
My developer recently execute an index creation job...
Just exactly what does that "job" consist of?
And, yes... there's a way to do this (I do it all the time) but...
--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)

June 24, 2022 at 7:38 pm

#4054550
Reply To: Strange Write Statistics

VastSQL wrote:
Hi Experts,
I ran the below query and for a table I am getting very high writes and its increasing every second. The table here is a master table which...
--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)

June 24, 2022 at 7:27 pm

#4054547
Reply To: How to get creole language

krypto69 wrote:
thanks sir - kinda figured that !
Heh.. I wouldn't use the "current logic"... it uses some pretty slow RBAR. Use DelimitedSplitN4K, instead.

--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)

June 24, 2022 at 7:19 pm

#4054543
Reply To: How much memory is allocated when you UNION ALL?

Scott-144766 wrote:
If I have a query with multiple UNION ALLs, will the optimizer try and grab enough memory to run all the individual queues in one, or will it make...
--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)

June 24, 2022 at 1:21 am

#4054118
Reply To: explicite alternative to FORMAT() concerning DATE
Zidar wrote:
Since Tally Table of dates was mentioned, here is how to construct it:
1. create fnTally - table of numbers, by Jeff Moden, here https://www.sqlservercentral.com/scripts/create-a-tally-function-fntally
2. use the function 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)
June 24, 2022 at 1:17 am

#4054117
Reply To: How to avoid using operator when there are different values on two tables ?

jimmyblack21 wrote:
To compare data by using the New Data Comparison Wizard On the SQL menu, point to Data Compare, and then click New Data Comparison Identify the source and target...
--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)

June 24, 2022 at 1:07 am

#4054115
Reply To: How to avoid using operator when there are different values on two tables ?

wrote:
Using joins to compare columns by priority among the table. For example, left join returns all values from the first table and null value for the not-matched records from...
--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)

June 24, 2022 at 12:19 am

#4054100
Reply To: How to send data from table to text file by date

A question though.... what is the ultimate use of the text files? What is going to use them and how?
The reason I ask is a whole lot of people export...
--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)

June 22, 2022 at 8:21 pm

#4053573
Reply To: export contents of find to csv

Bruin wrote:
used in forensics to determine nightly load record processing... research... not going to load it into another backend...
Just a quick way to review...
Interesting. In that case, I WOULD be...
--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)

June 22, 2022 at 8:19 pm

#4053572
Reply To: Query help

sqlenthu 89358 wrote:
Yes, parameters.
PARSENAME will still help in this case.
--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)

June 22, 2022 at 8:10 pm

#4053570
Reply To: explicite alternative to FORMAT() concerning DATE

Like I said...
In fact, this may actually contain a much better answer especially since the target consumer will actually be Power BI.
SELECT LangName = @@LANGUAGE
,DateFormat = CONVERT(DATE,GETDATE())
--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)

June 22, 2022 at 8:08 pm

#4053569
Reply To: export contents of find to csv

I can't help on the PowerShell but, even if I could, I'd still ask the following question...
How will the resulting CSV files be used and by what?
--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)

June 22, 2022 at 5:36 pm

#4053499
Reply To: explicite alternative to FORMAT() concerning DATE
TheNewbie wrote:
Jeff Moden wrote:
TheNewbie wrote:
Hi all,
I have been using FORMAT()
```
FORMAT(Tab.date, 'yyyy-MM-dd') AS 'date_begin',
```
but been told it would be slow when it comes to BIG QUERIES.
How can I still...
--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)
June 22, 2022 at 5:28 pm

#4053490

Viewing 15 posts - 3,286 through 3,300 (of 59,086 total)