Jeff Moden

Forum Replies Created

Viewing 15 posts - 40,816 through 40,830 (of 59,102 total)

RE: Removing Duplicates DueTo Unique Rows

I'm just having a hard time with your description... what you really mean is that if the ID is duplicated, it's considered to be a dupe and you don't care...
--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)

December 6, 2009 at 9:12 am

#1088269
RE: Crosstab query - Please help. it has been a few days without sleep

Not a problem, Sam... that's what we're here for.
The graphic for SQL Server shows two result sets... one for 542 rows and one for one row. Unless you click...
--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)

December 6, 2009 at 8:55 am

#1088266
RE: Alternative to using xp_cmdshell

Heh... and I was thinking the other way around. Depending on what those batch files do, you may not have to use anything BUT SQL Server. 😛
--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)

December 5, 2009 at 9:11 pm

#1088237
RE: How to Grant Execute to all Functions to one user

Steve Jones - Editor (12/5/2009)
Please don't use "sa" in examples. It sends a bad message, even though it doesn't matter in this example.
However, the way you want to do this,...
--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)

December 5, 2009 at 9:10 pm

#1088236
RE: Crosstab query - Please help. it has been a few days without sleep

Heh... you know what, Matt? You're right. The extra 1 count came from the extra return on the one JPG. They are, in fact, identical. 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)

December 5, 2009 at 9:06 pm

#1088234
RE: Datatype for IP addresses

I split them to octets (using PARSENAME) stored as TINYINT and, like someone suggested, use a calculated column to reassemble them just to make life a little easier. 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)

December 5, 2009 at 6:24 pm

#1088210
RE: Some good tips on projecting database growth?

Yep... I agree with Pablo... you already have the metrics... make a spreadsheet and a graph from that and extend the line. 🙂
--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)

December 5, 2009 at 6:18 pm

#1088209
RE: The Sixty-Second Guide to becoming a SQL Server DBA

I made my first reference to your good article for a post today, Barry. If it keeps up, I may just have to add the link to my signature...
--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)

December 5, 2009 at 6:14 pm

#1088208
RE: DTS dropping chars at 255

I'm not sure either. You might want to post the question on the Access forum of this site to get better visibility for your problem.
--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)

December 5, 2009 at 6:10 pm

#1088207
RE: Crosstab query - Please help. it has been a few days without sleep

The JPG's won't help me or you. I suspect the devil is in the data. My recommendation is that you need to start with a row count 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)

December 5, 2009 at 6:05 pm

#1088206
RE: How to Grant Execute to all Functions to one user

Taking Jason's fine code to the next level so that you don't have so much manual interaction (and, you could turn this into a DBA stored proc)...
DECLARE @sql VARCHAR(MAX)
SELECT...
--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)

December 5, 2009 at 12:41 pm

#1088192
RE: Removing Duplicates DueTo Unique Rows

cos_ta393 (12/2/2009)
Good Afternoon,
I am working with a dataset that has duplicate ID's due to unique records. The challenge is any number of column(s) can cause the uniqueness therefore there is...
--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)

December 5, 2009 at 12:30 pm

#1088190
RE: DTS dropping chars at 255

No, sorry. I suspect there's a similar setting but don't know for sure. Might actually have to create a "report" for them which uses a TEXT(xxxx) definition 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)

December 5, 2009 at 11:00 am

#1088184
RE: How to become a DBA with no experience

marjan76 (12/4/2009)
Thank you so much for all the great advice.
Yes! I think I will set up my own database and practice, and show that I have hands-on experience 🙂
Do...
--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)

December 5, 2009 at 10:40 am

#1088182
RE: Alternative to using xp_cmdshell

Heh... wait just a minute, now. Let's ask the question... specifically, WHAT do those batch files do? You may not need to use anything in those batch 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)

December 5, 2009 at 10:36 am

#1088181

Viewing 15 posts - 40,816 through 40,830 (of 59,102 total)