Jeff Moden

Forum Replies Created

Viewing 15 posts - 38,536 through 38,550 (of 59,072 total)

RE: Are the posted questions getting worse?

tosscrosby (5/5/2010)
Hey, we all work for the same company!
Man, I wish other folks would finally get THAT message. You anywhere near Detroit or Ann Arbor or...
--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 8, 2010 at 7:07 pm

#1164637
RE: SQL Server has encountered 1 occurrence(s) of IO requests taking longer than 15 seconds to complete on file

For us, it was a virus checker and someone forgot to exclude MDF, LDF, and NDF files. It brought us to a crawl. Diskkeeper, on the other hand,...
--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 8, 2010 at 7:04 pm

#1164636
RE: Are the posted questions getting worse?

Grant Fritchey (5/6/2010)
Steve Jones - Editor (5/6/2010)
Top Ten Posters in this thread (out of 15,100 or so)
Lynn Pettis ...
--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 8, 2010 at 6:53 pm

#1164635
RE: SQLServer Agent 'sed' job reporting success; but does nothing

johnzabroski (5/5/2010)
I *HATE* Blackboxes.
Heh... I'm right there with you on that one. I've been known to impliment code just to say away from them.
I haven't checked it but it...
--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 8, 2010 at 6:38 pm

#1164632
RE: Are the posted questions getting worse?

Lynn Pettis (5/6/2010)
Never know, I may actually find myself on the dark side in the future (goverment contracts tend to use Oracle a lot, ...
Heh... I've done both and 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)

May 8, 2010 at 6:16 pm

#1164629
RE: Are the posted questions getting worse?

Heh... poor guy... he's fighting not one but two language barriers (Oracle and French). Although even Oracle works better when using set based code (when set based code 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 8, 2010 at 6:10 pm

#1164626
RE: need to find out % value

san-1015392 (5/7/2010)
select Distinct ClientIdentifier, sourcesystem, methodtype, voicedatatype
,Count(CASE WHEN CONVERT(DATETIME,CONVERT(VARCHAR(10), dtmdatecreated ,101))
...
--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 8, 2010 at 5:57 pm

#1164625
RE: pivot table

ColdCoffee (5/5/2010)
Dear Lavanya, you have not even provided one of the requisites that Gianluca has asked for! Please provide us those and then we will provide you with awesome 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 8, 2010 at 5:32 pm

#1164624
RE: pivot table

lavanya.pothu (5/5/2010)
i have table
roomNo,blockFrom,blockTo
blockFrom and blockTo are date fields.....
i insert data like
501 1-Mar-2010 5-Mar-2010
502 1-Mar-2010 5-Mar-2010
503 1-Mar-2010 5-Mar-2010
504 1-Mar-2010...
--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 8, 2010 at 5:26 pm

#1164623
RE: Node.value and insert the result to an existing table

sohairzaki (5/8/2010)
Can you explain more how to shredded down. Performance is very important because the xml files are of size 1g
Thanks
heh... as a side bar, if performance were really important,...
--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 8, 2010 at 5:19 pm

#1164622
RE: how do I find the IP of the 2005 sql server instance?

marwenG (5/8/2010)
Hi ps,
My string connection is now like that:
string sConnection = @"Data Source=Admin-PC;Initial Catalog=GMAO;User ID=sa;Password=sa;";
When running my program,still the same error:
Specified sql server not found:Admin-PC
what is the problem?
Thanks
The problem 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 8, 2010 at 5:17 pm

#1164621
RE: CTE performance

kazim.raza (5/8/2010)
Select * From #Hie
this select is the one that has problems. exact count of records after inserting in #Hie is 161343. My data export to Excel failed after exporting...
--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 8, 2010 at 5:11 pm

#1164620
RE: Is selecting top(sum(int)) possible?

shannon-567218 (5/7/2010)
Hello -- thanks for taking the time to read this. Last I tried to broach this issue in 2000, it wasn't possible. But now I'm again wondering...
--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 8, 2010 at 4:46 pm

#1164619
RE: running manipulation of columns in sql query

Sash Mav (5/8/2010)
never mind..fellas
here u go
select
t.num ,
t.strike ,
rt.col2
from #tmp t
cross apply (select
case when (t.strike...
--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 8, 2010 at 1:07 pm

#1164602
RE: find missing date and values

Simple (now that we have some readily consumable data ;-)). Code with your data setup follows. Read the following article and pay attention to the rules because 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)

May 8, 2010 at 1:05 pm

#1164601

Viewing 15 posts - 38,536 through 38,550 (of 59,072 total)