Jeff Moden

Forum Replies Created

Viewing 15 posts - 38,596 through 38,610 (of 59,072 total)

RE: Missing numbers in a series

Paul White NZ (5/5/2010)
What impressed me about the SQLCLR solution (even though it came second!) is that it managed to get close at all. The overhead of passing it nearly...
--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)

May 5, 2010 at 3:51 pm

#1162850
RE: Allowing access to tempdb

Brian Brown-204626 (5/5/2010)
The user is insisting that they need the access to tempdb to find the temp table names they have created.
I guess I don't understand... how would they know...
--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)

May 5, 2010 at 3:25 pm

#1162836
RE: time function

Unless you have some indication of time in the table or you run the job once an hour automatically whilst capturing the value of an IDENTITY column as a marker...
--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)

May 5, 2010 at 3:15 pm

#1162830
RE: time function

Keep it simple, keep it sargeable, keep it fast...
WHERE SomeDateTimeColumn >= DATEADD(hh,-1,GETDATE())
I'd also recommend against using any version of the 23:59:59.xxxxxxx stuff.
--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)

May 5, 2010 at 2:41 pm

#1162801
RE: Missing numbers in a series

Paul White NZ (5/5/2010)
Weird huh?
Heh... it's not a fault... it's a feature. Gives folks more time to take a sip of Scotch whilst waiting for their code to run.
Thanks...
--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)

May 5, 2010 at 2:12 pm

#1162777
RE: Finding "strings" without extensions

Ummmm.... wouldn't you just find all the names that don't have a period in them? i.e. Use CHARINDEX or NOT 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)

May 4, 2010 at 4:33 pm

#1162161
RE: Inserting data into a Table with no Identity Column

Paul_Harvey (5/4/2010)
I am using a SSIS package to synchronise data between my data warehouse main tableset, and an application database.
The application database has no identity column, but the application itself...
--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)

May 4, 2010 at 4:29 pm

#1162160
RE: table backup

ramyours2003 (5/4/2010)
how can we take table backup in a database in sql 2005 , other than export/import wizard .
can any one send the query 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)

May 4, 2010 at 4:23 pm

#1162156
RE: How long to build index

SQLJocky (5/3/2010)
Jeff Moden (5/3/2010)
SQLJocky (5/3/2010)
Is there anything that can tell me how long it might lock down my table if I add a new index? We are running 2005...
--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)

May 4, 2010 at 4:19 pm

#1162153
RE: Expression problem displaying rolling weekly/daily/monthly average

niccolem (5/4/2010)
Thanks a lot, I figured it out by using first/last day of month
Are you passing those as a parameter? If so, what happens if someone forgets some 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)

May 4, 2010 at 4:08 pm

#1162147
RE: very simple update statement question

Very cool of you to comeback, Henrik. Thank you much and thanks for taking the time to "repost" your problem. 🙂
--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)

May 4, 2010 at 3:52 pm

#1162144
RE: Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

Doug Bass (5/4/2010)
Another excellent article, Jeff. I liked it as much as, or better than, part one. I especially liked your usage of concatenation to generate the 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)

May 4, 2010 at 11:54 am

#1162004
RE: Missing numbers in a series

Jeff Moden (5/4/2010)
Hey guys.... just ignore this post... I was testing our Injection Blocker for anything that contains 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)

May 4, 2010 at 10:58 am

#1161955
RE: Missing numbers in a series

Paul White NZ (5/4/2010)
Jeff Moden (5/4/2010)
Absolutely. You know me... I never turn down knowledge. Thanks, Paul.
Hey Jeff and Mr Coffee - I'm not saying a SQLCLR solution won'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)

May 4, 2010 at 10:29 am

#1161936
RE: very simple update statement question

henrik.bernhard (5/4/2010)
never mind - found a trigger to cause this issue.
In the future, please don't delete your original post just because you found a fix. Someone might be able...
--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)

May 4, 2010 at 10:23 am

#1161930

Viewing 15 posts - 38,596 through 38,610 (of 59,072 total)