Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,396 through 43,410 (of 59,102 total)

RE: Identity and uniqueIdentifier and custom id

It doesn't need to be the primary key. Doesn't even need to be the clustered index. Can be an index. It all depends... what do most 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)

June 15, 2009 at 2:24 pm

#1009909
RE: Identity and uniqueIdentifier and custom id

Digs (6/14/2009)
Identity and uniqueIdentifier and customid
Is there any CustomID method where I can create my own ID for keys in tables.
Sequential ID from identity is ok
The UniqueIdentifier works but 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)

June 15, 2009 at 1:56 pm

#1009898
RE: Are the posted questions getting worse?

Mike McQueen (6/15/2009)
As far as I know, he has no idea what your e-mail address is. When you e-mail someone all you see is their User Name, and it 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)

June 15, 2009 at 1:50 pm

#1009893
RE: Append output from SQLCMD in batch file

WayneS (6/15/2009)
Jeff Moden (6/15/2009)
Ok... you guys can remove the handrails, now. 😛
..... getting out the reciprocating saw .... or will that cause too much damage where the handrails 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)

June 15, 2009 at 1:46 pm

#1009890
RE: Test your problem solving skills!

Lynn Pettis (6/15/2009)
But, on the flip side, there is also no reason that it could be pointed out that it would be beneficial to move those detached databases to another...
--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)

June 15, 2009 at 1:43 pm

#1009888
RE: Test your problem solving skills!

talltop (6/15/2009)
I've worked for incompetent managers in the past as well and they usually end doing themselves in. They don't need my help. However, tellling off a manager or advising...
--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)

June 15, 2009 at 11:41 am

#1009811
RE: Are the posted questions getting worse?

Roy Ernest (6/15/2009)
The troll generator gave me good name...Sticky Buns Troll..:hehe:
Heh... TMI, Roy. 😀
--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)

June 15, 2009 at 11:13 am

#1009803
RE: How to get Saturday b/w two dates

Lutz's example is the start. You just need to add the SUM code which should be no biggee.
If you need a more complete answer, we need to see...
--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)

June 15, 2009 at 11:11 am

#1009802
RE: DBA job not busy enough

WayneS (6/14/2009)
Jeff Moden (6/14/2009)
Also, test the restoration of backups and maybe write the standard guidline for doing such a thing. Maybe even go whole hog and setup/test a disaster...
--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)

June 15, 2009 at 10:46 am

#1009773
RE: Are the posted questions getting worse?

RBarryYoung (6/14/2009)
Grant Fritchey (6/14/2009)
Jeff Moden (6/14/2009)
Grant Fritchey (6/14/2009)
I've got a spotlight and an alternate in the regular sessions.
"Regular Sessions"? Are you talking about "general" sessions? I've not received...
--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)

June 15, 2009 at 10:33 am

#1009763
RE: Are the posted questions getting worse?

Paul White (6/14/2009)
Alvin Ramard (6/14/2009)
Paul White (6/14/2009)
RBarryYoung (6/14/2009)
What shall we name it? 😛
Troll Name Generator
I sure won't use that tool for a troll name!!
😎
For those too busy 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)

June 15, 2009 at 10:29 am

#1009761
RE: Append output from SQLCMD in batch file

carissa.chris (6/15/2009)
I wanted a "forever" log and the ">> E:\output.txt" accomplishes exactly what I needed. Thanks for all the input.
🙂
Ok... you guys can remove the handrails, now. ...
--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)

June 15, 2009 at 10:08 am

#1009750
RE: Append output from SQLCMD in batch file

Thanks for the feedback Carissa.
--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)

June 15, 2009 at 10:07 am

#1009749
RE: Which Rows in Cursor?

Heh... Flo is correct... certain administrative code certainly justifies the use of Cursors and/or While Loops. I'm not so sure that Ken's application requires it because I simply don't...
--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)

June 15, 2009 at 10:01 am

#1009745
RE: DBA job not busy enough

Search the dbo.sysComments tables (SQL Server 2000) or the sys.sql_modules tables (SQL Server 2005) for the word "WHILE" and repair that code.
Also, test the restoration of backups and maybe write...
--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)

June 14, 2009 at 4:28 pm

#1009406

Viewing 15 posts - 43,396 through 43,410 (of 59,102 total)