Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,046 through 21,060 (of 59,072 total)

RE: Today's Random Word!

Eirikur Eiriksson (4/13/2015)
djj (4/13/2015)
Revenant (4/13/2015)
Ed Wagner (4/13/2015)
whereisSQL? (4/13/2015)
Ed Wagner (4/13/2015)
eccentricDBA (4/13/2015)
Ed Wagner (4/13/2015)
crookj (4/13/2015)
djj (4/13/2015)
Eirikur Eiriksson (4/13/2015)
Ed Wagner (4/13/2015)
djj (4/13/2015)
Ed Wagner (4/13/2015)
BWFC (4/13/2015)
Bunny
Bugs
Fudd
Duck
l'orange
Dinner
Brunch
Fun Cooking
gourmandize
Gourmet
Foodie
Taste
Refined
Silver
Lining
Red
--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)

April 13, 2015 at 7:22 pm

#1790652
RE: how to track SP's to tempdb usage

Brandie Tarvin (4/13/2015)
edyeh (4/13/2015)
I did an analysis showing procs that use high I/O and cpu resources, but I'd like to isolate the procs using the tempDB the most without going...
--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)

April 13, 2015 at 7:19 pm

#1790651
RE: excel destination and sum

This post is nearly two weeks old and, up to this instant, you don't have an answer even though it's for an incredibly simple problem. Before you post again,...
--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)

April 13, 2015 at 7:08 pm

#1790650
RE: how to track SP's to tempdb usage

edyeh (4/12/2015)
it's pretty much a single purpose database and it has crazy numbers on the write waits on the tempdb and high workfile numbers.
ed
Understood. My next question is why...
--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)

April 12, 2015 at 8:35 pm

#1790417
RE: Today's Random Word!

TomThomson (4/12/2015)
Revenant (4/10/2015)
Eirikur Eiriksson (4/10/2015)
SQLRNNR (4/10/2015)
vitriol
corrosion
rust
oxidation
reduction
--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)

April 12, 2015 at 8:29 pm

#1790416
RE: Today's Random Word!

Eirikur Eiriksson (4/10/2015)
Ed Wagner (4/10/2015)
Jeff Moden (4/9/2015)
Ed Wagner (4/9/2015)
SQLRNNR (4/9/2015)
@##$@&*&%#@
WTF
Peer Review
Improvement
Refactoring
Mentoring
--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)

April 12, 2015 at 7:22 pm

#1790414
RE: how to track SP's to tempdb usage

edyeh (4/10/2015)
Hello Forum,
We have a busy system, and the developers have fallen in love with temporary tables.
Too much love....
I have to ask what makes you think so and what type...
--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)

April 12, 2015 at 7:18 pm

#1790413
RE: Department Hierarchy

Borrowing on Eirikur's test data, the Hierarchical Path and the hLevel can be used to format the output a bit (look at the Dept_Name column) and sort the hierarchy...
--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)

April 12, 2015 at 12:41 pm

#1790400
RE: how to decide how many number of col in a table can be made, keeping 8kb lenght to speed up.

Although not always (For example, Call Detail Records from telephone companies), I've found that most very wide tables are wide simply because they're not designed/normalized properly. If it were...
--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)

April 12, 2015 at 11:45 am

#1790396
RE: Non-Printable Character Detection

Ah crud. More coffee please. Thanks for the correction, Eirikur. You're absolutely correct about the dash.
That also adds more functionality to the COLLATE because it will find...
--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)

April 11, 2015 at 9:36 pm

#1790370
RE: Non-Printable Character Detection

robertharrison (3/25/2015)
The following was found as a solution to detecting non-printable characters in a string. I can find no explanation of how the COLLATE function is used.
Can someone explain...
--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)

April 11, 2015 at 1:32 pm

#1790360
RE: SSIS 2012 - How to add too many columns roughly 345 as output columns for Script Component.

ankithimmatlalshah (4/10/2015)
Hello everyone,
Is there any way to quickly setup output columns for Script component?
I've 342 columns in my flat file source and would like to use them in script...
--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)

April 10, 2015 at 9:20 pm

#1790329
RE: Temp DB question

Alan.B (4/9/2015)
I am considering a change to how we configure new SQL Servers... On our servers tempdb get's it's own drive. Data file and log file autogrowth is set to...
--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)

April 9, 2015 at 9:46 pm

#1790071
RE: Group data into 15 minute intervals

Alan.B (4/8/2015)
You said 15 minute intervals but your example shows 30 min. To do 15 change @interval to 15. You could also dynamically calculate the start and end dates. This...
--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)

April 9, 2015 at 7:38 pm

#1790065
RE: Group data into 15 minute intervals

@Dwain,
Yes. Build them as you need them. The exception to the rule might be where you need to consider holidays or do certain bits of date magic like...
--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)

April 9, 2015 at 7:22 pm

#1790064

Viewing 15 posts - 21,046 through 21,060 (of 59,072 total)