Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,076 through 21,090 (of 59,098 total)

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
RE: Group data into 15 minute intervals

dwain.c (4/9/2015)
A general question here to Jeff and Joe then. Let's hear your thoughts.
I've written on Calendar tables[/url] and how they can be used (An Easter SQL[/url]). Clearly...
--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 6:14 pm

#1790061
RE: Optimize memory with varchar(max) datatype

I strongly recommend NOT using VARCHAR of any type for Old/New values in such a table. Consider using SQL_VARIANT, instead. You don't really want to audit blobs anyway.
--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 5:10 pm

#1790050
RE: Group data into 15 minute intervals

Bill Talada (4/8/2015)
SELECT crdate, DATEDIFF(MINUTE,'19000101', crdate) / 15 FROM sysobjects ORDER BY DATEDIFF(MINUTE,'19000101', crdate) / 15 WITH x AS ( SELECT DATEDIFF(MINUTE,'19000101', crdate) / 15 as QuarterHour FROM sysobjects ) SELECT QuarterHour, COUNT(*) FROM x GROUP by QuarterHour ORDER by QuarterHour ;
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)

April 9, 2015 at 5:04 pm

#1790049
RE: Today's Random Word!

Ed Wagner (4/9/2015)
SQLRNNR (4/9/2015)
@##$@&*&%#@
WTF
Peer Review
--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 4:59 pm

#1790048

Viewing 15 posts - 21,076 through 21,090 (of 59,098 total)