Jeff Moden

Forum Replies Created

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

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
RE: conversion error

muralikrishna37 (8/31/2008)
Hi Jeff,
when i fit Int datatype it shows error.tell me which data type i have to fit here.
the problem is blank row(empty row).how to take the data into sql...
--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:33 am

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

balbirsinghsodhi (8/31/2008)
Now, I ran the code which Jeff has provided. It's working fine when I run as a select command but when I try to convert into a stored procedure...
--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:23 am

#865488
RE: Cursor

simon phoenix (8/31/2008)
Hi
Jeff
Everything worked out perfect, exactly what i wanted. After a long time , i am going to have good night sleep. I am not scared of going to...
--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:14 am

#865482
RE: Cursor

--===== Show first and last PRD and date of each SetSequence
SELECT yt.SetSequence,
MAX(CASE WHEN d.MinID = yt.ID THEN PRD END) AS MinPrd,
...
--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 30, 2008 at 11:43 pm

#865457
RE: Using UNION ALL with ORDER BY NEWID()

Thanks for the feedback, Juan. 🙂
--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 30, 2008 at 11:19 pm

#865456
RE: What order do you do maintenance tasks in?

GilaMonster (8/30/2008)
balbirsinghsodhi (8/29/2008)
You can put a shrinking log file as your maintenance plan but never put shrinking database in your maintenance plan.
It's strongly recommended that neither logs nor data files...
--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 30, 2008 at 9:20 pm

#865444
RE: Restore with no backup

Lowell (8/29/2008)
when you delete a file, regardless of the recycle bin, the file is still there, but the disk space it used is open for use by other programs...if you...
--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 30, 2008 at 9:16 pm

#865443

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