Jeff Moden

Forum Replies Created

Viewing 15 posts - 30,856 through 30,870 (of 59,101 total)

RE: Large table cleanup with minimal locks

TheSQLGuru (3/6/2012)
Note that the locks taken for the DELETE in this case could be PAGE locks, in which case there could be potentially hundreds of thousands of rows available 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)

March 6, 2012 at 8:02 pm

#1455700
RE: Large table cleanup with minimal locks

SAinCA (3/6/2012)
(Not my architecture, so please avoid commenting on the presence of RBAR :-D)
Heh... you posted it so if there were comments to be made about RBAR, you'd just...
--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 7:50 pm

#1455699
RE: Large table cleanup with minimal locks

jay.dunk (3/6/2012)
Using nolock is quite risky and is getting used more and more these days to avoid locks, but it DOES come with issues which i only found out 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)

March 6, 2012 at 7:43 pm

#1455698
RE: Incrementing a table name

I haven't tested it yet but I believe your main problem is that you used SMALLDATETIME in the tables which are accurate only to the nearest minute.
--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 4:31 pm

#1455667
RE: Select columns dynamically

jcb (3/6/2012)
Well, I wrote a more generic solution to any user table.
create table TESTE (PK int, C1 char(1), C2 char(1), C3 char(1), C4 char(1), C5 char(1))
GO
insert into TESTE values
(1, '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)

March 6, 2012 at 4:26 pm

#1455666
RE: Problem to write Special Function

We have the ol' language barrier thing going on here. I know you want to change the GUI to a "sequence" and that you think you need a function...
--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 4:21 pm

#1455664
RE: Column Name Restrictions / Description Keyword

SQLKnowItAll (3/5/2012)
I like to describe my descriptions 🙂 (Sorry, I couldn't figure out a better way.) So, in a Product table I may use a column name of prodDesc,...
--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 6:22 am

#1455251
RE: convert rows into columns

chandarcst (3/5/2012)
Hi,
I want to learn sql and tell me the way
Let me ask the questions that we should have asked at the beginning. How long have you been using...
--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 6:16 am

#1455248
RE: Incrementing a table name

p.s. There shouldn't have been a problem with the original peice of code you posted unless you had something else in the WHERE clause that was causing 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)

March 6, 2012 at 6:12 am

#1455247
RE: Incrementing a table name

I'm pretty confused, right now. Guess I've not had enough coffee, yet. I see no differences between the first two peices of code above.
{Edit} I was right......
--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 6:09 am

#1455243
RE: Problem to write Special Function

Golden_Behzad (3/6/2012)
Hello.Sorry For This Delay.
This is Very good suggest .
but i connote used this suggest
because my application have about 20 user
and for do this action i must be recreate my...
--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 6:05 am

#1455241
RE: Week Starts On Saturday?

Hi Terry,
Thanks for the feedback. Heh... since you recognized it as "integer truncation", I'm pretty sure that I don't actually know more than you. 🙂 I just 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)

March 5, 2012 at 10:32 pm

#1455102
RE: Select columns dynamically

Jeff Moden (3/5/2012)
I'm on my way to work and will have a go at it after I get home tonight. Chances are, someone will beat me to it, though....
--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 5, 2012 at 6:10 pm

#1455081
RE: SELECT to transform a csv of INT into VARCHAR

Eric M Russell (3/5/2012)
Henk Schreij (3/5/2012)
What I learned from this discussion is: there is no easy 'set based' solution to the problem of unwrapping a csv with sql.
(a solution,...
--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 5, 2012 at 2:34 pm

#1455015
RE: Sql sever 2008 advice

ddafunk (3/5/2012)
ok i get what you saying , i want to install on my virtual box running server 2008 r2 sql,i am just going to download the trial 180days version...
--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 5, 2012 at 8:14 am

#1454811

Viewing 15 posts - 30,856 through 30,870 (of 59,101 total)