Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,681 through 13,695 (of 59,095 total)

RE: Automatic Plan Correction

As always, great article with working examples! Thanks for taking the time to post it Wayne.
--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)

November 18, 2017 at 7:06 pm

#1968657
RE: Creating a PDF from a Stored Procedure

jairamkumar01 - Friday, November 17, 2017 11:07 PM
There are following requirement:
1- Text Formatting in some place like bold , underline
2- Some dynamic data...
--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)

November 18, 2017 at 9:47 am

#1968644
RE: 0 or $0.00 instead of NULL?

Jason A. Long - Friday, November 17, 2017 8:02 PM
Jeff Moden - Friday, November 17, 2017 5: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)

November 17, 2017 at 9:08 pm

#1968625
RE: Query to find what current query the procedure is executing.

adilahmed1989 - Friday, November 17, 2017 3:25 AM
Dear All,
Have a job on a server in which it executes a stored procedure that...
--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)

November 17, 2017 at 5:52 pm

#1968620
RE: 0 or $0.00 instead of NULL?

chef423 - Friday, November 17, 2017 10:22 AM
Thom A - Friday, November 17, 2017 10: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)

November 17, 2017 at 5:47 pm

#1968619
RE: One of my sql database

Heh... I've seen this post before. Stand by for the SPAM folks. 😉
--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)

November 17, 2017 at 5:24 pm

#1968616
RE: Auto Generate Your Database Documentation

Andy Jones, DBA - Friday, November 17, 2017 3:52 PM
Jeff Moden - Friday, November 17, 2017 8:18...
--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)

November 17, 2017 at 5:23 pm

#1968615
RE: Start Fixing Your DB with Better Code

Eric M Russell - Friday, November 17, 2017 8:13 AM
Jeff Moden - Friday, November 17, 2017 7:46...
--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)

November 17, 2017 at 8:27 am

#1968536
RE: Auto Generate Your Database Documentation

The code for the auto-generation of extended properties in this article seems to be just a regurgitation of properties that should be listed elsewhere. It doesn't explain the purpose of 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)

November 17, 2017 at 8:18 am

#1968532
RE: GRANT UNMASK ON SCHEMA?

Kaye Cahs - Friday, November 17, 2017 7:15 AM
Thanks for the comments, everybody.
@jeff Moden, I agree with your comment about masking versus...
--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)

November 17, 2017 at 7:56 am

#1968529
RE: Log file R drive- What is consuming it

coolchaitu - Friday, November 17, 2017 12:07 AM
Jeff Moden - Thursday, November 16, 2017 10:16 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)

November 17, 2017 at 7:52 am

#1968527
RE: Start Fixing Your DB with Better Code

Aaron N. Cutshall - Friday, November 17, 2017 7:10 AM
In one case the application executed queries against the database that were...
--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)

November 17, 2017 at 7:46 am

#1968525
RE: Log file R drive- What is consuming it

coolchaitu - Thursday, November 16, 2017 10:01 PM
Good Morning Experts.
We have a SQL Server instance. All the user databases log files...
--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)

November 16, 2017 at 10:16 pm

#1968459
RE: GRANT UNMASK ON SCHEMA?

As a bit of a sidebar, I think your use of masking is a bit out of line. A relatively unprivileged user can easily break it without much effort or...
--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)

November 16, 2017 at 9:34 pm

#1968457
RE: SOS

I think Microsoft is trying to win over front end Developers to try to win the war against some of the NOSQL stuff out there. The term "SOS" might actually...
--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)

November 16, 2017 at 9:31 pm

#1968456

Viewing 15 posts - 13,681 through 13,695 (of 59,095 total)