Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,951 through 22,965 (of 59,099 total)

RE: Split string to show only customer

dwilliscp (8/13/2014)
Do the strings always end with a dash, space, numeric value?
If so, using the setup from Sean, look at the code for the second column.
declare @Table table (someString varchar(25))
insert...
--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)

August 13, 2014 at 7:44 pm

#1737880
RE: Combine data from historical table

mqbk (8/13/2014)
Recently, I partitioned one of my largest tables into multiple monthly field groups.
Now that you have your answer, I'm curious as the "How" you partitioned the table...
--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)

August 13, 2014 at 7:18 pm

#1737876
RE: Can't find error message when trigger fires

Before we get to your problem, be advised that your trigger is written to handle only one row even if the StateCompletion table is made to suffer an update on...
--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)

August 13, 2014 at 7:03 pm

#1737873
RE: Help with switch partition

N_Muller (8/13/2014)
Jeff Moden (8/13/2014)There's nothing preventing a non-partitioned index from doing this quickly. Index on the event as the lead column and add the partitioning column and it 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)

August 13, 2014 at 6:11 pm

#1737865
RE: Help with switch partition

N_Muller (8/13/2014)
Jeff Moden (8/12/2014)Why is it non-partitioned? Is it because it needs to be truly unique?
Events are received and stored in the partitioned table by date. Most of...
--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)

August 13, 2014 at 11:34 am

#1737731
RE: how to get 00.00 format for percent column

KoldCoffee (8/13/2014)
I have a percent column that displays like this: 0.51%, 0.36%
Desired format: 51.00%, 36.00%
I am using this formula =Format(Fields!CUL1.Value,"F2")
what do I need to change to get the desired format?
Multiply...
--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)

August 13, 2014 at 11:20 am

#1737722
RE: Help with switch partition

N_Muller (8/12/2014)
Thanks - That's what I thought but hoped wasn't the case. Without the non-partitioned index it is very expensive to query for an individual item when we don't know...
--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)

August 12, 2014 at 11:39 pm

#1737437
RE: Clustered index in uniqueidentifiers column

Just some extra info just in case you're thinking about it...
It's not such a hot idea to use a Clustered Index on NEWSEQUENTIALID either. From BOL 2014... (http://msdn.microsoft.com/en-us/library/ms189786.aspx)
Creates 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)

August 12, 2014 at 11:37 pm

#1737436
RE: VARCHAR lat and long data fails when converting to NUMERIC, yet ISNUMERIC never returns 0

It's even "worse" than that, although it works exactly as advertised. Please see the following article.
http://www.sqlservercentral.com/articles/ISNUMERIC()/71512/
--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)

August 12, 2014 at 10:59 pm

#1737432
RE: Get particular day between two dates

Fun problem. Guess I'll throw my hat into the ring, as well.
I took a slightly different tack. Rather than calculating all of the dates in the range and...
--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)

August 12, 2014 at 10:21 pm

#1737422
RE: Row are vanished from Table suddenly in SQL 2008

...and if the target table is designed properly and the trigger is written properly, they can be nasty fast.
--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)

August 12, 2014 at 7:20 pm

#1737408
RE: Rebuild Online Index in Partationed Table

Different file groups aren't so bad. If they're on different files, you might end up with a lot of wasted space, though. When you rebuild an index 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)

August 12, 2014 at 7:06 pm

#1737407
RE: db owner

dan-572483 (8/12/2014)
There is no right or wrong answer to this question.
The advantage of accessing data through storied procedure only include
1) Security. If a user is in db_datareader...
--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)

August 12, 2014 at 6:06 pm

#1737405
RE: Are the posted questions getting worse?

Howz about we just track the buggers down and take them out for a nice pork chop dinner, Moden style? 😛 It might also decrease the surface area of...
--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)

August 12, 2014 at 5:12 pm

#1737395
RE: Inline syntax for indexes

On that note, I do wish that MS had devoted dev time to something more important instead of this "feature".
--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)

August 12, 2014 at 1:43 pm

#1737335

Viewing 15 posts - 22,951 through 22,965 (of 59,099 total)