Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,811 through 36,825 (of 59,072 total)

RE: increment string in vchar column

WayneS (9/15/2010)
Jeff Moden (9/14/2010)
I may be missing it but it doesn't look like there's anything that will prevent someone from using the max number you get in the first CTE...
--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)

September 15, 2010 at 8:50 am

#1221396
RE: Populate large data

Dung Dinh (9/14/2010)
I only use script(s) to transfer data.
We'll probably need to see those and a couple of other things. Take a look at the article found at 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)

September 14, 2010 at 9:48 pm

#1221109
RE: Changing from INSERT INTO...SELECT (with a UNION) to SELECT INTO

LutzM (9/14/2010)
Jeff Moden (9/14/2010)
Agreed. SELECT DISTINCT usually indicates that more than 1 of the exact same row was created. That usually means the join criteria was NOT sufficient...
--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)

September 14, 2010 at 9:21 pm

#1221106
RE: Searching for Plans

The Dixie Flatline (9/13/2010)
Especially since you could ruin a lot of monitors by throwing pork chops through them.
Ya know, the new thin screens just can't take a direct hit 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)

September 14, 2010 at 8:52 pm

#1221105
RE: increment string in vchar column

WayneS (9/14/2010)
a.borgeld (9/14/2010)
BCP is very cool.
Guys with your information and information from Ray Wong i created a function with a loop.
This works.
But i told you about the table who needs...
--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)

September 14, 2010 at 8:40 pm

#1221103
RE: increment string in vchar column

scott.pletcher (9/13/2010)
You should split the alpha and numeric for storage. Don't fall into the trap of feeling you have to store what is displayed / entered.
So, create two physical...
--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)

September 14, 2010 at 8:16 pm

#1221095
RE: Blocking on tempdb system tables

Derrick Smith (9/14/2010)
It's the combination of that and creating it in a transaction thats causing the issue here. SQL needs to keep the lock on those tables in case you...
--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)

September 14, 2010 at 8:08 pm

#1221093
RE: Blocking on tempdb system tables

ken.yannitell (9/14/2010)
Use this statement at the top of your query:
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
This will make any table look up perform the same as the Hint (With...
--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)

September 14, 2010 at 8:07 pm

#1221091
RE: slow running query/queries

Krishna Potlakayala (3/16/2009)
Good advise above, but above all this it is always a good practice to create a baseline of your workload , later you can compare the monitoring activity...
--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)

September 14, 2010 at 2:32 pm

#1220993
RE: Perform logical AND/OR base on number of rows without dynamic SQL

shield_21 (9/12/2010)
I know it will be quite pointless to post the simpler version, since I'll be moving to XML
Let us know how that works out performance wise. I believe...
--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)

September 14, 2010 at 2:27 pm

#1220987
RE: Are the posted questions getting worse?

CirquedeSQLeil (9/14/2010)
Has anybody else noticed that Steve is now "One Orange Chip"?
Oh lordy... I wonder what he's done to me this time. 😛
--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)

September 14, 2010 at 2:21 pm

#1220978
RE: Convert negative varchar value to negative numeric

coenie-353912 (9/14/2010)
Thanks SSC-Enthusiastic
this worked for me, I forgot to mentioned that some values be negative, but this works
DECLARE @l_CharVal VARCHAR(20)
SET @l_CharVal = ' 50.12- ...
--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)

September 14, 2010 at 7:32 am

#1220666
RE: What login should a DBA use for non-emergency work

torpkev (9/13/2010)
sa account itself should be disabled, if you need mixed mode, fine, create an sa like user, but not 'sa'.. where possible use windows authentication for connecting, and set...
--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)

September 14, 2010 at 7:27 am

#1220660
RE: Need to compare two columns

scott.pletcher (9/13/2010)
Hopefully the code below will let you "invalid date" errors. You can't really guarantee that SQL will perform the checks in the order you want, but hopefully 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)

September 14, 2010 at 7:24 am

#1220657
RE: Query never finishing

It sounds to me like the reporting server tried to do it all in memory and simply went to the swap file mode. Could be wrong but I'd look...
--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)

September 14, 2010 at 7:22 am

#1220654

Viewing 15 posts - 36,811 through 36,825 (of 59,072 total)