Jeff Moden

Forum Replies Created

Viewing 15 posts - 30,826 through 30,840 (of 59,101 total)

RE: Problem to write Special Function

Golden_Behzad (3/8/2012)
how to use?
Please lookup IDENTITY column in Books Online. It's nothing more than a simple autonumbering column that you would add to each table and make it 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)

March 8, 2012 at 8:05 am

#1456549
RE: Backup only newest database.

Gianluca Sartori (3/7/2012)
Another possible solution: since you don't want database backups for existing databases, I suppose they don't get modified, so you could take a backup of read/write databases and...
--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)

March 8, 2012 at 7:10 am

#1456508
RE: Tempdb file run out of space

sqlfriends (3/7/2012)
Thanks by the way, because now the current setting for the database file growth I restricted to 20gb, if I change it to unlimited, do I need to restart...
--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)

March 8, 2012 at 6:57 am

#1456496
RE: Get @@IDentity before or after commit?

Careful folks. @@IDENTITY won't work the way you think it will if a trigger is involved and you should always plan on someone adding such a thing in 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)

March 8, 2012 at 6:39 am

#1456489
RE: Update with cursors

SKYBVI (3/6/2012)
Hi,
I have a table which has itemno,itemID,newprice,oldprice,changedate,seqid
the data is like this :-
a123 12345 5.50 2.30 2012-03-06 1
a123...
--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)

March 7, 2012 at 7:55 am

#1456026
RE: Problem to write Special Function

Golden_Behzad (3/7/2012)
For Create Function For SequenceID YouCan Use This Function But This Function Is Very Bad Performance and If multi user call this in some time generate duplicate id .
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)

March 7, 2012 at 7:40 am

#1456009
RE: create a constraint over 30 columns to have a Unique combination

Nicolas BrainPowered.Net (3/7/2012)
i find this solution very loose (if not wrong) *but* it delivers the goods.
after implementing the above checksum() i have successfully added a unique index over this column.
I'm...
--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)

March 7, 2012 at 7:36 am

#1456002
RE: Recursion - find last child

Hang on a minute while I get the egg off my face. 🙂 I saw that just before you posted and corrected my post.
--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)

March 7, 2012 at 6:59 am

#1455964
RE: Recursion - find last child

~~I guess I don't understand why you need recursion for this at all. If the NEWID doesn't appear in the OLDID column, then it is a leaf level node.~~
{EDIT}......
--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)

March 7, 2012 at 6:52 am

#1455959
RE: Are the posted questions getting worse?

Koen Verbeeck (3/7/2012)
[/url]
(if SOPA got through, this site could be taken down)
Not without due process of proper notification and the opportunity to comply. 😉
--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)

March 7, 2012 at 6:39 am

#1455950
RE: Constant Deadlocks on Production

ssdba (3/7/2012)
Thanks Michael & Jeff,
Already feeling a bit relieved by the response.....though I am yet to implement it & see any difference.
Feels great to know ppl have actually gone ahead...
--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)

March 7, 2012 at 6:31 am

#1455943
RE: Three Attack Vectors in SQL Server 2005

I used to take exception to these types of articles. My thought was "Are you nuts? Why would you teach the world how to hack?"
After seeing what many...
--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)

March 7, 2012 at 6:17 am

#1455932
RE: Multiple count() in a single SQL

siva 20997 (3/7/2012)
I have read the article "Converting Rows to Columns".
I dont undertand why at the start we are using the case stament to split it into 4...
--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)

March 7, 2012 at 6:05 am

#1455922
RE: Multiple count() in a single SQL

Sean Lange (3/6/2012)
I sort of remember that thread too. I think that Jeff was trying to say that the "best" solution did not need to use a pivot. I 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)

March 6, 2012 at 11:26 pm

#1455746
RE: Multiple count() in a single SQL

SQLKnowItAll (3/6/2012)
siva 20997 (3/6/2012)
are you saying my method was faster even with the UNION ?
Why are you obsessed with speed? Did you not see the reads and scans?
Nah... he'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)

March 6, 2012 at 11:18 pm

#1455743

Viewing 15 posts - 30,826 through 30,840 (of 59,101 total)