Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,681 through 43,695 (of 59,097 total)

RE: How to transfer the data from Excel to SQL2005

josephptran2002 (5/24/2009)
Hi Ike,
How are you doing? I am greatly appreciated your helps, I already solved the problem by using SSMS or Import/export wizard. You are very nice person, and may...
--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)

May 24, 2009 at 5:22 pm

#999531
RE: PIVOT QUERY HELP NEEDED

martin.edward (5/24/2009)
Ok guys, am not a SQL maestro, but I need to know it.
The parameters we were using were hardcoded. They need to be input by the user. I guess...
--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)

May 24, 2009 at 5:10 pm

#999529
RE: Query Help

Allister Reid (5/24/2009)
Ok Jeff, again thanks a lot for your time and patience, turns out your article http://www.sqlservercentral.com/articles/cross+tab/65048/ and subsequent discussions answered all the queries I had — must spend...
--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)

May 24, 2009 at 4:59 pm

#999527
RE: Long execution times when including simple SQL functions into a join

After seeing how fast the various renditions of the function run on a million rows, I'd say that it is NOT the function that is the problem. Adding such...
--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)

May 24, 2009 at 4:43 pm

#999524
RE: To write a query

Florian Reischl (5/24/2009)
Jeff Moden (5/23/2009)
Florian Reischl (5/23/2009)
Maybe it's time for your 5 bugs 😀
Ok... I'll bite. What do you mean here? I blame it on failing memory 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)

May 24, 2009 at 11:02 am

#999471
RE: The Real SQL Server Experts

ta.bu.shi.da.yu (5/24/2009)
Absolutely! I'm just saying that I think that open source projects are more influencable or are quicker to implement changes than closed source companies. My $0.02.
You and I both...
--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)

May 24, 2009 at 10:57 am

#999469
RE: Introduction to Bitmasking in SQL Server, Part 2

marshall.jones (5/23/2009)
That would be the case if I was actually doing what's happening in that example.
In practice other constraints on the datasets ensure that the number of reads is in...
--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)

May 24, 2009 at 12:24 am

#999421
RE: SQL 2008 - DBA

dbpatel.2784 (5/22/2009)
Thanks for the interest but i think i got the resolution. Thanks for helping ...
Heh... I'm thinking "Check Valve" right now.
--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)

May 23, 2009 at 10:11 pm

#999416
RE: Original Theatrical Release of Star Wars

Lynn Pettis (5/23/2009)
David Burrows (5/23/2009)
but she who must be obeyed would have fit.
It's easier to ask for forgiveness than it is for permission. :w00t:
Would not matter, if she isn't happy,...
--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)

May 23, 2009 at 10:03 pm

#999415
RE: The Real SQL Server Experts

ta.bu.shi.da.yu (5/23/2009)
Well, bare in mind I'm talking about organized projects, not little snippets of code. Look at the Samba project - they're about to get to the point where 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)

May 23, 2009 at 10:01 pm

#999414
RE: Parse multiple dates from Text Field

The TEXT column in question is that of a "log" maintained by humans. Likely as not, it has some hidden delimiters in it. Please check the data for...
--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)

May 23, 2009 at 9:52 pm

#999413
RE: Need help in update query

v.bragadeesh (5/23/2009)
Thanks all, its working
Bragadeesh
Heh... What is working? Please post your final code.
--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)

May 23, 2009 at 9:40 pm

#999411
RE: The Real SQL Server Experts

Heh... Open Source... Yep, I've seen what happens there. Just look at what some people write CLR's for. Some of it is good. Most of it is...
--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)

May 23, 2009 at 9:34 pm

#999410
RE: Dataload using Powershell - 15+GB /day

I agree with Flo. Bulk Insert will load 5.1 million rows of data 20 columns wide in less than 60 seconds.
--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)

May 23, 2009 at 9:30 pm

#999409
RE: T-sql procedure error in job

Sergiy (5/22/2009)
J (5/22/2009)
I am new to SS2K5. would you please explain in greater detail WHY ?
Because "T" in T-SQL means "transactional".
Because while you try you may affect the data used...
--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)

May 23, 2009 at 8:58 pm

#999407

Viewing 15 posts - 43,681 through 43,695 (of 59,097 total)