Jeff Moden

Forum Replies Created

Viewing 15 posts - 39,481 through 39,495 (of 59,098 total)

RE: Taking Advantage of SQL Server Tools

I agree that DTA can be more of a hindrance in the hands of someone inexperienced in the art of determining proper indexing. It will (many times) suggest indexes...
--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)

March 6, 2010 at 6:43 pm

#1129703
RE: Part time

Then, perhaps the local recruiters would be just the ones to talk to BECAUSE it's a small world. 😉 Good words get around.
--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)

March 6, 2010 at 6:33 pm

#1129701
RE: Complex T-SQL query

It would appear that an update to the "Forum Etiquette" article would be both appropriate and long overdue. :Whistling:
--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)

March 6, 2010 at 5:58 pm

#1129700
RE: Complex T-SQL query

clive-421796 (3/6/2010)
Would like to hear from the likes of Jeff Moden, Lynn Pettis, etc. if they have a solution for this.
Yowch! Really bad form, Clive. You've just insulted...
--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)

March 6, 2010 at 3:37 pm

#1129689
RE: Too Tipsy To Work

bitbucket-25253 (3/6/2010)
Heh... I thought drinking was mandatory!
--Jeff Moden
Only when it is NOT the server that has payroll data for the entire staff.
Heh.... the staff works just as hard... so.......
--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)

March 6, 2010 at 3:12 pm

#1129687
RE: SSIS Data Compression to Oracle

We did something similar once. It was a huge amount of data, to boot. The process was relatively slow, the FTP repository needed to be maintained, etc, etc,...
--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)

March 6, 2010 at 12:19 pm

#1129666
RE: Part time

Whisper9999 (3/5/2010)
Are there any decent and legitimate jobs out there that are parttime and let you keep your "day job"? I'd like to work a little part time after...
--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)

March 6, 2010 at 12:04 pm

#1129663
RE: TSQL query problems

lmu92 (3/6/2010)
The reason for me not to provide any code (yet) is the simple lack of sample data.
The brief sample you posted doesn't match your expected result set.
If you could...
--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)

March 6, 2010 at 12:01 pm

#1129660
RE: Too Tipsy To Work

Heh... I thought drinking was mandatory! 😛
--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)

March 6, 2010 at 11:58 am

#1129658
RE: How many of you have done Certification for SQL Server?

george sibbald (3/6/2010)
You would have give those people kudos for trying to improve their opportunities in life, and on that basis I would be tempted to give them a chance.
If...
--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)

March 6, 2010 at 11:24 am

#1129654
RE: Very complex - How to count difference data

ChrisM@home (3/6/2010)
Here's a CROSS APPLY version of Jeff's derived table solution:
I keep forgetting about CROSS APPLY. When it first came out, I thought, "Just Great... another way to do...
--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)

March 6, 2010 at 11:18 am

#1129652
RE: CLR, to be or not to be, that is the question!

Paul White (3/6/2010)
Hey Jeff,
There's a faster method than that in 2005 (and I don't mean CLR):
USE tempdb;
GO
IF OBJECT_ID(N'tempdb..#Binary', N'U')
...
--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)

March 6, 2010 at 11:11 am

#1129651
RE: FizzBuzz

steve-893342 (3/6/2010)
Trillion Row Base Table - Pushing Multiple Unpivots to the Limit
So what do you think folks? Will this one go fast?
Sorry Jeff, no cross joins!
WITH cte1 AS...
--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)

March 6, 2010 at 9:19 am

#1129635
RE: always use incorrect index to run the query by sql server

Colin-232036 (3/5/2010)
One table has many fields. And in the table,it has a clustered index on a fieldA, and a nonclustered index on a fieldB. I have a query...
--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)

March 5, 2010 at 11:28 pm

#1129572
RE: impact of storing the null values in a table

dba-vb (3/5/2010)
hi,
thanks for ur response,
what is "three state logic"?
True, False, and "Unknown".
The real affect of having NULLs in a table is usually (not always) a thing called "Denormalization" and...
--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)

March 5, 2010 at 11:14 pm

#1129571

Viewing 15 posts - 39,481 through 39,495 (of 59,098 total)