Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,936 through 22,950 (of 59,102 total)

RE: Alerting when tempdb files have X% free space

Jay@Work (8/14/2014)
Thanks Jeff.
Have your tempDB files ever had to autogrow or were they created with an initial size large enough that this hasn't been necessary?
Our Sharepoint consultants advised the 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 10:06 pm

#1738277
RE: query with several joins fills up tempdb and won't finish

NoDBA (8/14/2014)
Since this report is only for testing purposes as of now, that suffices.
Possibly not. It may actually be that the query never got to the ORDER BY. ...
--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:45 pm

#1738251
RE: Assign Row number to the result set without using Row_Number

Indu-649576 (8/14/2014)
Hi,
Is there any other way to assign row number to the result set with out using Row_Number/rank/Dense rank functions or loops?
Thanks,
Indu
Yes... there is. How many rows 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)

August 14, 2014 at 6:38 pm

#1738248
RE: Disable and Enable Constraints in a Table in SQL Server

Mr. Kapsicum (8/14/2014)
Hi All,
I have a Table, on which i am performing Bulk Insert Operations. For This,
i am First Disabling Constraints on that table and After Insert Operation , i...
--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:25 pm

#1738247
RE: SQL Query to find all the employee whose salary sum is 80% of sum of salary of all employee.

akash_singh (8/14/2014)
Let us assume that there are 100 employee in a company. And sum of salary of all employee is 10000. Find list of highest paid employees whose sum 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 14, 2014 at 6:22 pm

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

Viewing 15 posts - 22,936 through 22,950 (of 59,102 total)