Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,331 through 15,345 (of 59,063 total)

RE: Database Documention Tool

Grant Fritchey - Friday, March 24, 2017 3:22 PM
Eric M Russell - Friday, March 24, 2017 8:06...
--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)

March 24, 2017 at 3:34 pm

#1934898
RE: Instance is under memory pressure. How to relieve from pressure

SQLRNNR - Friday, March 24, 2017 3:21 PM
I believe the real answer to this question is that the user is running maintenance...
--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)

March 24, 2017 at 3:28 pm

#1934897
RE: Instance is under memory pressure. How to relieve from pressure

Jeff Moden - Friday, March 24, 2017 10:40 AM
coolchaitu - Friday, March 24, 2017 10: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)

March 24, 2017 at 2:53 pm

#1934880
RE: Instance is under memory pressure. How to relieve from pressure

coolchaitu - Friday, March 24, 2017 10:07 AM
Instance is under memory pressure. How to relieve it from pressure
The two most common causes...
--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)

March 24, 2017 at 10:40 am

#1934829
RE: Are the posted questions getting worse?

jasona.work - Friday, March 24, 2017 10:16 AM
Ah, the urge to post a snarky response to a poorly posed question...
"Question": "Instance 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)

March 24, 2017 at 10:26 am

#1934819
RE: Execution Plan Training Suggestions

The problem that you may be having is that you "thumbed through" Grant's books. If you do a deep study of his books, everything you ask for will become self...
--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)

March 24, 2017 at 8:13 am

#1934765
RE: sp_send_dbmail executes query but not sending the email - error

Very cool feedback. Thanks for taking the time. I would never have come up with that because I thought you were operating with a "sysadmin" privs. Bad assumption on my...
--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)

March 24, 2017 at 7:36 am

#1934749
RE: Change Approvals

mike.mcquillan - Friday, March 24, 2017 2:52 AM
I 100% agree with Jeff...nobody should deploy their own code.
Sadly, the reality I've encountered is...
--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)

March 24, 2017 at 7:31 am

#1934746
RE: row size exceeds the maximum 8060

Sergiy - Friday, March 24, 2017 2:54 AM
sqlfriends - Wednesday, March 22, 2017 7:42 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)

March 24, 2017 at 7:13 am

#1934739
RE: Change Approvals

We have a standard... no one promotes their own code... period.
We also have another standard that identifies the development, testing, and production deployment processes including peer review, QA...
--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)

March 23, 2017 at 11:58 pm

#1934686
RE: dbcc shrinkfile()

frederico_fonseca - Thursday, March 23, 2017 6:32 PM
Something like this.

declare @sql nvarchar(300)
declare @shrink_step int = 20000 -- size in MB to reduce
declare...
--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)

March 23, 2017 at 11:50 pm

#1934685
RE: sp_send_dbmail executes query but not sending the email - error

Again, I have to comment out the profile and use my default profile but when I change the email address to my own, I get the expected email with 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)

March 23, 2017 at 11:40 pm

#1934683
RE: sp_send_dbmail executes query but not sending the email - error

Not sure what's wrong. After changing the email to my email and commenting out the profile (I just use the default), it worked exactly as expected.
Hmmm... maybe 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)

March 23, 2017 at 8:26 pm

#1934678
RE: row size exceeds the maximum 8060

According to the documentation, you don't need to do both and either will work. If you're going to rebuild indexes (the Clustered Index would be most important here) anyway, then...
--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)

March 23, 2017 at 7:52 pm

#1934677
RE: Find UDF useage

Jim Youmans-439383 - Thursday, March 23, 2017 6:13 AM
While I agree with you in general, in my case the Scalar UDF was...
--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)

March 23, 2017 at 1:36 pm

#1934646

Viewing 15 posts - 15,331 through 15,345 (of 59,063 total)