Jeff Moden

Forum Replies Created

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

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
RE: Talend vs. SSIS: A Simple Performance Comparison

Let’s get something straight: if you’re a Microsoft shop, or you’re loading data to MS SQL – SSIS is the way to go.
I hope you don't mind if I...
--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:13 pm

#1660746
RE: can't get rid of leading zeroes

polkadot (10/21/2013)
ok it was char(13). OK, thanks so much to both of you. Two replaces resolves the leading white spaces.
Ugh! 🙂 CHAR(13) is a carriage return. Sounds...
--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 3:26 pm

#1660735
RE: Strange Behavior with (nolock)

GilaMonster (10/22/2013)
DBCC CheckDB (<database name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
I'd still remove the nolocks, they definitely can cause you problems, by design they can result in incorrect data. As I said, not...
--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 3:13 pm

#1660731

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