Jeff Moden

Forum Replies Created

Viewing 15 posts - 25,051 through 25,065 (of 59,102 total)

RE: Arcjitecture

I've found that a whole lot of people don't even know what "Books Online" is. Get into SSMS and press the {f1} key to get there. It's 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 22, 2013 at 3:18 pm

#1675477
RE: Validate trigger entries

masoudk1990 (12/22/2013)
Ville-Pekka Vahteala (12/22/2013)
Couple of things.
Can't you just use constraints?
Your posted code seems to assume that there will be just one row coming to trigger, which might not be 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 22, 2013 at 3:16 pm

#1675476
RE: Audit Trail

nainamohamedy (12/22/2013)
I have a database which is used for a web application(not website).
For each web application user, Is it advisable to create separate db user?
Now I have a single...
--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 22, 2013 at 3:12 pm

#1675475
RE: Get data month to calander week

Sounds "urgent". Only 4 months have gone by since I asked that question. 😉 Have you done anything to help yourself on this problem in all that time?
--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 22, 2013 at 2:40 pm

#1675474
RE: Stored Procedure For A Soft Delete

Unfortunately, this is a duplicate post. No more replies on this thread, please. Unless I missed my guess, this problem has been solved at the following thread.
http://www.sqlservercentral.com/Forums/Topic1525325-392-1.aspx
@sharpcnet,
Please 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)

December 22, 2013 at 2:35 pm

#1675472
RE: Dynamic sql - how to return a value

sharpcnet (12/22/2013)
Thank you, but mentioning the childtable explicitly is not an option here. A parent table can have many child tables.
That's a major design problem that probably should have been...
--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 22, 2013 at 2:30 pm

#1675471
RE: different with the variables

nazaninahmady_sh (12/22/2013)
Hi
what is the difference between these 2 variables in store procedure:
1- the variables before As
2- the variable with declare after As
thanks alot
The variables before the "AS" 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)

December 22, 2013 at 2:00 pm

#1675469
RE: Recovery Pending Database in SQL server

navimir (12/22/2013)
Can I delete the secondary data file in emergency mode?
there will be any data loss??
the secondary data file was wrongly created with extension .mdf instead of .ndf
No. 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)

December 22, 2013 at 1:54 pm

#1675467
RE: Need help on creating a view

halifaxdal (12/22/2013)
Thanks for replies, I actually found a way to use stored procedure which is much easier for me, especially on this case.
To be honest, I wouldn't use either a...
--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 22, 2013 at 1:41 pm

#1675466
RE: Updating a Sequence Number with Order

LinksUp (12/21/2013)
I need to update a sequence number that is used to display a list. The order is not crucial except when the VisualRIN > 0. These I would like...
--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 22, 2013 at 1:02 pm

#1675464
RE: Get Groupby hierchy Records

Heh... You do make it tough to keep up with changes.
First, let's make the table builds a bit more readable. You can do the same in the future by...
--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 22, 2013 at 12:04 pm

#1675461
RE: Index & PK

ramana3327 (12/20/2013)
When we create Primary key on a table by default it will create clustered index automatically. If I don't want create any indexes on that table but just 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)

December 21, 2013 at 11:09 pm

#1675429
RE: Fetching value of previous record

Do you have any indexes to support the query?
Also, since you're doing a LEFT JOIN to "a", selecting columns only from "a", why are you joining to "b"? It's...
--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 21, 2013 at 11:03 pm

#1675428
RE: SSRS Pro best practices for saving or reusing reports, queries, store procedures etc. for use at multiple companies

Here are a couple of articles for generating gobs of data in a random but highly constrained (you know what the ranges of values will be) fashion.
http://www.sqlservercentral.com/articles/Data+Generation/87901/
http://www.sqlservercentral.com/articles/Test+Data/88964/
Dwain Camps...
--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 21, 2013 at 10:54 pm

#1675427
RE: Want to bring data in specific format(Details given in message body)

avdhut.k (12/20/2013)
Thanks cris!!!!
Its working as per my requirement.
So.... wacha wanna do when level 3 shows up?
--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 21, 2013 at 10:29 pm

#1675425

Viewing 15 posts - 25,051 through 25,065 (of 59,102 total)