Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,861 through 10,875 (of 59,099 total)

RE: Naming Conventions for SQL Server Objects

Jonathan AC Roberts - Monday, October 22, 2018 10:06 AM
David Walker-278941 - Monday, October 22, 2018 8:47...
--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)

October 22, 2018 at 11:16 am

#2010647
RE: Strategy advice for storing Personal Identifiable Information

It's not that easy. You have to understand the whole gambit of things including the real meaning of protecting data at rest as well as encryption of the sensitive columns...
--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)

October 22, 2018 at 9:06 am

#2010598
RE: The best Book to learn ADF

Grant Fritchey - Monday, October 22, 2018 6:41 AM
There are exceedingly few books on any topic in Azure because it moves too...
--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)

October 22, 2018 at 7:16 am

#2010572
RE: Anyone see a problem with this?

Sergiy - Monday, October 22, 2018 5:08 AM
Jeff Moden - Monday, October 22, 2018 4:44 AM
--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)

October 22, 2018 at 6:41 am

#2010564
RE: Find tables with records in multible DB's

p.s. Eirikur has the beginning of the code with his reference to sys.databases.
--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)

October 22, 2018 at 4:57 am

#2010547
RE: Find tables with records in multible DB's

Edvard KorsbÃ¦k - Monday, October 22, 2018 4:37 AM
"Which is one of the reasons why I suggested a "partitioned view","
I must admit,...
--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)

October 22, 2018 at 4:53 am

#2010546
RE: Anyone see a problem with this?

Sergiy - Sunday, October 21, 2018 8:06 PM
Jeff Moden - Sunday, October 21, 2018 11:18 AM
--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)

October 22, 2018 at 4:44 am

#2010544
RE: relational calculus

spectra - Sunday, October 21, 2018 9:33 PM
I'm solving a problem using tuple relational calculus ( TRC) in DBMS.
Problem
Find the name 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)

October 22, 2018 at 4:37 am

#2010543
RE: Find tables with records in multible DB's

Edvard KorsbÃ¦k - Monday, October 22, 2018 3:25 AM
This gave a lot of errors, but works:
Create Table ##temp_fbl
(
DBName nvarchar(200),
...
--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)

October 22, 2018 at 4:14 am

#2010541
RE: SQL 2017 Batch insert performance degradation

frederico_fonseca - Sunday, October 21, 2018 2:00 PM
Jeff Moden - Sunday, October 21, 2018 1:21 PM
--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)

October 21, 2018 at 4:25 pm

#2010527
RE: SQL 2017 Batch insert performance degradation

MadOwl - Sunday, October 21, 2018 7:27 AM
Issue is somewhat resolved. There seems to be bug in how pyodbc handles duplicate primary...
--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)

October 21, 2018 at 1:21 pm

#2010523
RE: Find tables with records in multible DB's

I've used simple partitioned views for such things in the past. You can sometimes even get away with NOT creating a partitioning constraint if you don't mind not using 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)

October 21, 2018 at 1:19 pm

#2010522
RE: How to store output of SQL Server Stored Procedure in a .txt file

vikasjagadale8 - Sunday, October 21, 2018 9:59 AM
I have below SP I am printing the value of the variable in S.S.M.S....
--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)

October 21, 2018 at 1:14 pm

#2010521
RE: Anyone see a problem with this?

Sergiy,
Just so you know, please see the following.
https://www.sqlservercentral.com/Forums/FindPost2003341.aspx
--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)

October 21, 2018 at 11:18 am

#2010520
RE: Display 'blank' cell when it is null.

keneangbu - Friday, October 19, 2018 2:03 PM
The data type of the column is decimal(9,2). I wanted an empty cell 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)

October 20, 2018 at 6:51 pm

#2010509

Viewing 15 posts - 10,861 through 10,875 (of 59,099 total)