Jeff Moden

Forum Replies Created

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

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
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

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