Jeff Moden

Forum Replies Created

Viewing 15 posts - 32,311 through 32,325 (of 59,099 total)

RE: using While loop in place of cursors

Cadavre (10/10/2011)
Rakesh.Chaudhary (10/10/2011)
just for faste performance and for learning purposes
Well, golly gosh! It seems that after you went to all the trouble of reading the link in my previous post,...
--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 10, 2011 at 5:08 am

#1392327
RE: using While loop in place of cursors

Rakesh.Chaudhary (10/10/2011)
I want to use while loop for this..............
DECLARE Total_salary CURSOR
FOR
SELECT
e.Emp_Id,FirstName,(Basic+HRA+Allowance)AS Total_Salary
from Salary Inner Join Emp_Detail e
on e.Emp_ID=Salary.Emp_Id
OPEN Total_salary
FETCH NEXT FROM Total_salary
WHILE @@FETCH_STATUS=0
BEGIN
FETCH NEXT FROM Total_salary
END
CLOSE Total_salary
DEALLOCATE Total_salary
The only difference...
--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 10, 2011 at 5:07 am

#1392326
RE: Parsing a document - Is T-SQL a good tool for this ?

Very interesting. Thanks, Johan. Have you tested it for performance at all? And, yes... I'll check out the link you provided.
--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 9, 2011 at 7:38 pm

#1392250
RE: searching table against variable list

Gosh... we just got you out of one looping problem. 😛 What does the store procedure you want to loop-over actually do?
--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 9, 2011 at 7:34 pm

#1392249
RE: "Recursive" Update query

Jakub Dvorak (10/7/2011)
Thanks very much!
I wrote exactly same query in the meantime. Only thing I would change for metioned large datasets is adding WHERE clause to last update which filters...
--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 9, 2011 at 7:25 pm

#1392248
RE: Best SQL Server and T-SQL monitoring and development tools

oradbguru (10/8/2011)
Thank you for the reply. I have taken over a 1+ TB database and am looking for tools that can monitor, alert and hopefully make performance improvement suggestions....
--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 9, 2011 at 7:01 pm

#1392245
RE: Inline TVF's versus multi-statement valued TVF's

Ok, David... I've seen quite enough and you've asked for it 😉
You write nicely, you cite references, you write code to build test data and then to do the tests,...
--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 9, 2011 at 6:58 pm

#1392244
RE: Universal table schema

meghna.bhargav (10/9/2011)
HI
I want to design universal schema in database where any end user can dump any type of data into database coming from any type of source for e.g. excel,...
--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 9, 2011 at 6:50 pm

#1392243
RE: Aging Payments query help

Tom,
Take a look at the following article so you can understand how "J Livingston SQL's" method works... it' quite effective.
http://www.sqlservercentral.com/articles/T-SQL/63681/
--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 9, 2011 at 6:45 pm

#1392241
RE: Aging Payments query help

J Livingston SQL (10/9/2011)
different approach....may be give you some ideas
pls note ...date range vailidity needs scrutiny
comments in code
USE [tempdb] --- a safe place
GO
--== condtionally drop table...
--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 9, 2011 at 6:42 pm

#1392240
RE: Parsing a document - Is T-SQL a good tool for this ?

ALZDBA (10/9/2011)
This may be a perfect occasion to get started with Powershell or SSIS to parse your documents.
SSC has some nice articles to get you started with both.
For powershell this...
--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 9, 2011 at 6:22 pm

#1392239
RE: 'Not In' Question

We recently had a similar problem at work and, of course, everyone jumped in on the ISNULL bandwagon as a resolution... and, as some expected, the code took comparatively forever...
--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 9, 2011 at 6:14 pm

#1392237
RE: REPLACE using CHAR vs NCHAR

Something else you need to be aware of that some of us found out while testing code in one of my articles... certain collations will make your server run horribly...
--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 9, 2011 at 6:03 pm

#1392236
RE: I cringe every time I see a recommendation for xp_cmdshell.

opc.three (10/7/2011)
Please, have a look at PowerShell. Once you ramp up you will never want to open CmdShell again.
Well I might especially if it's to fire off PowerShell from a...
--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 9, 2011 at 5:47 pm

#1392234
RE: SQL LTrim not removing a character

For those interested in what some of the more cryptic designations for ASCII characters less than character 32 are, please see the following link...
http://www.asciitable.com/
--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 9, 2011 at 4:39 pm

#1392230

Viewing 15 posts - 32,311 through 32,325 (of 59,099 total)