Jeff Moden

Forum Replies Created

Viewing 15 posts - 51,301 through 51,315 (of 59,098 total)

RE: CLR Code to run Generic Command Prompt Commands

All the code blocks in that link show up as little red x's for me...
The thing I'm concerned about is that the word "loops" was mentioned in the test... testing...
--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)

April 2, 2008 at 2:49 pm

#797519
RE: Get the code from a System View

Heh... nope... different guy :hehe: ... the other one knew a lot more about the system... this one is on a steep learning curve for 2k5 and has seen 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)

April 2, 2008 at 2:42 pm

#797517
RE: Deleting millions rows from some tables

It is amazing that two copies and truncate could be so fast. Guess that's why lot so folks use it... so long as there aren't foreign keys, delete triggers,...
--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)

April 2, 2008 at 2:36 pm

#797515
RE: Setting multiple values

Sounds like a winner, J. Thanks for sharing the tips.
--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)

April 2, 2008 at 2:32 pm

#797512
RE: Hardware Issues

Steve Jones - Editor (4/2/2008)
I think that's "if your friends jumped bridge..." 😉
Heh... nope... me and my friends used to jump off bridges for fun... Mom didn't mind because we...
--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)

April 2, 2008 at 2:31 pm

#797511
RE: Pros & Cons of Windows vs Mixed Authentication

Steve Jones - Editor (4/2/2008)
Hate to deviate, but apart from what's put down already, both Windows and SQL auth suffer from the problem that anyone can connect with any application...
--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)

April 2, 2008 at 2:25 pm

#797508
RE: I need to add the last day of the month to a result from a column containing only year and month

ALZDBA (4/2/2008)
And I've always been trying to avoid implicit conversions ......... :hehe:
Apparently, even on a million rows... makes no moxnix...
DECLARE @Bitbucket datetime
SET STATISTICS TIME ON
SELECT @Bitbucket = DATEADD(mm,1,EndDate+'01')-1
...
--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)

April 2, 2008 at 2:21 pm

#797506
RE: I need to add the last day of the month to a result from a column containing only year and month

ALZDBA (4/2/2008)
And I've always been trying to avoid implicit conversions
Heh... understood. I don't think they make a hoot in the SELECT list... but, I guess I'm gonna have...
--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)

April 2, 2008 at 12:16 pm

#797459
RE: Splitting Data from One Column into 5 Columns

antonio.collins (4/2/2008)
No fair working at night... my wife won't let me get geeky at night.
Heh... understood... I keep telling mine "How can I miss you if you won't go away?"...
--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)

April 2, 2008 at 12:13 pm

#797457
RE: Using SQL CLR to execute web services

Marios Philippopoulos (4/2/2008)
But... assuming they have valid reasons, how can this be done safely and what does it involve?
That much I do know... It's going to be just like any...
--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)

April 2, 2008 at 11:41 am

#797439
RE: Setting multiple values

J (4/2/2008)
Pressed "Post Reply" too quickly. Forgot to add this:
I have also used the approach of comma-separated single parameter but it has limitations:
- the is a practical limit to 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)

April 2, 2008 at 11:34 am

#797432
RE: IF (COLUMNS_UPDATED()) ???

Expensive move to compare all columns if you only care if a couple have been updated...
--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)

April 2, 2008 at 11:14 am

#797418
RE: Pros & Cons of Windows vs Mixed Authentication

That's a big one for me... the use of "Trusted Accounts" means that I don't have to hard-code user names or passwords in any code. Very big security advantage...
--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)

April 2, 2008 at 8:25 am

#797268
RE: Help Putting Stored Procedure In a Stored Procedure/View

Tim Riley (4/2/2008)
When I do that I receive the error::crying:
"Msg 8164, Level 16, State 1, Procedure sp_get_composite_job_info, Line 72
An INSERT EXEC statement cannot be nested."
There are 'INSERT' statements in various...
--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)

April 2, 2008 at 8:23 am

#797264
RE: Hardware Issues

On the subject of VM's... heh... Steve said he's got friends doing it... reminds me of what everyone's Mother in the World has probably said at one time or another......
--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)

April 2, 2008 at 8:15 am

#797256

Viewing 15 posts - 51,301 through 51,315 (of 59,098 total)