Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,881 through 8,895 (of 59,099 total)

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
Reply To: Monitoring SQL Server

Admingod wrote:
Due to some limitations we may have to monitor all of our sql servers with two different monitoring tools. Would that we bad idea and what other issues i...
--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:27 pm

#3670377
Reply To: Modern Datatime Addition

Ray Herring wrote:
So Jeff, do you have an opinion on Datatime addition ?
Heh... ya think? 😉
--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:18 pm

#3670374
Reply To: Dual Duplicates redress.

If you would post your data in a readily consumable format, I'm sure someone would jump on this problem and provide a correct solution in about two heart beats. Please...
--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 3:42 pm

#3670337
Reply To: How to preapare Vintage Analysis report in sql

avdhut.k wrote:
Can someone help me with code.
Not likely. First, most people won't open a spreadsheet on forums. Second, the spreadsheet contains no formulas so there's no information in it 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)

August 9, 2019 at 3:15 pm

#3670323
Reply To: Basics to loading data

p.s. And welcome to SQLServerCentral.com!
--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 2:58 pm

#3670318
Reply To: Basics to loading data

You usually don't need the likes of SSIS. Many will disagree with me on this but I consider SSIS to be an unnecessary added layer (less politically correct: an unnecessary...
--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 2:53 pm

#3670316
Reply To: What do bridge tables contain?

To emphasize the lesson that John Mitchell is trying to teach, become independent and don't limit yourself to "just" the answers you might get on a forum. Try his searches...
--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 2:38 pm

#3670303

Viewing 15 posts - 8,881 through 8,895 (of 59,099 total)