Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,696 through 13,710 (of 59,095 total)

RE: GRANT UNMASK ON SCHEMA?

Write a stored procedure that runs with EXECUTE as DBO and only give that user privs to run 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)

November 16, 2017 at 9:16 pm

#1968455
RE: Implications of slower writes with 64K pages using SSDs vs SAN

NJ-DBA - Thursday, November 16, 2017 8:36 AM
We have some real problem tables - in every variety... lots of records of large...
--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 5:13 pm

#1968452
RE: Trying to convert a int @variable to a varchar @variable with leading zero.

ScottPletcher - Thursday, November 16, 2017 11:41 AM
drew.allen - Thursday, November 16, 2017 11: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)

November 16, 2017 at 4:41 pm

#1968449
RE: Trying to convert a int @variable to a varchar @variable with leading zero.

drew.allen - Thursday, November 16, 2017 11:30 AM
ScottPletcher - Thursday, November 16, 2017 10:47 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 16, 2017 at 4:34 pm

#1968447
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor - Thursday, November 16, 2017 7:58 AM
Sioban Krzywicki - Wednesday, November 15,...
--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 8:22 am

#1968377
RE: Are the posted questions getting worse?

Thom A - Thursday, November 16, 2017 8:16 AM
Jack Corbett - Thursday, November 16, 2017...
--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 8:19 am

#1968376
RE: Implications of slower writes with 64K pages using SSDs vs SAN

NJ-DBA - Tuesday, November 14, 2017 10:27 AM
These are interesting points... It is definitely possible that we are seeing SAN caching ruining...
--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 8:18 am

#1968374
RE: Trying to convert a int @variable to a varchar @variable with leading zero.

Jocar26 - Thursday, November 16, 2017 7:50 AM
Thanks Luis. I am an advance beginner, so please explain the improvement 8-).
(Updated) Is 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)

November 16, 2017 at 7:59 am

#1968367
RE: Start Fixing Your DB with Better Code

roger.plowman - Thursday, November 16, 2017 7:31 AM
Oooh, you just hit my berserk button. 🙂
First, the initial problem is at the student...
--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 7:50 am

#1968357
RE: Start Fixing Your DB with Better Code

RonKyle - Thursday, November 16, 2017 7:27 AM
No-one sets out to do a crap job. Most people want to do...
--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 7:40 am

#1968351
RE: Start Fixing Your DB with Better Code

cmick 77911 - Thursday, November 16, 2017 7:19 AM
But how do you know if your code is right or wrong when 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 16, 2017 at 7:30 am

#1968345
RE: Interesting Datenames

Jason A. Long - Wednesday, November 15, 2017 4:33 PM
Jeff Moden - Wednesday, November 15, 2017 3:20...
--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 15, 2017 at 11:35 pm

#1968316
RE: Trying to convert a int @variable to a varchar @variable with leading zero.

Jocar26 - Wednesday, November 15, 2017 8:38 PM
I am trying to create a text variable called @varnumber with a leading zero for...
--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 15, 2017 at 10:19 pm

#1968314
RE: Start Fixing Your DB with Better Code

If you know the product you're working with, you will always save some time doing it right the first time. If you don't know the product you're working with VERY...
--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 15, 2017 at 10:12 pm

#1968313
RE: Are the posted questions getting worse?

Sioban Krzywicki - Wednesday, November 15, 2017 1:25 PM
They say it is scalability and rapid development.
I believe it is because someone heard...
--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 15, 2017 at 9:43 pm

#1968312

Viewing 15 posts - 13,696 through 13,710 (of 59,095 total)