Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,376 through 15,390 (of 59,101 total)

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
RE: column collation - the mystery of it all ?

To be honest, I don't know the answer to your latest question. I have a difficult enough time even getting people to use CR/LF symbols consistently for imports.
--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:26 pm

#1934643
RE: row size exceeds the maximum 8060

sqlfriends - Thursday, March 23, 2017 12:19 PM
Also we do added some columns recently and dropped some. Is there a way 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)

March 23, 2017 at 1:17 pm

#1934641
RE: Comparing Space Usage for Different Compression Types

Good summary. Thanks for taking the time to do the experiments and to write up your conclusions.
Shifting gears a bit, I can't speak for anyone else but 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)

March 23, 2017 at 7:36 am

#1934508
RE: Missing index with change impact percentage

kumar.bhupendra - Wednesday, March 22, 2017 8:17 PM
Hi Aruna,
I am very new to Database, can u tell me how to run 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)

March 22, 2017 at 11:20 pm

#1934442
RE: row size exceeds the maximum 8060

Gosh... sounds odd. The only way I can see this happening is if there are enough fixed length columns to push you over the 8060 limit. Varchars will go "out...
--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 22, 2017 at 11:16 pm

#1934441
RE: Hierarchy without cursor/loop

If you want to go whole hog on hierarchies, see the following articles
http://www.sqlservercentral.com/articles/Hierarchy/94040/
http://www.sqlservercentral.com/articles/T-SQL/94570/
--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 22, 2017 at 10:51 pm

#1934438
RE: column collation - the mystery of it all ?

szejiekoh - Wednesday, March 22, 2017 10:30 AM
Jeff Moden - Sunday, March 19, 2017 1:53 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 22, 2017 at 10:34 pm

#1934437

Viewing 15 posts - 15,376 through 15,390 (of 59,101 total)