Jeff Moden

Forum Replies Created

Viewing 15 posts - 48,496 through 48,510 (of 59,099 total)

RE: Merging rows

rosh (9/1/2008)
Is there any reason for storing data in this manner in the table?
Heh... yep... someone doesn't have a good split function or didn't know how to do a crosstab...
--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 6:55 pm

#865788
RE: Determine database dynamically inside a UDF

iam777here4u (9/1/2008)
The problem is, I am using a UDF. I have to use UDF only no store procedures.
Why not?
The problem is that this can't be done in a UDF because...
--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 6:50 pm

#865786
RE: Compare Source Tables rows and destination Tables rows

Select the count from both and see if they're equal?
--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 6:49 pm

#865785
RE: For Each Loop [Exec SQL Task, Send Mail]

Yes... there are a thousand reasons why this may happen...
1. Code to set the flag to 1 didn't work correctly.
2. Code to reset the flag to 0...
--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 6:47 pm

#865784
RE: database and transaction logs on same drive?

bumey309 (9/1/2008)
Why is it not recommended to have the database and transaction logs on the same drive? What will be the cause if ever?
The biggest reason is simply performance. ...
--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 6:39 pm

#865782
RE: Database Design Question

Jeffrey Williams (9/1/2008)
Maybe I am misreading this - but it sounds like all you need to do is change the join in the view from an inner join to 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)

September 1, 2008 at 6:35 pm

#865781
RE: Sysobjects (xType vs Type)

Christopher Stobbs (9/1/2008)
Type is there for backward compatibility
I wonder why some of the folks from Redmond saw fit to use it to define some of the information schema views if...
--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 6:28 pm

#865780
RE: Epidemic Priority

Heh... I'm thinking this is strong justification for tele-commuting. 😛 Let's all become agoraphobic and avoid the epidemic, conspiracys, and a modicum of common sense. 😉
--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 6:25 pm

#865779
RE: Excel Result Vs DB Result

Do like Excel does... do the calculations using FLOAT (Barry implied it with 100.0) and then round the answer to the correct number of decimal points for display. If...
--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 6:18 pm

#865778
RE: Pass file name as variable

OpenRowset cannot take variables as part of it's syntax. You'll need to do the whole OpenRowset thing as dynamic 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)

September 1, 2008 at 5:40 pm

#865768
RE: query suddenly goes slow - Worktable logical reads high

As previously suggested, have you looked into "parameter sniffing"? Google it.
Also, are there any settings differences between the two servers like "auto statistics", etc. Last but not least,...
--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:38 pm

#865767
RE: SQL 2000 Server Slowness

It could simply be a case of "parameter sniffing"... Google it.
Also, are "auto statisics" enabled or not?
--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:34 pm

#865766
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

Viewing 15 posts - 48,496 through 48,510 (of 59,099 total)