Jeff Moden

Forum Replies Created

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

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
RE: Convert columns as rows

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 help
Does...
--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:22 am

#1280919
RE: Surely there is a way to import CSV data in this situation?

Do you remember when all this text qualified CSV stuff that everyone has a problem with used to be child's play if not a touch slow? 😉
--===== Setup the Jet...
--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)

January 30, 2011 at 7:55 pm

#1280233
RE: Critique - The Modern Resume

Gosh... I understand about the title but it still sounds like a class on how to write a resume rather than how to build a resume if you understand 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)

January 30, 2011 at 7:07 pm

#1280230

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