Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,956 through 20,970 (of 59,072 total)

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

GilaMonster (4/20/2015)
Jeff Moden (4/20/2015)
GilaMonster (4/20/2015)
The default trace does log temp table creates and drops.
Awesome!
Not usually. 🙂
It's one reason why the default trace sometimes covers such a short time period....
--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 9:05 am

#1792448
RE: SSIS 2008 – Read roughly 50 CSV files from a folder, create SQL table from them dynamically, and dump data.

ankithimmatlalshah (4/20/2015)
Hello Phil,
I'm really sorry, it's yourself only.
Instead of Phil I specified Chris in my previous reply.
Client has provided one PDF file that contains the details about each column 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)

April 21, 2015 at 9:03 am

#1792445
RE: Embrace Stored Procedures

Charles Kincaid (4/21/2015)
We have been out of 9 digit Social Security Numbers for quite a while. Old ones are being reissued making the whole identity theft thing even harder 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)

April 21, 2015 at 8:55 am

#1792440
RE: Embrace Stored Procedures

TomThomson (4/20/2015)
Interesting discussion.
I think Conery's article is excellent, never mind the phrasing look at what is being said.
It's a pity that some people seem to believe that using stored procedures...
--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:39 am

#1792429
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

Viewing 15 posts - 20,956 through 20,970 (of 59,072 total)