Jeff Moden

Forum Replies Created

Viewing 15 posts - 26,311 through 26,325 (of 59,099 total)

RE: nvarchar(max) or nvarchar(1000)?

taigovinda (8/3/2013)
Many thanks Jeff! This is just the kind of thing I need to get me started actually understanding instead of being a perpetual "stumble-my-way-through-it"-er... At this point...
--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 3, 2013 at 9:34 am

#1638418
RE: Top from store procedure

niladri.primalink (8/3/2013)
Hi All,
I have a stored procedure named 'Bacs_ValidProcessingDateList' when I execute this procedure it is working fine.
It shows me 2568 records. How Can I use top clause with this?
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)

August 3, 2013 at 9:23 am

#1638416
RE: Responding to You - QOD

david.wright-948385 (8/3/2013)
Steve Jones - SSC Editor (8/2/2013)
Some of you might have noticed that the "Yesterday's Question of the Day" is back in the newsletter (today's).
...we had some authors 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)

August 3, 2013 at 9:21 am

#1638415
RE: Easy (I hope) join question

taigovinda (8/2/2013)
Good point... For the sample data that is definitely smarter. In my actual data I have about 6 fields that are like 'address' in that there could...
--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 2, 2013 at 11:03 pm

#1638398
RE: nvarchar(max) or nvarchar(1000)?

Forgot about the original problem. Since you've already determined that some data exceeds both NVARCHAR(4000) and VARCHAR(8000), then one of the MAX datatypes is appropriate although I'd try 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 2, 2013 at 10:45 pm

#1638397
RE: nvarchar(max) or nvarchar(1000)?

taigovinda (8/2/2013)
Thanks Jeff. So I suppose I should use nvarchar(8000) for the column that has never topped 1000 characters, but still am stuck using nvarchar(max) for the column 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)

August 2, 2013 at 10:38 pm

#1638396
RE: Resource Governor Workload Classification limitations - looking for ideas

This doesn't answer your question but I've always questioned the use of the Resource Governor on jobs. You know the jobs are there and you know they're 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 2, 2013 at 10:00 pm

#1638394
RE: nvarchar(max) or nvarchar(1000)?

taigovinda (8/2/2013)
Thanks. Given that info I will stick with max as I have no need to index by these columns. 😀
Tai
Before you jump to that conclusion, please consider the...
--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 2, 2013 at 9:35 pm

#1638392
RE: Sorting Months By Number (SQL Spackle)

David McKinney (8/2/2013)
Hi Jeff,
As regards why the article got marked down, I'd suggest that it's because you didn't mention the obvious solution.
You want to sort by the month...
--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 2, 2013 at 7:44 am

#1638172
RE: Query execution time in Milisecond

Be careful about what you use SET STATISTICS on. If you have any scalar functions in the query, they can look hundreds of times worse than they are 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)

August 1, 2013 at 9:40 pm

#1638040
RE: How to add a total in a column on a table ???

I can't help in SSRS but, as a sort of "bump" for you, what kind of total are you looking 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)

August 1, 2013 at 9:34 pm

#1638039
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (8/1/2013)
jasona.work (8/1/2013)
Steve Jones - SSC Editor (7/31/2013)
As of now, most of the last year has been spent on Simple Talk, which had a very creaky,...
--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 1, 2013 at 9:05 pm

#1638036
RE: Moving Records in Batches - 7 Tables - Several Million Records

JoshDBGuy (8/1/2013)
mister.magoo (8/1/2013)
Are you using a particularly slow system?
Millions of rows shouldn't be a major problem unless those rows are massively wide...for instance, on my PC I can shift...
--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 1, 2013 at 8:46 pm

#1638035
RE: Need SQL Query

Durai Samuel (8/1/2013)
Please check if this link helps
http://www.dotnetbites.com/find-user-modified-table-stored-procedure
That's got some serious errors in it. Although it happens frequently, no result set is guaranteed to be in the same order...
--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 1, 2013 at 4:29 pm

#1638013
RE: Schema-Owned Tables and Generated DROP Scripts (SQL Spackl

Really good "Spackle", Brandie. Our shop enforces the 2 part naming convention for everything and we do 100% peer reviews before anything leaves Dev so we know to check...
--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 1, 2013 at 7:38 am

#1637792

Viewing 15 posts - 26,311 through 26,325 (of 59,099 total)