Jeff Moden

Forum Replies Created

Viewing 15 posts - 30,001 through 30,015 (of 59,101 total)

RE: query works but not in a view

PaulB-TheOneAndOnly (5/14/2012)
Jeff Moden (5/10/2012)
PaulB-TheOneAndOnly (5/10/2012)
Jeff Moden (5/9/2012)
PaulB-TheOneAndOnly (5/9/2012)
If MSTR_END on WHERE clause is causing the issue replace the condition with:
where TO_CHAR(MSTR_END,"DD-MON-YYYY") = ''01-JAN-1700''
IIRC, that'll make for a non-SARGable search predicate...
--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)

May 14, 2012 at 7:51 pm

#1487500
RE: Switching number with counting

athens1234 (5/14/2012)
Thanks, Eugene Elutin.
I just did run your sql in my original pos data. It has same result of SAS!
It works fine!!
Only while you're looking. There is no guarantee...
--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)

May 14, 2012 at 7:47 pm

#1487499
RE: Exporting reports into excel

I have no clue how to do this but it sounds very interesting and I'd like to learn how to do this as well. The only thing I can...
--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)

May 14, 2012 at 7:39 pm

#1487498
RE: Delta Load strategy for fact and dimension tables

sql_dba123 (5/6/2012)
We may have to go with stored procs being called from scheduled jobs for on-prem version and schedule a job using worker threads for Azure version. Is there 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)

May 14, 2012 at 7:23 pm

#1487494
RE: Where should I put the tempdb log file ?

The way I'd handle it is to ask the san folks to reconfigure the TempDB LUN to Raid 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)

May 14, 2012 at 7:17 pm

#1487491
RE: Best Practice for LDF location

Crud. I really do need to learn to scroll down. Gail already answered 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)

May 14, 2012 at 7:11 pm

#1487490
RE: Best Practice for LDF location

rummings (5/14/2012)
I read an article that stated that the .mdf and .ldf should be on different disks. Each time I create a new database, I make sure to adhere 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)

May 14, 2012 at 7:09 pm

#1487488
RE: How to load a temp table with the result set of a sproc

Here's an example that serves me very well for some of the larger ETL projects I work on. Do note that you have to change "yourseverinstancenamehere" appropriately.
SELECT IDENTITY(INT,1,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)

May 14, 2012 at 6:49 pm

#1487484
RE: How to load a temp table with the result set of a sproc

dndaughtery (5/14/2012)
I need to load a temp table with the result set from a sproc sort of like the following:
Select into #Temp
Exec usp_LoadTemPTableSproc
How can I do this?
You can use SELECT...
--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)

May 14, 2012 at 6:42 pm

#1487483
RE: How to load a temp table with the result set of a sproc

Geoff A (5/14/2012)
Hi Lynn,
Q1: Why were table variables introduced when temporary tables were already available?
A1: Table variables have the following advantages over temporary tables: •As mentioned in the SQL Server...
--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)

May 14, 2012 at 6:38 pm

#1487482
RE: Converting first letter of every word to uppercase

Nope... even "worse". PATINDEX.
--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)

May 14, 2012 at 6:21 pm

#1487479
RE: Catching the source for a Server hang/deadlock

I agree... it sounds like it very well could be deadlocks. I'd make sure to enable the correct trace flags so that the SQL Server error logs will capture...
--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)

May 14, 2012 at 6:19 pm

#1487478
RE: Converting an integer to datetime

Lynn Pettis (5/14/2012)
Jeff Moden (5/14/2012)
dan-572483 (5/14/2012)
I stand corrected. Now why would a developer use anything other than a datetime to store a timestamp? It seems to lead 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)

May 14, 2012 at 6:13 pm

#1487476
RE: does ss2008 maintain an internal timestamp of data updates?

ScottPletcher (5/14/2012)
Either one.
Adding a rowversion column to every table would indeed be huge overhead for no real gain, since it likely would never be used. Eight bytes per row...
--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)

May 14, 2012 at 6:01 pm

#1487474
RE: Teambuilding and Bonding

Steve Jones - SSC Editor (5/14/2012)
I have found documentation to be key in my career for CYA, but mostly for just being aware of what was agreed to. My memory...
--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)

May 14, 2012 at 5:57 pm

#1487470

Viewing 15 posts - 30,001 through 30,015 (of 59,101 total)