Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,256 through 36,270 (of 59,067 total)

RE: Faster way to do Top N Order By Desc?

Donalith (10/14/2010)
How can I take out the coalesce when it's possible to have a null value there?
I'll look at the covering index though, that would be a good place to...
--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)

October 24, 2010 at 7:58 pm

#1241396
RE: Recursive Query

sridharkannan7 (10/15/2010)
I've a table with data shown as below
DetailsID FollowupID
1 0
2 ...
--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)

October 24, 2010 at 7:50 pm

#1241395
RE: Compound interest query

keymoo (10/19/2010)
Thanks very much for your help. Exactly what I needed.
Just make sure you follow the rules and add the safety check that Lutz wrote about. The code being...
--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)

October 24, 2010 at 7:42 pm

#1241394
RE: T-SQL for getting string function

mpalaparthi (10/18/2010)
Hello SQL Experts,
I have a question.... I have 3 tables (table1, table 2 and table3)
table1: ...
--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)

October 24, 2010 at 7:35 pm

#1241393
RE: Identity column concurrency

Hardy21 (10/21/2010)
I was thinking that due to multiple user is entering the data at same time, it may generate primary key violation.
Read up on it in Books Online... you'll feel...
--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)

October 24, 2010 at 7:29 pm

#1241391
RE: Serial # generation

mike 57299 (10/19/2010)
I have the following procedure:
DECLARE @id int
DECLARE @result table(id id)
update generatepk
...
--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)

October 24, 2010 at 7:26 pm

#1241390
RE: Odd String Replacement of Characters

If there's always two dashes, REVERSE (especially two reverses) is a bit expensive. This will work if there's always two dashes and be a bit faster.
DECLARE @FileName VARCHAR(50)
SELECT...
--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)

October 24, 2010 at 7:13 pm

#1241389
RE: Part of a String

AndrewSQLDBA (10/18/2010)
Thanks WildCat
I figured it out right after another coffee.
I will keep your sample code for future queries.
Thanks again
Andrew SQLDBA
Two way street here, Andrew... can you please post what 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)

October 24, 2010 at 12:32 pm

#1241356
RE: How to How to execute a concatenated query in a procedure

SeanLange (10/21/2010)
I would highly recommend you follow the suggested links above. Read them and understand what they are saying. Keep in mind this code I wrote is untested and HIGHLY...
--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)

October 24, 2010 at 12:31 pm

#1241355
RE: Combine sql Queries

I'm not sure why everyone thinks this stuff has to be done in a single query. And, it probably should NOT be done in a single query. Create...
--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)

October 24, 2010 at 12:24 pm

#1241352
RE: Efficient ways to reset lost sql sa password

yitiana (9/19/2010)
Have you ever forgot or lost your SQL Server sa password?
I'm always amazed at how many people do such a thing.
--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)

October 24, 2010 at 12:18 pm

#1241350
RE: Is this "global recession" over?

Oksana March (10/24/2010)
Can somebody who knows say for sure if this global recession is over now? I am getting conflicting information.
I am not talking about what it *feels* like, but...
--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)

October 24, 2010 at 12:15 pm

#1241349
RE: Are the posted questions getting worse?

Wow... thanks for the insight on SSIS, folks. I've mostly resisted spending any decent amount of time on it because of what I've seen. Thanks to other people's...
--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)

October 24, 2010 at 12:11 pm

#1241348
RE: How best to push large DB Copies over the wire on a regular schedule

As a side bar, IIRC, changing the recovery model to "Simple" breaks the restore chain. If this is transfer of data needs to occur on a regular basis, I'd...
--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)

October 24, 2010 at 9:42 am

#1241338
RE: Sequence-numbering groups

Paul,
Do the source (##temp) and destination (##Results) tables need to be global tables in order for the solution that you posted to work?
--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)

October 23, 2010 at 8:41 am

#1241284

Viewing 15 posts - 36,256 through 36,270 (of 59,067 total)