Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,766 through 9,780 (of 59,091 total)

RE: SQL Server Database Administrator Interview Questions

Brandie Tarvin - Monday, February 25, 2019 4:58 AM
On the other hand....
What is a Null Value?
This one brings back memories. Specifically...
--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 25, 2019 at 6:58 am

#2022824
RE: DB design thoughts

Jay@Work - Sunday, February 24, 2019 3:47 PM
This is more of a question around DB design as opposed to DML so hopefully...
--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 24, 2019 at 6:49 pm

#2022786
RE: Group by companyid with Latest date

jcelko212 32090 - Sunday, February 24, 2019 1:25 PM
kbhanu15 - Wednesday, February 20, 2019 9:13 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)

February 24, 2019 at 5:18 pm

#2022784
RE: The SQL Saturday Thread

robert.sterbal 56890 - Friday, February 22, 2019 11:45 AM
Jeff Moden -...
--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 24, 2019 at 8:22 am

#2022765
RE: date formats

Sue_H - Friday, February 22, 2019 11:52 AM
Jeff Moden - Friday, February 22, 2019 11:32 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)

February 23, 2019 at 7:22 pm

#2022752
RE: date formats

ZZartin - Friday, February 22, 2019 11:56 AM
Jeff Moden - Friday, February 22, 2019 11:32 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)

February 23, 2019 at 7:19 pm

#2022751
RE: date formats

mtz676 - Wednesday, July 25, 2018 4:09 AM
((Get-Date).AddMonths(1))
gives me
Saturday, August 25, 2018 3:06:26 AM
(Get-Date -format 'Y')
gives me
July, 2018
How do 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)

February 22, 2019 at 11:32 am

#2022679
RE: The SQL Saturday Thread

I guess a whole lot of people like dashboards (and monitoring systems, for that matter) for such things. I'm not one of them. Some show too much and some show...
--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 22, 2019 at 11:28 am

#2022678
RE: Failed to initialize sqlcmd library with error number -2147467259

You might have better luck getting an answer if you did the translation to English.
--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 20, 2019 at 8:31 am

#2022483
RE: Using Dynamic SQL to create a list

I don't understand why you simply don't validate the data before you concatenate it.
--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 20, 2019 at 7:01 am

#2022470
RE: The SQL Saturday Thread

Ray K - Tuesday, February 19, 2019 8:24 AM
Ed Wagner - Tuesday, February 19, 2019 8:19 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)

February 20, 2019 at 6:22 am

#2022469
RE: Find text in sql modules

Peter Shilovich - Wednesday, February 20, 2019 3:06 AM
tamirgerber - Wednesday, February 20, 2019 2:05 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)

February 20, 2019 at 6:12 am

#2022468
RE: Find text in sql modules

tamirgerber - Wednesday, February 20, 2019 2:05 AM
Jeff Moden - Tuesday, February 19, 2019 9:58 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)

February 20, 2019 at 6:10 am

#2022467
RE: Find text in sql modules

tamirgerber - Tuesday, February 19, 2019 6:51 PM
One could use sp_msForEachDB builtin stored procedure. No cursor, no loop, and less chance 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)

February 19, 2019 at 9:58 pm

#2022449
RE: Diskspace requirement for 1M records

DBA_007 - Tuesday, February 19, 2019 12:58 PM
Thanks all,Can you explain with an example
--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 19, 2019 at 9:14 pm

#2022447

Viewing 15 posts - 9,766 through 9,780 (of 59,091 total)