Jeff Moden

Forum Replies Created

Viewing 15 posts - 39,916 through 39,930 (of 59,072 total)

RE: Bulk Data Transfer

If T-SQL killed the server or uses as much resources as you say for such a simple ETL process, the T-SQL was simply written incorrectly.
--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)

February 5, 2010 at 4:16 pm

#1114840
RE: Are the posted questions getting worse?

GilaMonster (2/5/2010)
Luke L (2/5/2010)
Yes, but you'll have to wait for Gail's Blog post on DBCC TimeWarp to make certain you get all 137 non-optional parameters correct.
btw, as an aside, 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)

February 5, 2010 at 4:07 pm

#1114838
RE: INT to Bit

Very cool. Thanks Johan.
--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)

February 5, 2010 at 11:59 am

#1114694
RE: INT to Bit

Tara-1044200 (2/4/2010)
Actually.. I am sorry, i do have indexes.
I am changing INT data type to BIT, does it not save any sapce to me ?
Like ALZDBA stated, 3 bytes 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)

February 5, 2010 at 9:23 am

#1114552
RE: Generating HTML TABLE from a select query

Ramesh Saive (2/5/2010)
Jeff Moden (2/4/2010)
I'm not sure that it will do exactly what you want and I believe it's been deprecated in 2k5, but take a look at sp_MakeWebTask 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)

February 5, 2010 at 9:20 am

#1114547
RE: Calculating Work Days

I saw a tight little forumula for this about a year ago... I'm not sure where I put it but I'll try to find it this weekend.
--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)

February 5, 2010 at 9:17 am

#1114542
RE: Today's Random Word!

porkchop-ate 😀
--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)

February 4, 2010 at 10:17 pm

#1114177
RE: Today's Random Word!

insinuate
--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)

February 4, 2010 at 10:17 pm

#1114176
RE: Solving the "Running Total" & "Ordinal Rank" Problems (Rewritten)

Hugo... my sincere apologies for not addressing you tonight. I worked late and I wanted to address Tony's posts first. I'll try to address your good concerns tomorrow...
--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)

February 4, 2010 at 9:11 pm

#1114167
RE: Solving the "Running Total" & "Ordinal Rank" Problems (Rewritten)

--------------------------------------------------------------------------------------------------------------------------------------
tony rogerson (2/4/2010)
Also - the warning is just that other people have been bitching that this feature is undocumented rather than an up front warning that "never ever use this...
--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)

February 4, 2010 at 9:07 pm

#1114166
RE: Table Properties export

Sorry... posted to the wrong thread...
--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)

February 4, 2010 at 9:04 pm

#1114164
RE: Generating HTML TABLE from a select query

I'm not sure that it will do exactly what you want and I believe it's been deprecated in 2k5, but take a look at sp_MakeWebTask in Books Online.
--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)

February 4, 2010 at 3:45 pm

#1114057
RE: WHILE LOOP vs. Recursive SQL

Nothing specific in the form of code to offer on this but I've found that recursive CTE's are slower than While Loops and they generate a whole lot more reads.
--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)

February 4, 2010 at 3:40 pm

#1114054
RE: BULK INSERT eliminating quotes

Does the file you're trying to import have a header? If so, it must have exactly the same delimiters even to skip it.
--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)

February 4, 2010 at 3:37 pm

#1114053
RE: Calling a powershell script from TSQL

Brad Picone (2/4/2010)
Thanks Jeff, Setting up of a proxy account has been mentioned although I still don't think its gone down too well with the DBA's. But I don't think...
--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)

February 4, 2010 at 3:04 pm

#1114039

Viewing 15 posts - 39,916 through 39,930 (of 59,072 total)