Jeff Moden

Forum Replies Created

Viewing 15 posts - 35,191 through 35,205 (of 59,102 total)

RE: Killed a SPID; Not Completing...

GilaMonster (2/1/2011)
Jeff Moden (2/1/2011)
I've seen several instances of such a thing happening. Although I don't claim it to be a panacea, I've found the another session on a different...
--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)

February 1, 2011 at 2:56 pm

#1281157
RE: Killed a SPID; Not Completing...

Ninja's_RGR'us (2/1/2011)
Jeff Moden (2/1/2011)
Craig Farrell (1/31/2011)
dajonx (1/31/2011)
Hi,
I was wondering if there is a way to remove a killed SPID that has been in rollback for a week without restarting SQL...
--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)

February 1, 2011 at 2:54 pm

#1281156
RE: A Great Deal of Hot Air

Shifting gears a bit... I've always thought it to be absolutely ridiculous that one would run coolers for a data center... in 15^oF weather. 😉
--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)

February 1, 2011 at 10:32 am

#1281069
RE: Killed a SPID; Not Completing...

Craig Farrell (1/31/2011)
dajonx (1/31/2011)
Hi,
I was wondering if there is a way to remove a killed SPID that has been in rollback for a week without restarting SQL service. 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)

February 1, 2011 at 10:27 am

#1281067
RE: Performance Issues when upgrading from SQL 2000

Shot in the dark... Have you rebuilt the statistics since the upgrade?
--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)

February 1, 2011 at 10:24 am

#1281061
RE: SQL statement problem

GSquared (2/1/2011)
The first step is to build a Select statement that will get all the ones you want to exclude directly or indirectly.
select *
from MyTable
where ip = '1.1.1.1'
or wordtexts =...
--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)

February 1, 2011 at 10:19 am

#1281053
RE: Need the Price with the Latest Date

drew.allen (1/31/2011)
Craig Farrell (1/31/2011)
After having done some other tests, this method seems to be the quickest, especially if you have a solid index on Item/ChangePriceDate
My tests indicate the opposite. ...
--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)

February 1, 2011 at 9:22 am

#1281011
RE: ForEach Loop and an ADO Recordset

Craig Farrell (1/31/2011)
I've got some significant error controls that need to occur so I need row by row tasking.
It's very odd to hear such a justification coming from you, Craig....
--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)

February 1, 2011 at 8:47 am

#1280980
RE: how to update a table using update clause

rsk15 (1/30/2011)
I have to display first 4 letters of a country in a column [country_sub], both country & country_sub have same data the objective is to take a reference 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)

February 1, 2011 at 8:43 am

#1280976
RE: How to concate multi rows to a column

What you're requested is known as a "Hierarchical path" and it can be done in a single query using a "Recursive CTE". Please look that term up in Books...
--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)

February 1, 2011 at 8:41 am

#1280973
RE: Header Row in CSV to be Seperated with no commas

clarmatt73 (2/1/2011)
Hi Jeff,
Thanks for your reply, unfortuntly the end user doesn't want any spaces in the Header Row when it is in Note Pad, if you use Tab it puts...
--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)

February 1, 2011 at 8:06 am

#1280948
RE: Convert columns as rows

skcadavre (2/1/2011)
lefrancisco1 (1/28/2011)
Folks,
I have three subqueries i made them as single and returned three columns as a|b|c
now i need to changes this into single rows
as
a
b
c
need urgent...
--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)

February 1, 2011 at 7:56 am

#1280942
RE: Convert character string date and time into DATETIME data type

shankarntu (1/31/2011)
Hi,
HEre my query it fetched date and time from table and seperate date and time. while i converting it throws "Conversion failed when converting datetime from character string."
Select CONVERT(varchar(8),...
--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)

February 1, 2011 at 7:52 am

#1280938
RE: Difference between temporary table and table variable

deepikamm (1/31/2011)
I need to know the difference between temp table and table variable..n also the similarities between them..plz help me with it.
One of the best articles on the subject 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)

February 1, 2011 at 7:49 am

#1280937
RE: Header Row in CSV to be Seperated with no commas

clarmatt73 (2/1/2011)
Hi All,
I've been asked to create an export that has a header row with numerous bits of data in (for example the name of the report and the date)....
--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)

February 1, 2011 at 7:23 am

#1280920

Viewing 15 posts - 35,191 through 35,205 (of 59,102 total)