Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,986 through 21,000 (of 59,098 total)

RE: very slow INSERT to #tmptable

Just a curious shot in the dark on this... what is the default collation of the database you're select from and what is the default collation of TempDB?
--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 21, 2015 at 8:28 am

#1792424
RE: Worthwhile to use unique custom Error Numbers for THROW statements?

You don't have to put messages in sys.messages to do what you want with RAISERROR.
--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 20, 2015 at 11:07 pm

#1792287
RE: Querying Active directory

It has been quite a while. Over a year. Thanks for the vote of confidence, Dwain. Much appreciated.
--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 20, 2015 at 7:39 pm

#1792273
RE: Querying Active directory

dwain.c (4/20/2015)
Jeff Moden (4/20/2015)
L30 (4/15/2015)
Ah... apologies asene, I should have read it more thoroughly. So you want to query a nested group?
If so I found this on StackOverflow
http://stackoverflow.com/questions/13914698/query-ad-group-membership-recursively-through-sql
Thanks for 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)

April 20, 2015 at 7:15 pm

#1792271
RE: Is temporary table creation and dropping logged anywhere in SQL SERVER?

Sorry. I can help thinking about that. Auditing the content of temp tables. If someone insisted that I make that a priority at work and insisted 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)

April 20, 2015 at 7:08 pm

#1792270
RE: Embrace Stored Procedures

IceDread (4/20/2015)
Jeff Moden (4/20/2015)
Yet Another DBA (4/20/2015)
Jeff Moden (4/18/2015)
I read Rob's article when it first came out. What a refreshing change it was from the dogma that I've been...
--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 20, 2015 at 6:16 pm

#1792259
RE: Embrace Stored Procedures

RonKyle (4/20/2015)
There are no "ivory towers" where I work
There are no ivory towers where I work either. But there is the expectation that all know and understand best...
--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 20, 2015 at 11:15 am

#1792173
RE: Querying Active directory

L30 (4/15/2015)
Ah... apologies asene, I should have read it more thoroughly. So you want to query a nested group?
If so I found this on StackOverflow
http://stackoverflow.com/questions/13914698/query-ad-group-membership-recursively-through-sql
Thanks for that link. 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)

April 20, 2015 at 11:06 am

#1792170
RE: Running Ola script and getting error

I'll add to that by saying that people shouldn't really be posting for help on Ola's stuff here. His documentation on his code is very well written and if...
--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 20, 2015 at 10:59 am

#1792169
RE: Is temporary table creation and dropping logged anywhere in SQL SERVER?

GilaMonster (4/20/2015)
The default trace does log temp table creates and drops.
Awesome! Thanks, Gail!
--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 20, 2015 at 9:39 am

#1792119
RE: SSMS hesitation

Brandie Tarvin (4/20/2015)
In other words, applying the post SP1 CU3 pack isn't going to fix the issue.
Happy Happy Joy Joy.
Thanks, all.
True dat! 😀
--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 20, 2015 at 9:37 am

#1792117
RE: Embrace Stored Procedures

RonKyle (4/20/2015)
I agree with the previous comment regarding language. We should be able to express ourselves more professional. I'm not above swearing, but I don't swear at others...
--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 20, 2015 at 9:32 am

#1792111
RE: Embrace Stored Procedures

bdenning (4/20/2015)
I started to read this article and didn't get past the first paragraph. Why technical people resort to street language to express themselves is beyond me. I...
--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 20, 2015 at 9:15 am

#1792085
RE: Embrace Stored Procedures

ddriver (4/20/2015)
So the database is the center of the universe just because turning it off brings the system down? You could say the same thing about a router, a switch,...
--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 20, 2015 at 9:06 am

#1792073
RE: Embrace Stored Procedures

ddriver (4/20/2015)
So the database is the center of the universe just because turning it off brings the system down? You could say the same thing about a router, a switch,...
--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 20, 2015 at 9:03 am

#1792069

Viewing 15 posts - 20,986 through 21,000 (of 59,098 total)