Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,946 through 3,960 (of 59,087 total)

Reply To: Laptop Recommendations for 2019

Ok... despite the fact that I love my Alien-ware that I previously described, I'm finding that ALL laptop keyboards suck. I have had one yet where frequently used keys don't...
--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)

February 9, 2022 at 5:16 pm

#3981563
Reply To: Requirements doc and interviewing development groups

p.s. As another side bar and just in case it becomes a requirement, remember that anything that the DBAs or others with sufficient privs can affect will NOT stand up...
--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)

February 9, 2022 at 4:44 pm

#3981560
Reply To: Requirements doc and interviewing development groups

Jason Wilks wrote:
Thank you Jeff and Grant for your input!
Yes my conceptual model doc will layout keys, uniqueness, relationships, and attribute rules and constraints. Eventually.
I think one question I had is.......
--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)

February 9, 2022 at 4:38 pm

#3981558
Reply To: Wondering if it would be better to use UNION when performing inserts

On the subject of BULK INSERT...
As with anything else, "It Depends" but, no, you don't actually have to disable all sorts of constraints to bulk load data into a 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)

February 9, 2022 at 4:10 pm

#3981550
Reply To: The Cloud as a Foundation
I think that the cloud has some fantastic capabilities and opportunities. Despite some of my posts, my big concern isn't so much about the cloud, it's about the "shiny new...
- This reply was modified 4 years, 6 months ago by Steve Jones - SSC Editor.
--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)
February 9, 2022 at 3:19 am

#3981428
Reply To: store data

sqlfriend wrote:
Thank you. It looks like the Modern_Spanish_CI_AS stored spanish mainly. What we want is still a database mostly stored English, but just for sometimes if users like to display...
--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)

February 9, 2022 at 3:04 am

#3981427
Reply To: Requirements doc and interviewing development groups

Jason Wilks wrote:
No the database does not exist. I have a conceptual design doc where i have defined several entities based on the UI designs i have seen. I will 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)

February 9, 2022 at 2:45 am

#3981425
Reply To: Indexes

sqlguru wrote:
What do you think about schema changes history? How long does it keep the history?
If I recall correctly (and I might not), that's based on the default trace. 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)

February 9, 2022 at 2:07 am

#3981423
Reply To: group records by week

My question is simple... how many rows per day will that normally include?
--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)

February 8, 2022 at 10:26 pm

#3981402
Reply To: Wondering if it would be better to use UNION when performing inserts

Rod at work wrote:
What I would like to ask here is if it is faster to perform a lot of INSERTS to repopulate tables, or if it would be better to perform...
--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)

February 8, 2022 at 9:55 pm

#3981398
Reply To: Loading x number of CSV files into x number of unique tables of a database

Ah, there you are. The forum had a probem with email notifications that they just fixed in the last 2 days and I couldn't find this thread. I'll go back...
--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)

February 8, 2022 at 8:58 pm

#3981391
Reply To: group records by week

Just curious... I might have missed it in the now 4 pages of post but how many rows per day are you looking to do this 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)

February 8, 2022 at 8:52 pm

#3981389
Reply To: Requirements doc and interviewing development groups

Jason Wilks wrote:
We are trying to get requirements from the development group who has just started programming. We are creating a spreadsheet to send out to all of the dev groups...
--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)

February 8, 2022 at 8:33 pm

#3981385
Reply To: group records by week

Bruin wrote:
I'm not opposed to xp_cmdshell, and was wanting the csv files to be pipe(|) delimited. These 3 files will be used in a P/S import process to SQL as...
--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)

February 8, 2022 at 8:24 pm

#3981381
Reply To: group records by week

Bruin wrote:
It started with grouping records by week to see the amount of data, and once I saw that I needed it to break down by day in 8 hour...
--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)

February 7, 2022 at 8:41 pm

#3981191

Viewing 15 posts - 3,946 through 3,960 (of 59,087 total)