Jeff Moden

Forum Replies Created

Viewing 15 posts - 631 through 645 (of 59,081 total)

Reply To: Toilets and Your Systems

David.Poole wrote:
Jeff Moden wrote:
You have to be really careful here. Constant "refactoring" of anything is a really bad idea.
I take your point though I think you are mistaking refactoring...
--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)

April 26, 2024 at 4:40 pm

#4415826
Reply To: given value of type String from the data source cannot be converted to type nvar

bvi1998 wrote:
Yes, I am performing a bulk copy from PowerShell, from a csv file.
As a bit of a sidebar, it's always fascinating to me to watch how people do...
--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)

April 24, 2024 at 4:24 pm

#4415062
Reply To: Toilets and Your Systems

Eric M Russell wrote:
So, on a submarine, you can't design the toilets to flush into the ballast tanks or maybe a designated septic tank that periodically gets evacuated?
Heh... sounds like you already...
--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)

April 24, 2024 at 4:13 pm

#4415061
Reply To: given value of type String from the data source cannot be converted to type nvar

Overall, what are you actually trying to do? Bulk insert from files to the database or???

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

April 24, 2024 at 2:19 am

#4414777
Reply To: Backing up and Restoring a 3 terabyte database takes over 5 hours

I can't speak for the cloud but I'm backing up a 4.7 TB database over NAS on-prem in 1 hour and 13 minutes. It's a single file backup but 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)

April 24, 2024 at 2:15 am

#4414776
Reply To: Table with FK(s) to other columns within the table

ratbak wrote:
Take a look at Hierarchies on Steroids #1: Convert an Adjacency List to Nested Sets & Hierarchies on Steroids #2: A Replacement for Nested Sets Calculations 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)

April 23, 2024 at 6:57 pm

#4414666
Reply To: Db growth rate

mtz676 wrote:
Is there are db growth rate formula which can be used to predict say next 3/6 months of db growth rate.
Yes. It's known as "Linear Regression Analysis". I'm giving...
--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)

April 23, 2024 at 6:55 pm

#4414665
Reply To: Hardcoded filter vs filter by parameter

blom0344 wrote:
Adding the option (recompile) slows it down even further , taking an additional 30 seconds to start the dataflow
Heh... now that's interesting. And, I just noticed... this is 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)

April 23, 2024 at 1:28 am

#4414305
Reply To: Time and Space: How to Monitor Drive Space in SQL Server
Perry Whittle wrote:
Jeff Moden wrote:
Sam Catchesides wrote:
I implemented a similar solution at work, logging the disk free space (along with database free space) to a table along with when it was recorded. Simple...
- This reply was modified 2 years, 3 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)
April 23, 2024 at 1:20 am

#4414303
Reply To: Time and Space: How to Monitor Drive Space in SQL Server

Sam Catchesides wrote:
I implemented a similar solution at work, logging the disk free space (along with database free space) to a table along with when it was recorded. Simple SSRS report...
--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)

April 21, 2024 at 9:58 pm

#4413836
Reply To: Hardcoded filter vs filter by parameter

This is very likely a case where the use of a statement level OPTION (RECOMPILE) will work perfectly and very quickly.

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

April 21, 2024 at 3:30 pm

#4413767
Reply To: Do I need a recursive query for this? bill of materials (sort of)

Heh... you, of all people, should know about "double posting".
Folks, no answers here, please. Instead, go to the duplicate post and post there. Thanks.
https://www.sqlservercentral.com/forums/topic/do-i-need-a-recursive-query-for-this-bill-of-materials-sort-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)

April 19, 2024 at 3:25 am

#4412991
Reply To: Do I need a recursive query for this? bill of materials (sort of)

I'd have to see more but I'd start with the idea that the "Starter" is actually a "Product" and that product becomes an "Ingredient" as if you bought it 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)

April 19, 2024 at 3:23 am

#4412990
Reply To: Query run from SQL agent, not returning same results as from query window
Phil Parkin wrote:
I would use the following code to get 'last' Sunday. Seems a bit simpler than the current version.
```
SELECT DATEADD (wk, DATEDIFF (wk, 0, GETDATE ()), 0)...
```
--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)
April 15, 2024 at 2:01 pm

#4411466
Reply To: Query run from SQL agent, not returning same results as from query window

Do not use DATEDIFF(WK) if you need for the first of the week to be based on any day of the week other than SUNDAY. It is ALWAYS based 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)

April 15, 2024 at 1:38 pm

#4411462

Viewing 15 posts - 631 through 645 (of 59,081 total)