Jeff Moden

Forum Replies Created

Viewing 15 posts - 48,511 through 48,525 (of 59,102 total)

Reply To: Delete File Without xp_cmdshell

Richard Fryar (9/1/2008)
There is a sneaky way of doing this described here:
xp_cmdshell alternative
Heh... I love "sneaky". That's awesome! Thanks for the tip! 🙂
EDIT - BEWARE !!!! THE LINK ABOVE...
--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 1, 2008 at 5:31 pm

#865765
RE: What does this return?

Pulkit Lall (8/31/2008)
when i tried to run the command, it gave me 5 resultsets with 5 random numbers and not 1 random number.
So, the answer is 5 resultsets with 5...
--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 1, 2008 at 3:05 pm

#865753
RE: One Milly-yon IOPS - Database Weekly (Sept 1, 2008)

GilaMonster (9/1/2008)
If today's programmers can count on faster disk drives, essentially memory speed, are we going to see more and more bad SQL in tomorrow's databases?
Of course, because there 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)

September 1, 2008 at 3:03 pm

#865752
RE: swap data between 3 fields?

Ah... got it... thanks for the feedback.
Still, if the table were properly normalized, this would be a piece of cake. 🙂
--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 1, 2008 at 3:01 pm

#865751
RE: Local Temporary Tables and Table Variables

Good article!
You did forget to mention one workaround for the UDT's that would allow it to work across all databases including TempDB... Define the UDT in the Master...
--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 1, 2008 at 2:56 pm

#865750
RE: more than one query in CASE-WHEN-THEN statement

gan (8/31/2008)
I get 1469283328 for that. Sorry I do not quite understand what you are trying to explain. Can elaborate more? 😀
Yes... but please look at the actual execution plan...
--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 1, 2008 at 2:29 pm

#865748
RE: String or binary data would be truncated.

balbirsinghsodhi (9/1/2008)
There was a DDL trigger on that database and I deleted that trigger and ran the code as a stored procedure and it's working fine. You guys rock. Thanks...
--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 1, 2008 at 2:18 pm

#865747
RE: How to calculate running balance for a requested date in reports using Reporting Services 2005?

pujashah10985 (9/1/2008)
I'm getting this warning when I run the report:
If you create a stored procedure to return a result set using the methods in the following article (mentioned previously on...
--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 1, 2008 at 11:26 am

#865730
RE: How to calculate running balance for a requested date in reports using Reporting Services 2005?

gardenlady (8/29/2008)
Well, I have to say you're right. I tested over 300,000 rows and the report is taking way longer to run than the pure SQL. The reason I did...
--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 1, 2008 at 11:21 am

#865729
RE: Understanding Index defragmentation

Dougo (8/31/2008)
I actually used alter index, so rebuild. I also dropped and recreated the index.
Then, you must be looking at "extent fragmentation"... just hide that from your eyes... the big...
--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 1, 2008 at 11:03 am

#865726
RE: Cursor

Heh...
I appreciate the advertised "simplicity" of your product, but don't try to justify it by posting a bunch of bloated links with bad information in them. 😉
Both the UPDATE...
--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 1, 2008 at 10:58 am

#865725
RE: One Milly-yon IOPS - Database Weekly (Sept 1, 2008)

Steve Jones - Editor (8/31/2008)
What about a fast triangular join? Maybe it will flatten out to a linear algorithm :hehe:
Shoot! It's flat now... all you need is some Log/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)

August 31, 2008 at 6:24 pm

#865528
RE: One Milly-yon IOPS - Database Weekly (Sept 1, 2008)

If today's programmers can count on faster disk drives, essentially memory speed, are we going to see more and more bad SQL in tomorrow's databases?
Heh... The answer, just like horizontal...
--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)

August 31, 2008 at 10:08 am

#865502
RE: disabled component to install

Which version of SQL Server 2005 are you trying to install?
--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)

August 31, 2008 at 9:53 am

#865498
RE: String or binary data would be truncated.

rbarryyoung (8/31/2008)
I think that you should also check for a Create Proc DDL trigger on this database.
I think you're on to something there, Barry...
--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)

August 31, 2008 at 9:44 am

#865496

Viewing 15 posts - 48,511 through 48,525 (of 59,102 total)