Jeff Moden

Forum Replies Created

Viewing 15 posts - 30,331 through 30,345 (of 59,101 total)

RE: Generating Test Data: Part 1 - Generating Random Integers and Floats

mishaluba (4/21/2012)
Another brilliant article from Jeff. Easy and fun read (not very often you can say this about a technical text). Can't wait for Part 2.
Thanks, Mishaluba. ...
--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 22, 2012 at 8:52 am

#1477172
RE: URGENT PLEASE Got a SQL Scenario to solve

mtassin (4/20/2012)
GSquared (4/20/2012)
I tested two-step upserts vs Merge, and it was faster in most cases in my code. But it isn't always faster, and possibly not even faster 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)

April 22, 2012 at 8:34 am

#1477171
RE: URGENT PLEASE Got a SQL Scenario to solve

GSquared (4/20/2012)
I tested two-step upserts vs Merge, and [font="Arial Black"]it[/font] was faster in most cases in my code. But [font="Arial Black"]it[/font] isn't always faster, and possibly not even faster...
--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 22, 2012 at 8:32 am

#1477170
RE: grouped running totals

greg.bull (4/20/2012)
Thanks. I;d read this already but it didn't help - I'd implemented the triangular join type mechanism (I think) to create a running total - but this part I'm...
--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 20, 2012 at 4:26 pm

#1476971
RE: grouped running totals

CELKO (4/20/2012)
>> I have a table that has lots of staff (described by unique staff_ids) and hours worked as a metric for each int week number. <<
You have not ever...
--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 20, 2012 at 3:22 pm

#1476959
RE: using bcp,how to load the data into a table in the same order as the records in the file

srihari nandamuri (4/19/2012)
Hi,
While loading(using bcp) data from file into a table,I want to load the file data into a table in the same order as in the file.
Example:-
File contains...
--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 19, 2012 at 7:42 am

#1476008
RE: Are SQL views efficient?

pwallis (4/19/2012)
...we are going to have to trace where the bottleneck is rather than simply alter the method.
For some reason, I thought you had already done that. 😉 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 19, 2012 at 7:18 am

#1475995
RE: Are the posted questions getting worse?

Shifting gears hard to the opposite side of the spectrum, have you folks been watching Wayne Sheffield's blog? He's done some awesome testing against some of the new LEAD...
--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 18, 2012 at 10:21 pm

#1475809
RE: Grouping by ten days period

Vedran Kesegic (4/18/2012)
Simplest form:
select Decade = convert(VARCHAR(9), s.s_date, 120), Amount = sum(s.amount)
from dbo.sample s
group by convert(VARCHAR(9), s.s_date, 120) -- 120 = yyyy-mm-dd hh:mi:ss
You could use variation, e.g. month + decade,...
--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 18, 2012 at 5:11 pm

#1475784
RE: Are SQL views efficient?

The problem with VIEWs can simply be that they are necessarily "all in one query". I've changed many a query from takin minutes to execute to subsecond and small...
--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 18, 2012 at 5:05 pm

#1475780
RE: Are the posted questions getting worse?

Koen Verbeeck (4/18/2012)
Stefan Krzywicki (4/18/2012)
Just complaining for a second
Scope for variables in SSIS are utter crap, it'd be better if scope didn't even exist here. Yes, I hear it 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)

April 18, 2012 at 4:26 pm

#1475776
RE: Are the posted questions getting worse?

SQLRNNR (4/18/2012)
ACinKC (4/18/2012)
hbtkp (4/13/2012)
i think i will lost my job , i am on dead linequote]
hbtkp (4/13/2012)
he just told me i cant help u with code,so i need help from...
--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 18, 2012 at 4:24 pm

#1475775
RE: Add varchar columns with colon in between to show time

Dang it... that's the second time I lost track of this thread. My apologies. I'll try to take a look tonight.
--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 18, 2012 at 6:47 am

#1475309
RE: sql server admin books

All kidding aside, the first book to buy would be one on how to use search engines Yahoo and Google to find such books. :-P:-P:-P:-P
--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 17, 2012 at 9:40 pm

#1475140
RE: Complicated query

ColdCoffee (4/16/2012)
How about this?
Setting up the sample data
DECLARE @Tab TABLE
(
ID INT
,Tym TIME
,Axn INT
)
INSERT @Tab
SELECT 1 ,'10:00', 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)

April 17, 2012 at 9:37 pm

#1475138

Viewing 15 posts - 30,331 through 30,345 (of 59,101 total)