Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,886 through 36,900 (of 59,102 total)

RE: Calling a UDF

vani_r14 (9/11/2010)
We have a requirement of finding data that has been entered incorrectly into the database by staff members and sending an email to them every fortnight with an attachment...
--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)

September 12, 2010 at 10:14 pm

#1219831
RE: Multi-parent heirarchy query

james.mcallester (9/12/2010)
Thanks to all who replied to this. Only had a chance to come back now to provide a final, closing post.
The problem was solved by the follow CTE:
DECLARE @ManagerID...
--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)

September 12, 2010 at 9:57 pm

#1219827
RE: Storing Negative Numbers

It is an old thread but same goes here... OMG... Debit/Credit columns meaning one thing in Accounts Payable and meaning just the opposite in Accounts Receivable. And you had...
--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)

September 12, 2010 at 9:31 pm

#1219823
RE: Blocking on tempdb system tables

sporoy (9/12/2010)
Hi, we are having blocking issues with tempdb database, blocking transaction is open for 30 minutes and has create table #Table statements in it, because of 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)

September 12, 2010 at 9:13 pm

#1219820
RE: Blocking on tempdb system tables

PaulB-TheOneAndOnly (9/12/2010)
sporoy (9/12/2010)
Hi, we are having blocking issues with tempdb database, blocking transaction is open for 30 minutes and has create table #Table statements in it, because of...
--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)

September 12, 2010 at 9:09 pm

#1219818
RE: Using DateDiff to calculate days before a Birthday

kenkob (9/12/2010)
Jeff,
After a little trouble I have got it working. When I attempted to use it as a SqlCe CommandText string surrounded by inverted commas, I was always...
--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)

September 12, 2010 at 9:04 pm

#1219813
RE: Creating large semi-random data sets without cursors

Here's a start... my standard million row test table. There's a special column in the following that you should look for, as well. You'll recognize it. Should...
--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)

September 12, 2010 at 9:00 pm

#1219812
RE: XML "CSV" Splitter

I'm amazed... to split 10,000 rows with 10 random elements each, this XML method takes more than 14 seconds on my humble desktop. A While Loop driven function only...
--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)

September 12, 2010 at 5:41 pm

#1219799
RE: Need to compare two columns

Carefull folks... ISDATE isn't all that you believe it is...

SELECT ISDATE('2010'), CAST('2010' AS DATETIME),
ISDATE('201006'), CAST('201006' AS DATETIME),
...
--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)

September 12, 2010 at 2:45 pm

#1219769
RE: Create, Rename, Delete file folder thru SQL

Steve Jones - Editor (8/12/2009)
You'd be better off doing this in Powershell or VBScript and calling the script from T-SQL if you need to.
I know it's an old post but...
--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)

September 12, 2010 at 2:00 pm

#1219762
RE: Performance testing and tuning for a beginner

Specially I learned in tuning a few things:
We should be careful about creating temporary tables, dynamic SQL and joining. Those things are the gold mine for the tuners as eliminating...
--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)

September 12, 2010 at 8:48 am

#1219724
RE: Are the posted questions getting worse?

CirquedeSQLeil (9/10/2010)
Alvin Ramard (9/10/2010)
Jeff Moden (9/10/2010)
..... Perfect for the game we all call "life". 😛
The game of life is hard to play
I'm gonna lose it anyway
The losing...
--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)

September 10, 2010 at 7:53 pm

#1219591
RE: Poor performance when all RAM allocated, but not in use

hirro (9/10/2010)
Here is what I've gotten from Microsoft.
Looking through the plan I see that there is a difference in how SQL is generating the query plan for the same query...
--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)

September 10, 2010 at 7:52 pm

#1219590
RE: Are the posted questions getting worse?

WayneS (9/10/2010)
Jeff Moden (9/10/2010)
mtillman-921105 (9/10/2010)
The Dixie Flatline (9/10/2010)
I played a lot of Civilization. It took a while, but it finally dawned on me that the barbarians weren't...
--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)

September 10, 2010 at 7:31 pm

#1219580
RE: Using DateDiff to calculate days before a Birthday

kenkob (9/10/2010)
Jeff,
Just entering SELECT YEAR(GETDATE()) give the error Function is not recognized by SQL Server Compact Edition of Function [Year]
Running DATEPART returned 2010
Then doing a little substitution in my...
--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)

September 10, 2010 at 7:25 pm

#1219577

Viewing 15 posts - 36,886 through 36,900 (of 59,102 total)