Jeff Moden

Forum Replies Created

Viewing 15 posts - 27,751 through 27,765 (of 59,101 total)

RE: SELECT * INTO Table without propagating IDENTITY attribute?

PhilPacha (12/27/2012)
Using the simplest SELECT INTO syntax, the IDENTITY property of a column is part of the definition of the destination table. Is there a simple way to avoid 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)

December 27, 2012 at 8:46 am

#1571892
RE: EMC Upgrade caused SQL server to crash

JanetGee (12/27/2012)
We were upgrading our EMC SAN firmware online yesterday and it caused my server to crash.
Don't wait another minute. Get EMC on the phone and get them 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 27, 2012 at 8:41 am

#1571887
RE: Keeping all three environment(Dev,Stag,Prod) in sync

@SQLFRNDZ (12/26/2012)
Jeff Moden (12/26/2012)
@SQLFRNDZ (12/26/2012)
The best way is Logshipping depends on the daily load though...
Not really. "It Depends". SAN-based replication is nearly instantaneous and puts no load on...
--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 27, 2012 at 8:34 am

#1571881
RE: Hardware or Bad Queries = Performance issues?

Lynn Pettis (12/24/2012)
I may be wrong, so if I am please tell me so. Aren't logical reads reads from data cached in memory?
Like Gail said... Yes.
Would these be good...
--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 26, 2012 at 4:11 pm

#1571706
RE: Keeping all three environment(Dev,Stag,Prod) in sync

@SQLFRNDZ (12/26/2012)
The best way is Logshipping depends on the daily load though...
Not really. "It Depends". SAN-based replication is nearly instantaneous and puts no load on the production 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)

December 26, 2012 at 4:04 pm

#1571703
RE: Fragmentation size

zi (12/26/2012)
Dear Friends
1-1-How to know the fragmentation size for whole database not only for certain table, to decide if it exexceeds 30% to re-build index or re-organise.
2-what is the relationship...
--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 26, 2012 at 3:53 pm

#1571700
RE: Grow Your Skills

I can't speak for anyone else but every time (and without exception) that I've seen a company that I've worked for do anything with outsourcing, it has always costed a...
--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 26, 2012 at 3:30 pm

#1571698
RE: Today's Random Word!

[font="Arial Black"]SNOW[/font]!
--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 26, 2012 at 3:21 pm

#1571696
RE: Len did not display right size

ScottPletcher (12/26/2012)
It really looks like the column is "char(11)" and not "varchar(11)".
Can you verify the column's data type?
Char(11) and Varchar(11) should make no difference when it comes to LEN. ...
--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 26, 2012 at 12:35 pm

#1571639
RE: creating a table to show month and year

Sachin 80451 (12/3/2012)
I need to refer to a temp table which has all the months and dynamically shows the years.
for example I need rolling 12 months to show in...
--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 25, 2012 at 10:14 pm

#1571489
RE: Stripping out all non-numerical characters

Sachin 80451 (12/18/2012)
1. I would prefer t-SQL as CLR is way beyond my understanding
2. At the moment I'm not concerned about performance
I whole heartedly agree with #1 above. 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)

December 25, 2012 at 9:01 pm

#1571480
RE: Stripping out all non-numerical characters

Jeff Moden (12/18/2012)
@sachin,
I agree that the CLR Regex method should be the fastest although I've not seen any performance testing on it.
The questions I have for you is...
1. Can 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)

December 25, 2012 at 8:58 pm

#1571479
RE: Create Table and Bulk Insert

urso47 (12/25/2012)
Hope you had a great X'mas Eve!
Thank you and Merry Christmas!
It worked perfectly, even when I don't get whole understanding right now, but I will learn when practicing. 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)

December 25, 2012 at 3:30 pm

#1571460
RE: Why doesn’t ISNUMERIC work correctly? (SQL Spackle)

Thank you for your feedback, Neha05.
--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 25, 2012 at 10:36 am

#1571450
RE: Time - Adding minutes and seconds

Merry Christmas Dwain.
--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 25, 2012 at 7:46 am

#1571413

Viewing 15 posts - 27,751 through 27,765 (of 59,101 total)