Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,136 through 36,150 (of 59,102 total)

RE: UDF in UPDATE affect performance ???

karthikeyan-444867 (11/2/2010)
All,
will UDF in an UPDATE statement affect the performance? I hope so.
UPDATE #Result
SET DataSourceID = dbo.fnGetAsset(AssetID, AssetType_Code)
Assume #Result table has 400000 records.
Innputs are welcome!
Karthik... you and I go 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)

November 4, 2010 at 7:27 pm

#1246958
RE: Is xp_cmdshell the only option?

Jeff Moden (11/4/2010)
Randy Doub (11/4/2010)
I think using an Agent Job is a great idea since the account that runs my Agent already has xp_cmdshell privileges.[/quote-0]
Correct. Create a job with...
--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)

November 4, 2010 at 7:24 pm

#1246957
RE: Is xp_cmdshell the only option?

Randy Doub (11/4/2010)
I have a vendor system with a SQL2008 back end. We put their database on a large server that houses several other databases because of the large...
--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)

November 4, 2010 at 7:23 pm

#1246956
RE: DATEFIRST setting oddity

Craig Farrell (11/3/2010)
It manipulates DATEFIRST and you might botch something up on your real servers if you run it.
Setting DATEFIRST in a query only affects the session, not the entire...
--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)

November 4, 2010 at 6:59 pm

#1246946
RE: PARSING a Concatenated string into columns

SQL33 (11/4/2010)
I've been investigating this syslog parsing problem further, and noted using my HEXEditor that the field I need to have parsed (the MSGText field) is actually internally delimited with...
--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)

November 4, 2010 at 6:55 pm

#1246945
RE: how to check maximum dates in the csv files and insert into the sql tables using ssis

viky2010 (10/29/2010)
ssis
That's nasty and very bad ettiquette. Why did you delete your original 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)

November 4, 2010 at 6:46 pm

#1246943
RE: Select * from a table with one billion rows failing

RPSql (11/3/2010)
Select * from a table with one billion rows failing with following error (SQL 2005 SP3 HF11)
An error occurred while executing batch. Error message is: Exception of type 'System.OutOfMemoryException'...
--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)

November 4, 2010 at 6:45 pm

#1246942
RE: Code to compute length of time and insert into a column

gwilkins-1074841 (11/4/2010)
It's basically a one time (or once a year) update that will be static but it needs to be stored in a form. We just run once a year...
--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)

November 4, 2010 at 6:41 pm

#1246938
RE: long running queries

vijay82 (10/16/2010)
HOW to check the long running queries or sp?.what are the steps should i follow to solve thelong running quires?
What position are you applying 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)

November 3, 2010 at 8:16 pm

#1246365
RE: select query taking more time (execution time)

Also remember that returning 20 lakh (2 million rows) is going to take a while even if it's a straight select. If you're returning that many rows to the...
--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)

November 3, 2010 at 7:53 pm

#1246364
RE: select query taking more time (execution time)

vinayak_mohan (10/20/2010)
Hi All,
We have a normal select query on a table which takes around 16 mins to execute. The table has 30 lakh records and the query returns almost 20...
--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)

November 3, 2010 at 7:50 pm

#1246363
RE: Nested too deeply

ChrisM@home (10/27/2010)
Thanks for posting.
Here's a handy reference for you:
http://msdn.microsoft.com/en-us/library/ms187489.aspx
Which would make your code much more compact for the next step:
---------------------- Albania POSTCODE VALIDATION ----------------
ELSE IF @COUNTRY = 'Albania'
set @Result=(SUBSTRING(@ADDRESSLINE, nullif(patindex('%...
--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)

November 3, 2010 at 7:35 pm

#1246360
RE: need T-SQL code/script for shrinking all user db t-log files

Rambler (10/27/2010)
Ok, 2 days and 10 lines of code later I've moved somewhere....
I have created a table which is a result of DBCC SQLPERF(logspace), so it contains DB names, log...
--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)

November 3, 2010 at 7:31 pm

#1246359
RE: need T-SQL code/script for shrinking all user db t-log files

[edit] Bad 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)

November 3, 2010 at 7:20 pm

#1246357
RE: need T-SQL code/script for shrinking all user db t-log files

ss-457805 (10/24/2010)
Thanks, but I know it's done via DBCC SHRINKFILE, but I have very little knowledge of T-SQL, so that's why I was asking for the code. For someone knowledgeable,...
--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)

November 3, 2010 at 7:17 pm

#1246356

Viewing 15 posts - 36,136 through 36,150 (of 59,102 total)