Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,906 through 22,920 (of 59,067 total)

RE: Timeout expired. The timeout period elapsed

I've found that really poor indexes will also cause frequent and, sometimes, massive timeouts on the application side. If the application is doing inserts into a table that has...
--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 14, 2014 at 6:13 pm

#1738244
RE: Alerting when tempdb files have X% free space

Jay@Work (8/13/2014)
I have a tempdb split into 4 files (5 if you include the log).
Autogrowth is disabled on the mdf/ndf files so that they can be used round robin (1...
--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 14, 2014 at 6:07 pm

#1738243
RE: Split string to show only customer

Lynn Pettis (8/14/2014)
Jeff Moden (8/14/2014)
dwilliscp (8/14/2014)
Jeff Moden (8/13/2014)
Thanks, Lynn. I read the original post incorrectly and didn't run your code to see. Thanks for the correction.
I must admit,...
--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 14, 2014 at 6:01 pm

#1738242
RE: trigger with text type

Sean Lange (8/14/2014)
tcronin 95651 (8/14/2014)
sorry but that is the real world, that's why I referenced 3rd party app, which rhymes with 3rd party c&#*#rap. Cant change
LOL. Why can't you...
--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 14, 2014 at 11:25 am

#1738147
RE: Synonyms versus Partitioning for daily load?

@SixStringSQL (8/14/2014)
Thanks for the replies, all...
Question: Is there no benefit of using synonyms over renaming the base tables themselves?
I like Synonyms for this type of thing for several reasons....
--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 14, 2014 at 8:15 am

#1738057
RE: Combine data from historical table

mqbk (8/14/2014)
Yeah I was just wondering if a cte could be used to improve the performance, but I see the census is that it will have no added value; therefore,...
--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 14, 2014 at 7:31 am

#1738029
RE: Split string to show only customer

dwilliscp (8/14/2014)
Jeff Moden (8/13/2014)
Thanks, Lynn. I read the original post incorrectly and didn't run your code to see. Thanks for the correction.
I must admit, I'm totally confused. ...
--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 14, 2014 at 7:28 am

#1738026
RE: Writing a new insert procedure

austen.robinson (8/13/2014)
I have the following two tables:
CREATE TABLE eventhistory (
Event_id number not null,
Event_Description varchar2(100),
Update_time date not null
);
CREATE TABLE currentevents (
Event_id number not null,
Event_Description varchar2(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)

August 13, 2014 at 9:05 pm

#1737895
RE: Split string to show only customer

Thanks, Lynn. I read the original post incorrectly and didn't run your code to see. Thanks for the correction.
I must admit, I'm totally confused. If the purpose...
--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 8:37 pm

#1737891
RE: How to prevent database access

As a bit of a sidebar, I'm always amazed at questions like this. Why is it that so many people don't trust the people they specifically hired to be...
--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 8:30 pm

#1737889
RE: Conflist between collations

If you run the following code...
sp_help 'sys.objects'
... and look at the "Collation" column has in it, you'll see why the problem exists. You'll need to use the COLLATE clause...
--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 8:22 pm

#1737888
RE: Rebuild Online Index in Partationed Table

pawana.paul (8/13/2014)
Hello Ed,
Looks like this session is to attend inperson. Is it available online by any chance?
Regards,
Attending in person would be seriously beneficial, but it's not necessary. I just...
--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 8:14 pm

#1737886
RE: Rebuild Online Index in Partationed Table

pawana.paul (8/12/2014)
Thank you so very much Jeff. This info. helps.
Is it possible to share 2 hours lecture you written on this topic? Please send me on pawana.paul@gmail.com, if possible.
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)

August 13, 2014 at 8:11 pm

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

Viewing 15 posts - 22,906 through 22,920 (of 59,067 total)