Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,136 through 21,150 (of 59,072 total)

RE: Generate the results in Yellow

SQL-DBA-01 (3/27/2015)
I have managed to fix this.
Please share what you did. Thanks.
--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 27, 2015 at 3:06 pm

#1787043
RE: Are the posted questions getting worse?

SQLRNNR (3/27/2015)
Did you guys hear about this awesome new feature in SQL Server called indexed views? It is so awesome that you can create 999 indexes on a view...
--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 27, 2015 at 12:48 pm

#1787019
RE: Are the posted questions getting worse?

Luis Cazares (3/27/2015)
Ed Wagner (3/27/2015)
Sean Lange (3/27/2015)
Luis Cazares (3/27/2015)
In a different order of ideas, I want to share with you my happiness.
Starting on April 21st I'll be working in 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 27, 2015 at 11:33 am

#1787005
RE: Update Quantities over multiple records

I'm going to recommend incredible caution here. Even Itzik said it wasn't optimized in his original post.
Internally, this as bad as a double cross join because 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)

March 26, 2015 at 10:25 pm

#1786738
RE: Partition for a particular value and not

1. Is any of that data ever updated once it's been inserted into the table? If so, what is updated column-wise?
2. What are the current indexes that you have...
--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 26, 2015 at 9:29 pm

#1786735
RE: Employee status on first and last day of a pay period

Dave-3000 (3/26/2015)
I am having a problem getting started on this problem, and I'm hoping someone has solved something similar and can guide me.
I have a requirement in a...
--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 26, 2015 at 9:11 pm

#1786734
RE: REPLACE Multiple Spaces with One

I believe that the reasons for that are many...
1. It's a scalar UDF.
2. It does calculations instead of using constants.
3. It doesn't take advantage of nested replaces.
4....
--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 26, 2015 at 8:32 pm

#1786733
RE: Grant DROP table permission to SQL id

Create a stored proc to with constraints to limit what someone can drop. Add EXECUTE AS OWNER to the proc and then give the user permissions just to run...
--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 26, 2015 at 8:20 pm

#1786728
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

My recommendation would be to do those kinds of checks externally rather than adding them to the function. Changes for convenience will slow things down when it's not convenient....
--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 26, 2015 at 6:32 pm

#1786724
RE: What would Fill Factor Do?

PHYData DBA (3/26/2015)
To anyone reading this thread. I know we went Off Topic there for a long period.
It seemed like an important subject and one I had...
--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 26, 2015 at 3:42 pm

#1786707
RE: Today's Random Word!

Eirikur Eiriksson (3/26/2015)
crookj (3/26/2015)
Eirikur Eiriksson (3/26/2015)
djj (3/26/2015)
Ed Wagner (3/26/2015)
SQLRNNR (3/26/2015)
djj (3/26/2015)
SQLRNNR (3/26/2015)
pursuit
Hot
blooded
Anger
Management
Board
Game
Theory
Practice
--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 26, 2015 at 1:29 pm

#1786670
RE: What would Fill Factor Do?

PHYData DBA (3/26/2015)
Jeff Moden (3/24/2015)
As for the padding thing in the BTREE, that's done during an index rebuild using the "WITH PADDING" option. Note that it will not...
--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 26, 2015 at 1:28 pm

#1786669
RE: The Worst Comments

dwain.c (3/26/2015)
Gary Varga (3/26/2015)
dwain.c (3/25/2015)
...I beginning to think that when I wrote this article (based on a quotation from Jeff):
Make it Work, Make it Fast, Make it Pretty[/url]
Maybe I should...
--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 26, 2015 at 8:25 am

#1786568
RE: System DMV's Cause Blocking

lmarkum (3/25/2015)
Jeff, I have been told that querying such DMV's caused an issue in a production environment and so there is now caution about such queries.
Understood. 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)

March 25, 2015 at 10:17 pm

#1786455
RE: Doubt about logic in T-SQL

dwain.c (3/25/2015)
Jeff Moden (3/24/2015)
Will there only ever be two "id_fixing" values? If not, how many are there or could be?
I hate it when you ask questions like 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)

March 25, 2015 at 10:08 pm

#1786454

Viewing 15 posts - 21,136 through 21,150 (of 59,072 total)