Jeff Moden

Forum Replies Created

Viewing 15 posts - 39,826 through 39,840 (of 59,072 total)

RE: Hungarian notation convention

Heh... "It Depends".... might be a very long interview. 😛
--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)

February 9, 2010 at 5:58 am

#1116065
RE: Cannot Get Average of rowcount: Msg 130, Level 15, State 1, Line 1 Cannot perform an aggregate function on an expression

Thanks for the feedback. Just to be sure, the "0" is the date serial number for 1900-01-01. Any number would have worked here but "0" is pretty easy...
--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)

February 9, 2010 at 5:54 am

#1116062
RE: WILD REPLACE ?

C# Screw (2/9/2010)
Thanks Jeff
your PATINDEX idea seems a step closer to a dream 'WildReplace' function which might be :
CREATE FUNCTION dbo.fn_WildReplace(@SomeText varchar(max),
@Pattern varchar(500), @ReplaceWith varchar(max))
.....
Edit: corrected syntax
Usage :...
--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)

February 9, 2010 at 5:51 am

#1116060
RE: WILD REPLACE ?

C# Screw (2/9/2010)
BTW I figured also if passing pattern to dream function then I would have to specify additional charaters to avoid clash with meta characters
'%[b][[/b]comment:#%[b]][/b]'
where [b][[/b] and [b]][/b] represent...
--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)

February 9, 2010 at 5:49 am

#1116057
RE: Compare Two Rows in a table and identify the column that is chaged.

suneel-210238 (2/9/2010)
Hi,
we have around 2000 products and there will be more coming.
--But I found a soln pls let me know if it is feasible.
I added new column called rowid 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)

February 9, 2010 at 5:45 am

#1116055
RE: Cannot Get Average of rowcount: Msg 130, Level 15, State 1, Line 1 Cannot perform an aggregate function on an expression

@andrew,
It's not you that's thick... it's me and my fingers that are thick. Thank you for the catch, Andrew
[font="Arial Black"]@ Steve,[/font]
My most sincere apologies, Steve. I...
--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)

February 9, 2010 at 5:30 am

#1116048
RE: Shrink the log file

sanya.bandaru 52584 (2/8/2010)
I have database in production Server which replication(transaction replication) is in use. The transaction log was set to restricted mode to 20GB. some transaction are going on that...
--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)

February 8, 2010 at 11:53 pm

#1115942
RE: Shrink the log file

Suresh B. (2/8/2010)
1) Run DBCC OPENTRAN and see what are the open transactions.
2) I don't think replication is failing due to Tlog full. Confirm the reason for replication failure. Replication...
--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)

February 8, 2010 at 11:52 pm

#1115941
RE: SSRS Tutorials

stalin6.d (2/8/2010)
Hi Guyz.
I am new to this Forum. Can anyone give me a good tutorials regarding SSRS. Thanks in Advance!
I believe there's one in Books Online 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)

February 8, 2010 at 11:49 pm

#1115940
RE: How to catch a screen-scraper?

Why not just add a "hit" log to the stored procedure? You found the information by using Profiler... seems like a user hit log would do well. Then,...
--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)

February 8, 2010 at 11:25 pm

#1115938
RE: WILD REPLACE ?

When using STUFF, the Tally table doesn't work so well for performance. Remember that although is has a ton of uses, it's not a panacea for replacing RBAR. ...
--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)

February 8, 2010 at 11:17 pm

#1115934
RE: Compare Two Rows in a table and identify the column that is chaged.

How many different products?
--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)

February 8, 2010 at 9:56 pm

#1115915
RE: Clustered Index Scan: How to fix ?

Digs (2/8/2010)
Data...
here we go..
Heh... not exactly a "readily consumable" format Digs. Take a look at the article in the first link in my signature for how to get better...
--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)

February 8, 2010 at 9:31 pm

#1115907
RE: Deleting records from a huge table

Sanz (2/8/2010)
I have a huge table in my database. I need to delete records from this table. There are no indexes on this table. If I create an index 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)

February 8, 2010 at 9:30 pm

#1115905
RE: Deleting records from a huge table

Amit Singh (2/8/2010)
copying to another table would require another 135 GB on the disk ..... do we have that much space ...
you could try a BCP with queryout to output...
--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)

February 8, 2010 at 9:28 pm

#1115904

Viewing 15 posts - 39,826 through 39,840 (of 59,072 total)