Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,866 through 8,880 (of 59,091 total)

Reply To: Basics to loading data

below86 wrote:
IMHO, you are on the right path. I'm currently doing exactly what you described. Importing flat, delimited files to a 'staging' table where all fields are defined as VARCHAR(500),...
--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 12, 2019 at 4:28 pm

#3670767
Reply To: Backup size is doubled now. Want to know the reason why ??

Jeffrey Williams wrote:
vsamantha35 wrote:
Hi Alex,
Its is a full backup. Don't know the reason why , when backup is in progress , it was showing the backup file size as 822 GB...
--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 12, 2019 at 4:23 pm

#3670764
Reply To: Index rebuild automation on specified tables

Grant Fritchey wrote:
You would be so much better served listening to Jeff and skipping the rebuilding of indexes. Maintaining statistics on indexes is vital, but defragmenting indexes is an idea 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 12, 2019 at 4:20 pm

#3670762
Reply To: Give Up on Natural Primary Keys

ZZartin wrote:
Jeff Moden wrote:
I have a question for all you folks claiming that every table must have a natural key. What would you use for a natural key for either an...
--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 12, 2019 at 3:18 pm

#3670723
Reply To: Give Up on Natural Primary Keys

nova wrote:
Jeff Moden wrote:
I have a question for all you folks claiming that every table must have a natural key. What would you use for a natural key for either an...
--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 12, 2019 at 3:06 pm

#3670721
Reply To: Dynamic SQL for beginners in 33 minutes

I hate these types of things even on YouTube even if it's a worthwhile lesson. The computer generated voice is rather monotonous and makes a lot of mistakes in pronunciation,...
--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 12, 2019 at 12:40 am

#3670577
Reply To: Backup size is doubled now. Want to know the reason why ??

You say it was a BIG prod release... how much of it involved expansion of data and the addition of a lot of indexes, especially clustered indexes and large covering...
--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 11, 2019 at 4:21 pm

#3670551
Reply To: What do bridge tables contain?

Chris Harshman wrote:
Jeff,
That is true, but since the OP explicitly asked about bridge tables in data warehouses, I figured I'd give them the best resources I know of instead of telling...
--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 11, 2019 at 3:47 pm

#3670548
Reply To: Give Up on Natural Primary Keys

I have a question for all you folks claiming that every table must have a natural key. What would you use for a natural key for either an Employee 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)

August 11, 2019 at 2:33 pm

#3670542
Reply To: Give Up on Natural Primary Keys

x wrote:
Otherwise, JSON can provide an adequate data store.
so if we want relational we go with CSV right?

BWAAAA-HAAAA-HAAAA!!!! I blew coffee out of my nose on that one! +1 Billion!!!...
--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 11, 2019 at 2:29 pm

#3670541
Reply To: Are Synonyms Useful?

Robin Wilson wrote:
I pass the name of the server and database to the stored procedure and then use the exec command to execute this as a string then in Visual Studio...
--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 11, 2019 at 2:25 pm

#3670540
Reply To: I Want Certified In Developing SQL Databases Exam

ellalucy wrote:
For me it’s a default task to attempt Developing SQL Databases Exam but now I strongly make my mind to attempt it, I want to pass my exam in...
--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 11, 2019 at 4:17 am

#3670516
Reply To: Index rebuild automation on specified tables

Diyas wrote:
Hi,
i need to automate the index rebuild on specified tables.
1)identify the table which is having more than 30 % ( i need top tables)
2)those tables needs to index rebulid...
--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 11, 2019 at 4:12 am

#3670515
Reply To: What do bridge tables contain?

Good links, Chris. Just to be sure, though, you don't have to have a data warehouse to use "Bridge Tables".
--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 9, 2019 at 7:05 pm

#3670396
Reply To: How to identify if data is skewed in a table

Why did you add the "HAVING"? You need to see it all to actually make a determination.
--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 9, 2019 at 6:29 pm

#3670379

Viewing 15 posts - 8,866 through 8,880 (of 59,091 total)