Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,166 through 21,180 (of 59,098 total)

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
RE: System DMV's Cause Blocking

No. But now I'm curious about why you ask. Have you seen such a thing or are you "just" concerned?
--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 5:37 pm

#1786442
RE: What would Fill Factor Do?

Wayne West (3/25/2015)
PHYData DBA (3/24/2015)
... Also they seem to see this as a "Magic Bullet" to resolve not a performance issue, but and issue with increase in Table space.
This 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 25, 2015 at 5:35 pm

#1786440
RE: BUILTIN\Administrators login doesn't appear to be working.

nitefalll (3/25/2015)
First let me say I'm a huge fan of Lowell.
We attempted to add a new administrator to a 2012 box like we've done before with 2008R2 and previous....
--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 5:33 pm

#1786439
RE: Want to return character(s) after a dash (-)

ScottPletcher (3/25/2015)
You can specify a longer length on the SUBSTRING and it won't hurt anything, so you skip calculating the length; for example:
SELECT SUBSTRING(string_value, CHARINDEX('-', string_value) + 1, 100)
+100
--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 4:28 pm

#1786433

Viewing 15 posts - 21,166 through 21,180 (of 59,098 total)