Jeff Moden

Forum Replies Created

Viewing 15 posts - 25,561 through 25,575 (of 59,102 total)

RE: Insert second result set from stored procedure into table

Rumor has it that this is what "MARS" is 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)

October 25, 2013 at 3:18 pm

#1661752
RE: Help with Pivot in T-SQL

Hey Alex,
Throw your test data into some readily consumable code and I'll be happy to show you how to do this. See the article at the first "Helpful Link"...
--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 25, 2013 at 2:57 pm

#1661744
RE: How to Identify name starting with a specific letter without using like operator?

sharmili.net (10/25/2013)
Hi All,
How to Identify name starting with a specific letter without using like operator?
Please help me out.
Thanks in advance,
Sharmi
It depends... how slow do you want the code to actually...
--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 25, 2013 at 10:26 am

#1661681
RE: Simple query maxing CPU

Bhuvnesh (10/24/2013)
INdexes is definitely a MUST thing here or everywhere .
Careful now... I'd have to say, "It Depends". There are quite a few places where adding an index 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)

October 25, 2013 at 10:17 am

#1661679
RE: Data loading best practices for 5-10 millions of rows.

Minaz (10/24/2013)
Hi Expert,
As this a huge environment wanted to impement best practice for loading 5 - 10 millions of rows, please advice.
How do I take care of costraint and indexes?
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)

October 25, 2013 at 10:13 am

#1661677
RE: Data loading best practices for 5-10 millions of rows.

Koen Verbeeck (10/25/2013)
Also set the recovery model to simple. (maybe only during the load if you want point-in-time recovery during the rest of the day)
Ooooohhhh, be careful, now. BULK...
--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 25, 2013 at 10:12 am

#1661675
RE: Searching Address by Ranges

Bill Talada (8/22/2013)
I'm completely sick of anti-rbar preachers. They're just getting their ego kicks through trying to one-up everybody.
Since I invented the term “RBAR” and I’m most definitely an “Anti-RBAR...
--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 25, 2013 at 1:35 am

#1661537
RE: Capitalizing only first letter of each Word in a Column using Query

The question now is.... do you understand how it works?
--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, 2013 at 2:13 pm

#1661462
RE: user functions

Tell your instructor that writing a function for this is a bit crazy and is likely to result in the ponderous use of RBAR. Folks should also get away...
--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, 2013 at 1:17 pm

#1661436
RE: run two queries at the same tiime

Bill Talada (10/22/2013)
The question is basically flawed because for now we are stuck with the Von Neumann architecture in our business computers where everything is single-threaded through the CPU 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)

October 22, 2013 at 11:48 pm

#1660794
RE: Need to pull the data out of a row and into a comma separated string referencing the columnID

dcesharkman (10/22/2013)
Here is the output form the process that is needed:
INSERT [dbo].[Address] ([ID], [Address1], [Address2], [City], [State], [ZipCode], [AddressTypeID], [IsPrimary], [CountryId], [Address_no_old]) VALUES (4, N'52123 Go Street', N'', N'Othertown', N'CA',...
--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 22, 2013 at 11:26 pm

#1660792
RE: run two queries at the same tiime

Bill Talada (10/22/2013)
...the question is flawed.
BWAA-HAAA!!!! How can a question be flawed when the OP doesn't know? 😛
--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 22, 2013 at 6:32 pm

#1660771
RE: run two queries at the same tiime

Smash125 (10/22/2013)
I have two queries
For example
query1: select * from table1
query2: select * from table2
what I want both the queries run at the same time in the query analyzer. Please ...
--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 22, 2013 at 6:20 pm

#1660767
RE: Analytical Functions in SQL 2005

Amit Raut (10/22/2013)
Hi,
Please suggest me some good resources on Analytical Functions in SQL 2005.
I googled on this but most of the results are related to SQL 2012.
Thanks 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)

October 22, 2013 at 5:29 pm

#1660762
RE: When the reporting team needs an assist...

Leonard Rutkowski (10/21/2013)
Nice article. I have done something similiar, however, I use Powershell, and run a SQL job as needed. My table is very similiar to yours. When...
--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 22, 2013 at 4:25 pm

#1660752

Viewing 15 posts - 25,561 through 25,575 (of 59,102 total)