Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,141 through 22,155 (of 59,072 total)

RE: The Rich Rewards of Tuning SQL

Luis Cazares (12/26/2014)
Of course, buying new hardware can get you some time. But how much time would you get if your app is full of crappy code? There's no piece...
--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)

December 26, 2014 at 2:22 pm

#1766522
RE: How to slect data from table ?

serg-52 (12/26/2014)
Jeff Moden (12/26/2014)
serg-52 (12/26/2014)
Try
Select Phone1,Phone2 from tblregistration
where 'abc@yahoo.com,def@yahoo.com,efg@yahoo.com' like '%'+Usernames+'%'
That could end up being a pretty bad performance problem because it's not SARGable. Guaranteed , if I'm...
--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)

December 26, 2014 at 1:53 pm

#1766517
RE: Are the posted questions getting worse?

Luis Cazares (12/26/2014)
Happy Holidays to everyone!
I wish that you can enjoy quality time with your families and beloved ones and may the new year bring you happiness and growth (hopefully...
--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)

December 26, 2014 at 1:33 pm

#1766516
RE: Getting back to SQL Server

rondebbs 48050 (12/26/2014)
Hello, I worked with SQL 7 and SQL 2000 many years ago (I also worked some with Oracle). About 14 years ago I got involved with AIX...
--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)

December 26, 2014 at 1:31 pm

#1766515
RE: How to slect data from table ?

serg-52 (12/26/2014)
Try
Select Phone1,Phone2 from tblregistration
where 'abc@yahoo.com,def@yahoo.com,efg@yahoo.com' like '%'+Usernames+'%'
That could end up being a pretty bad performance problem because it's not SARGable. Guaranteed table scan, if I'm reading that...
--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)

December 26, 2014 at 12:12 pm

#1766509
RE: How to slect data from table ?

sandeep rawat (12/26/2014)
Hi
go throw below link.
http://www.codeproject.com/Tips/584680/Using-comma-separated-value-parameter-strings-in-S
If it has a WHILE loop in it, two things are wrong...
1) It's a scalar function that will be about 7 times slower than...
--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)

December 26, 2014 at 12:06 pm

#1766506
RE: How to slect data from table ?

Shafat Husain (12/25/2014)
Dear Gauri,
You will have to use a table valued split function to cater to this requirement.
A split function will take up the string as 'val1,val2,val3....' and a delimiter...
--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)

December 26, 2014 at 12:05 pm

#1766505
RE: Update statement times out on a small table

Each client computer updates its own row every second with the latest data.
1. Can we see the UPDATE code, please?
2. Are there any other indexes on the table?
3. What are...
--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)

December 26, 2014 at 11:40 am

#1766504
RE: Date Table

Thanks, Scott. I was afraid it would be something like that. I can see those reasons for companies back when spreadsheets where 11x17 accounting papers that were resolved...
--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)

December 26, 2014 at 11:23 am

#1766500
RE: Formatting output of query, need help

CELKO (12/25/2014)
Please follow basic Netiquette and post the DDL we need to answer this.
I'm thinking you're a bit late with that on this one, Joe. 😉
Follow industry and ANSI/ISO standards...
--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)

December 25, 2014 at 1:53 pm

#1766423
RE: Help! oracle business intelligence 11g developers guide

combines2 (12/25/2014)
Hello. I Really need this book, i'm going to start working for a big company next month and i need to start learning about OBIEE 11g. As i found...
--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)

December 25, 2014 at 1:24 pm

#1766422
RE: Date Table

CELKO (12/25/2014)
Why do some companies use weird Fiscal Years, such as starting in April? What is the purpose there?
The last time I looked the GAAP had about 150...
--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)

December 25, 2014 at 1:20 pm

#1766421
RE: is bulk logged recovery model support point in time recovery

dastagiri16 (12/25/2014)
sry i missed out mentioned count....after go command
The statement is below
insert into table(values)
go 100
No. That wouldn't be considered to be a "Bulk" process and certainly not a "Minimally...
--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)

December 25, 2014 at 11:36 am

#1766420
RE: is bulk logged recovery model support point in time recovery

Shafat Husain (12/25/2014)
Thank you Jeff and Gila for the clarification. :blush:
To be honest, I have Gail to thank, as well. She's one smart lady. A while back and...
--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)

December 25, 2014 at 11:34 am

#1766419
RE: Date Table

CELKO (12/25/2014)
I think that's what the op is trying to do. I think they used the spreadsheet as a working tool to make all of the dates they needed...
--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)

December 25, 2014 at 11:17 am

#1766418

Viewing 15 posts - 22,141 through 22,155 (of 59,072 total)