Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,896 through 2,910 (of 59,067 total)

Reply To: how to remove 18 milion bookid from table without using delete ?are there are an

And, no... I wouldn't do a delete in batches. You end up blowing out the log file even with that and you end up with no temporary backup if something...
--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)

August 24, 2022 at 7:15 pm

#4080273
Reply To: how to remove 18 milion bookid from table without using delete ?are there are an

I just want to make sure we get this right. You're saying that you want to eliminate all book details for books that DO exist in the books table?
I just...
--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)

August 24, 2022 at 7:14 pm

#4080272
Reply To: How to get records for the first 15 days of the month

Smash125 wrote:
How to get records for the first 15 days of the month. please suggest
WHERE OrderDate<=DATEADD(day, 15, GetDate())
Phil's code works perfectly if you can guarantee that the OrderDate column does...
--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)

August 24, 2022 at 6:20 pm

#4080242
Reply To: MS Visual Basic OR MS Visual C# ??

Jobs90312 wrote:
For now my goal is to fix my SSIS projects which are not giving the desired result.
I have no quantitative numbers on what I'm about to say but... I've...
--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)

August 24, 2022 at 5:29 pm

#4080235
Reply To: How to get records for the first 15 days of the month
MarkP wrote:
To get the Orders where the OrderDate is in the first 15 days of a month:
WHERE DAY(OrderDate) <=15
MarkP wrote:
Ant-Green wrote:
MarkP wrote:
To get the Orders where the...
--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)
August 24, 2022 at 5:17 pm

#4080232
Reply To: SSMS access and code formatting

Also, check with the other Developers in the company. You should be checking your code into some form of source control. They should also have a "onboarding" process that lets...
--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)

August 24, 2022 at 5:01 pm

#4080222
Reply To: How to pass a variable in a folder path using TSQL

josetur12 wrote:
Jeff, format date is not the issue.
If you are willing to waste your time, do it on the real problem, the variable is the issue.
DECLARE @todays AS VARCHAR(20) SELECT...
--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)

August 24, 2022 at 2:55 am

#4079940
Reply To: How to pass a variable in a folder path using TSQL

josetur12 wrote:
Hi, this is what I am trying to do,
DECLARE @todays AS VARCHAR(20) SELECT @todays = format(cast(getdate() as date),'yyyyMMdd')
EXEC xp_cmdshell 'copy C:\Test\@todays\ *.* C:\Newtest\';
But, I can figure out the syntax...
--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)

August 23, 2022 at 8:09 pm

#4079871
Reply To: SQL convert Rows to columns

wburke 85918 wrote:
Thanks for your reply Phil, Someone suggested PIVOT would do this, so I was trying to figure out how to do that. While this would be the answer if...
--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)

August 23, 2022 at 8:04 pm

#4079870
Reply To: Transfer SQL Table Data into Excel

Why not just create a stored procedure to produce the data and have Excel pull the data on demand? That way, you don't end up creating files for a bazillion...
--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)

August 23, 2022 at 3:38 pm

#4079773
Reply To: Extended Events: using ATTENTION Event to log external apps timeouts.
VoldemarG wrote:
Jeff, why do you think deadlocks could be an issue?
It was a suggestion based on previous experience that was meant to prompt you into checking for them. That worked. ...
- This reply was modified 3 years, 9 months ago by Jeff Moden.
--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)
August 23, 2022 at 1:56 am

#4079488
Reply To: Using LAG to return prior non null value

Awesome news about the Substring parameters. And, I've not run it but it looks like your @SmearStart will likely do the trick.
All of that and your previous column additions means...
--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)

August 23, 2022 at 1:41 am

#4079484
Reply To: calculation for year month and quarter with date dimension table

jeannier175 wrote:
I was able to resolve the issue i just deleted the date filter in the where clause.
Have you taken a look at your execution plan since you've done 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)

August 23, 2022 at 1:37 am

#4079482
Reply To: When Is Technology Good Enough?

daniel_jacob wrote:
But in a general sense, am more frustrated by the drive to add new 'Big' features, rather than perfect what we have.
That's one of my biggest frustrations with Microsoft.
[quote-1...
--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)

August 23, 2022 at 1:29 am

#4079481
Reply To: Turning Col into Multiple Rows

Have a look at the following article to support such "Dynamic CrossTabs". Use MAX() instead of SUM() like Scott Pletcher did. With the understanding that I have little love for...
--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)

August 22, 2022 at 5:03 pm

#4079377

Viewing 15 posts - 2,896 through 2,910 (of 59,067 total)