Jeff Moden

Forum Replies Created

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

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
RE: Display 'blank' cell when it is null.

jcelko212 32090 - Friday, October 19, 2018 7:35 PM
keneangbu - Friday, October 19, 2018 2:03 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 20, 2018 at 6:41 pm

#2010508
RE: Naming Conventions for SQL Server Objects

As for the CMS standards that you provided a link to... there's some good advice here and there in it but, for the most part, BLEAH! Imagine using Hungarian Notation...
--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 1:32 pm

#2010504
RE: Naming Conventions for SQL Server Objects

Heh... maybe "Capitialize() instead of the past tense "capitalized". I also hate the use of all upper case or all lower case for user defined object names, especially in this...
--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 1:08 pm

#2010502
RE: A $3 Billion Donation

Jonathan AC Roberts - Friday, October 19, 2018 4:21 AM
Jeff Moden - Thursday, October 18, 2018 9:32...
--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 19, 2018 at 7:43 am

#2010428

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