Jeff Moden

Forum Replies Created

Viewing 15 posts - 31,021 through 31,035 (of 59,101 total)

RE: Attacking SSIS at last...ummm?...

Attacking SSIS at last...
I finally started doing the same thing and had to stop. They really took serious offense to me hitting the server with a bat.
--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 24, 2012 at 2:23 pm

#1451600
RE: Script to find all objects owned by a user (loginname)

sgtmango333 (2/24/2012)
Well I tried and couldn't get it to work. So if you know the secret, please share. I spent half a day trying and it kept failing.
Here'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)

February 24, 2012 at 2:03 pm

#1451589
RE: Script to find all objects owned by a user (loginname)

sgtmango333 (2/24/2012)
Well I tried and couldn't get it to work. So if you know the secret, please share. I spent half a day trying and it kept failing.
Were...
--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 24, 2012 at 1:39 pm

#1451584
RE: Script to find all objects owned by a user (loginname)

sgtmango333 (2/1/2012)
You can't execute the sql generated once the character string gets over 8000.
Absolutely NOT true. You can execute huge variables well beyond 8k using VARCHAR(MAX) and NVARCHAR(MAX) even...
--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 24, 2012 at 1:03 pm

#1451570
RE: Make Rows As Columns

moayad-alsaleh (2/20/2012)
Here is the Solution :
Damn... not enough coffee. I didn't see that before my previous post. That's pretty much the way I was going to suggest......
--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 24, 2012 at 5:30 am

#1451332
RE: Generating the (calender) date_dim in tsql with required columns

nhimabindhu (2/16/2012)
Hi can any one help how to write the procedure in tsql if i pass any year it has to generate that year calender as in the format...
--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 24, 2012 at 4:21 am

#1451300
RE: Putting JSON on an equal footing to XML

<Rant>
I know I'll probably be a voice of 1 but I have a serious hatred for most of markup languages. HTML is a fun little thing kind of 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)

February 22, 2012 at 7:39 pm

#1450639
RE: Make Rows As Columns

moayad-alsaleh (2/20/2012)
Dears ,
I have very hard View , that making the Rows to Column , but i couldn't Find the Solution for that
i have below view which is Steps done...
--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 22, 2012 at 7:14 am

#1450261
RE: Next Step in my Carrer

shiv-356842 (2/15/2012)
Hi Experts,
Can you please guide me, right im in L2 Core DBA, what is the next step i have to take?
I mean what kind of stuff i have 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)

February 22, 2012 at 6:59 am

#1450246
RE: Dynamic update query

Phil Parkin (2/21/2012)
Phil... go easy on us non-pro English abusers... we do this to help, not to get "A"s in grammer. I know many ESL's that absolutely trash the English...
--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 22, 2012 at 1:37 am

#1450109
RE: Remove SQL Logins from All Databases and SQL Server

Thanks for sharing your knowledge. I haven't tried it but it looks like the code won't actually work if the user owns something like a schema, etc.
--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 21, 2012 at 7:40 pm

#1450047
RE: Dynamic update query

Eugene Elutin (2/21/2012)
Just tried to be formal and not payed enough attention...
Could do just with:
"Now the question is, what OP really wants?"
Looks like we can re-name the forum to "English...
--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 21, 2012 at 10:05 am

#1449823
RE: SOPA and Censorship

Steve Jones - SSC Editor (2/20/2012)
The questions are framed in a strange way to me, since my blog is mine, not shared.
I wouldn't have voted for a SOPA bill that...
--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 21, 2012 at 8:18 am

#1449733
RE: insert sp_executesql and quotes roblem

Honestly, I'm seriously confused. Since you've already identified that there is a way to do this without the use of dynamic SQL, why do you insist on using dynamic...
--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 20, 2012 at 12:15 pm

#1449360
RE: SOPA and Censorship

george sibbald (2/20/2012)
Jeff Moden (2/19/2012)
Thanks for the feeback and the participation, Tom. I've got a feeling that a whole lot of people just aren't interested.
not uninterested - perhaps 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 20, 2012 at 12:07 pm

#1449358

Viewing 15 posts - 31,021 through 31,035 (of 59,101 total)