Jeff Moden

Forum Replies Created

Viewing 15 posts - 25,096 through 25,110 (of 59,099 total)

RE: SYNTAX Help please...

ScottPletcher (12/18/2013)
Evil Kraig F (12/18/2013)
Scott,
I'm not sure how that's more or less obscure, but it's certainly easier for me to read. I work with a lot of 'iffy' data...
--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)

December 18, 2013 at 8:24 pm

#1674695
RE: SYNTAX Help please...

ScottPletcher (12/18/2013)
Lynn Pettis (12/18/2013)
Lynn Pettis (12/18/2013)
Luis Cazares (12/18/2013)
ScottPletcher (12/18/2013)
Better to avoid ISNULL, since you should never use it in a WHERE clause. I also think that exactly what's being...
--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)

December 18, 2013 at 8:17 pm

#1674694
RE: GETUTCDATE() return null

I take that back... that's actually an illegal form of update that will sometimes work and sometimes not. I'll explain more after I see the rest of the code...
--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)

December 18, 2013 at 8:14 pm

#1674693
RE: GETUTCDATE() return null

ali.m.habib (12/18/2013)
I have trigger after Insert that update field in the table with GETUTCDATE() but after Insertion I see the value = null
SET NOCOUNT...
--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)

December 18, 2013 at 8:12 pm

#1674692
RE: Pass SSIS Object to child SSIS package

Nice trick. It's also another notch on a 2x4 list of reasons why I try to do everything in T-SQL. 😉
--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)

December 18, 2013 at 8:11 pm

#1674691
RE: Need help with 2 query plans

sgmunson (12/18/2013)
That's really interesting behavior, and quite an improvement in the optimizer. Although, I wonder if, having figured out that SQL 2014 will start to allow you 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)

December 18, 2013 at 7:59 pm

#1674689
RE: How to avoid KeyLookpu in Execution Plan of a Query ?

ScottPletcher (12/18/2013)
If your lookups will most often be by column2, you need to cluster the table on column2, or an encoded version of it, rather than having a dopey, useless...
--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)

December 18, 2013 at 7:49 pm

#1674686
RE: Running a sqlcmd from Remote Machine

Which C: drive are you trying to write to? It's not going to write to your local C: Drive from a remote machine. You need to use UNCs...
--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)

December 18, 2013 at 7:45 pm

#1674684
RE: Data truncation on MAX column through linked server

Paul White (12/18/2013)
Jeff Moden (12/18/2013)
Voted up. Waiting for the normal response of "Closed - Will not fix". 😉
Also up-voted and marked as reproducible. Wrong-results bugs usually get a high...
--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)

December 18, 2013 at 7:33 pm

#1674682
RE: Need help in SP

Zohaib Anwar (12/18/2013)
Hi All I have following two stored Procedures and I want to create 3rd one which will take the values of both 1st and 2nd SPs and Subtract...
--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)

December 18, 2013 at 1:53 pm

#1674618
RE: Need help in SP

amy26 (12/18/2013)
So, wherever you go...there you are? 😀 Hehe, sorry couldn't resist. 🙂
DBCC TIMEWARP on sterioids. '-)
--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)

December 18, 2013 at 1:29 pm

#1674611
RE: Multiple Cases

sharonsql2013 (12/18/2013)
I need to count all the records that meet the conditions in the case statement.
Following is the select after the CTE1 to display the count if each of 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)

December 18, 2013 at 1:25 pm

#1674609
RE: Query error: Column name or number of supplied values does not match table definition.

Kurt W. Zimmerman (12/17/2013)
I have always made it a practice that when I'm inserting into or selecting out of a table I always specify the columns. In your case...
--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)

December 18, 2013 at 1:18 pm

#1674607
RE: Best Practice Question - Reference Tables

amy26 (12/18/2013)
Hello, I am writing to see what the best practice or just how other people handle this case with reference tables.
I am working with a legacy db system 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)

December 18, 2013 at 1:15 pm

#1674606
RE: Need help in SP

Heh... Good Lordy!!! THIS type of thing is the perfect reason for why a simple comment or two is necessary in code.
I might be missing a nuance here...
--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)

December 18, 2013 at 1:06 pm

#1674601

Viewing 15 posts - 25,096 through 25,110 (of 59,099 total)