Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,916 through 9,930 (of 59,099 total)

RE: Database has no owner

Andrew_Robertson - Tuesday, January 29, 2019 8:25 PM
I have gone into the properties of a couple of databases and noticed that under...
--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)

January 29, 2019 at 8:53 pm

#2020510
RE: Why doesn't a stored procedure prompt a user to enter parameters when parameters have been defined in the stored procedure?

michael.leach2015 - Tuesday, January 29, 2019 8:29 PM
Lynn Pettis - Tuesday, January 29, 2019 5:11 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)

January 29, 2019 at 8:50 pm

#2020509
RE: Versatile or Jack of all trades

TomThomson - Tuesday, January 22, 2019 12:19 PM
Jeff Moden - Tuesday, January 22, 2019 11:02 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)

January 29, 2019 at 7:53 pm

#2020503
RE: SQL agent job running status

sqlfriends - Tuesday, January 29, 2019 4:24 PM
I am running the SQL job, there is a pop up window telling me 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)

January 29, 2019 at 7:48 pm

#2020502
RE: Coding for Failure? Or Just Planning for Issues?

I agree with what the others have said but I just call it "Bullet-Proofing".
--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)

January 29, 2019 at 7:40 pm

#2020501
RE: Question on Grouping -Working number of days

To emphasize the problem that Drew brings up...
First_Value can certainly used to solve the given problem but it won't correctly solve the problem that will occur if there'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)

January 29, 2019 at 7:24 pm

#2020498
RE: Stop rolling back transaction

SQL_Hunt - Tuesday, January 29, 2019 5:18 PM
Hello, I want to delete records from multiple records (very old records and does not...
--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)

January 29, 2019 at 6:56 pm

#2020497
RE: Purpose of SELECT before a calcuating the value of a function's return variable

michael.leach2015 - Tuesday, January 29, 2019 6:05 PM
In the code below what is the purpose of the SELECT statement before @SalesTaxDue...
--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)

January 29, 2019 at 6:53 pm

#2020496
RE: Doing the Right Thing

patrickmcginnis59 10839 - Tuesday, January 29, 2019 10:10 AM
Jeff Moden - Tuesday, January 29, 2019 9:07 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)

January 29, 2019 at 10:12 am

#2020457
RE: Doing the Right Thing

patrickmcginnis59 10839 - Tuesday, January 29, 2019 8:10 AM
Jeff Moden - Tuesday, January 29, 2019 7:09 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)

January 29, 2019 at 9:07 am

#2020431
RE: storing Image in Database (SQL Server ) vs File System

To be absolutely honest and, hopefully, a bit more clear (I DO use DBCC CHECKDB but not in production and I don't time it) , nothing is a full up substitute...
--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)

January 29, 2019 at 8:27 am

#2020420
RE: Doing the Right Thing

patrickmcginnis59 10839 - Monday, January 28, 2019 12:57 PM
Jeff Moden - Monday, January 28, 2019 9:30 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)

January 29, 2019 at 7:09 am

#2020403
RE: Dynamically outputting a set of columns based on another Tables records

Thom A - Monday, January 28, 2019 4:47 AM
Weegee2017 - Monday, January 28, 2019 4:31 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)

January 29, 2019 at 6:08 am

#2020391
RE: Today's Random Word!

Ed Wagner - Monday, January 28, 2019 11:28 AM
TomThomson - Saturday, January 26, 2019 4:49 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)

January 28, 2019 at 12:49 pm

#2020322
RE: storing Image in Database (SQL Server ) vs File System

An example of the above... I ran DBCC CHECKDB WITH ESTIMATEONLY on one of my databases that has no "images" stored. The MDF file is only 900GB and there's 150GB...
--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)

January 28, 2019 at 12:16 pm

#2020321

Viewing 15 posts - 9,916 through 9,930 (of 59,099 total)