Jeff Moden

Forum Replies Created

Viewing 15 posts - 33,256 through 33,270 (of 59,099 total)

RE: How to add "dot" after every three digits in a number in sql 2005

obarahmeh (10/20/2008)
I think that the best solution is added by krayknot.
Thanks to all...
Absolutely not. There's no need for the RBAR of that code.
--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)

July 18, 2011 at 7:06 am

#1354209
RE: Table Without a Primary key?

Subrata Bauri (7/15/2011)
Jayanth_Kurup (7/15/2011)
Enforcing primary key on a table is purely a design decision , while sql doesn't force it; it allows suitable substitutes in columns such as identity columns...
--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)

July 18, 2011 at 7:03 am

#1354207
RE: hi

sonwane.pratibha (7/18/2011)
high normalize or less normalize what will u put on ur database design in sql server ?
"It Depends"... is it a "real" database, a "reporting database", or a "data...
--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)

July 18, 2011 at 6:57 am

#1354204
RE: Naming Conventions

Mark-101232 (7/18/2011)
Have a look here
http://databases.aspfaq.com/database/what-naming-convention-should-i-use-in-my-database.html
It's just me, I know, but I name my tables after what a single row of any given table contains. Part of the reason 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)

July 18, 2011 at 6:55 am

#1354203
RE: loops

kritika (7/18/2011)
USE tempdb
GO
Declare @TotalRows int, @minRow int
CREATE TABLE #Temp
( Id int identity(1,1),
Queue_stub uniqueidentifier
)
INSERT INTO #temp
SELECT Queue_Stub
FROM <table_name> WHERE condition
SET @TotalRows=@@Rowcount
SET @minRow=1
--Using loops
DECLARE @queue_stub uniqueidentifier
SET @queue_stub = ''
WHILE @minRow...
--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)

July 18, 2011 at 6:33 am

#1354192
RE: loops

Perry Whittle (7/18/2011)
Jeff Moden (7/17/2011)
It'll take me a couple of hours but...one lesson in "set based" thinking coming right up.
looking forward to that already Jeff
Jeff Moden (7/17/2011)
Now... where...
--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)

July 18, 2011 at 6:29 am

#1354188
RE: need help with the code

Hardy21 (7/17/2011)
sql2k8 (7/15/2011)
the below code also works
code please..
It's a "newbie" forum mistake. His first post where the OP said "Thank You very much. Your code works " was in...
--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)

July 18, 2011 at 4:30 am

#1354147
RE: How to get count for week range?

thundersplash845 (7/17/2011)
Lutz,Thanks for your reply.. But how do i get the count of records per week??
I want something like the below one...How do i include in my code to get...
--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)

July 18, 2011 at 4:25 am

#1354145
RE: Are the posted questions getting worse?

Craig Farrell (7/17/2011)
Do you honestly think in 8 hours of training you can get a from scratch IT employee to a working (Junior) DBA?
No... of course not. But 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)

July 17, 2011 at 9:54 pm

#1354047
RE: Are the posted questions getting worse?

Jim Murphy (7/17/2011)
Jeff Moden (7/17/2011)
Don't get me wrong... I'm not pushing MS certs. 😉 That's been tried before and failed.
Jeff - what's been tried and failed:
A) 2 week death...
--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)

July 17, 2011 at 9:49 pm

#1354046
RE: Are the posted questions getting worse?

Craig Farrell (7/17/2011)
Jeff Moden (7/16/2011)
WayneS (7/15/2011)
Lynn Pettis (7/15/2011)
Chad Crawford (7/15/2011)
Craig Farrell (7/14/2011)
Hey guys, does anyone know of boot camp training session(s) for SQL Server for practical skills (not certifications)....
--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)

July 17, 2011 at 8:28 pm

#1354033
RE: Are the posted questions getting worse?

Fal (7/17/2011)
The Dixie Flatline (7/15/2011)
If someone comes around [a] place of work with a baseball bat and says "Nice little database server you got here... be a shame if something...
--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)

July 17, 2011 at 8:20 pm

#1354029
RE: A Little Interviewing Advice

No problem. I'll send you my leftovers. 😀
--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)

July 17, 2011 at 8:14 pm

#1354028
RE: loops

LutzM (7/11/2011)
It's the same like arguing if a horse will be the better choice than a mule in terms of average speed over a long distance when there's a motorbike...
--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)

July 17, 2011 at 7:15 pm

#1354024
RE: loops

GPO (7/17/2011)
Go Jeff... Go Jeff...
Incidentally, I don't get the pork chop reference.
Ok... here's my rather long winded, high velocity Pork Chop reply...
http://ask.sqlservercentral.com/questions/75404/strip-all-but-alpha-chars-out-of-a-string?page=1#76191
The "Pork Chop" reference comes from a much older...
--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)

July 17, 2011 at 7:10 pm

#1354023

Viewing 15 posts - 33,256 through 33,270 (of 59,099 total)