Jeff Moden

Forum Replies Created

Viewing 15 posts - 24,721 through 24,735 (of 59,099 total)

RE: Insert or update

Like I said, it's probably an interview question where there's not an actual correct answer other than "It Depends". It's a nice short question that requires a lot of...
--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)

January 19, 2014 at 12:11 pm

#1681404
RE: Unable to start sql server service

ramadesai108 (1/18/2014)
Hello,
I searched on the internet for hours but cannot resolve my issue, so this is my last resort.
I have 2 instances of SQL Server 2012 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)

January 18, 2014 at 10:33 pm

#1681376
RE: Need to create table relationships

ramadesai108 (1/18/2014)
I have categories, sub-categories, sub-sub-categores and a product name. I will create Categoes table, sub-categories table and sub-sub-categories table. There may be just categories without sub-categories and there may...
--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)

January 18, 2014 at 10:24 pm

#1681374
RE: Insert or update

ramana3327 (1/18/2014)
Hi,
I have a table with some columns & rows. I want to do insert and update on that table. Which action is faster inserting 1 row or updating 1row?...
--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)

January 18, 2014 at 10:18 pm

#1681373
RE: SQL single column rows into multiple columns

rabih_karam (1/18/2014)
I think we need more clarification about your case
But i have a solution for you as i understand from your question
Declare a table and then select your column...
--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)

January 18, 2014 at 9:53 pm

#1681372
RE: SQL single column rows into multiple columns

Johnny D (1/18/2014)
Thanks Jeff,
That is exactly what I needed. I would have never have thought of that approach to solving it. I was trying all kinds of tricks including putting...
--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)

January 18, 2014 at 9:49 pm

#1681371
RE: Running Total

pietlinden (1/18/2014)
Is the same true if you use a common table expression to calculate the running total?
Yes except that it's likely that the CTE will use more reads than 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)

January 18, 2014 at 9:45 pm

#1681370
RE: SQL single column rows into multiple columns

Johnny D (1/18/2014)
Hi All,
Thank you for your input thus far.
To tell you what I have tried so far. I have had an attempt using SSIS but as I am new...
--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)

January 18, 2014 at 12:07 pm

#1681354
RE: Redundant Redundancy

Oooooo... very nice article, Rodney. It really hit a sweet spot with me because I'm taking care of a disk space problem tonight during the "maintenance period" and I'm...
--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)

January 18, 2014 at 9:48 am

#1681346
RE: Running Total

a4apple (1/17/2014)
refer to this post...
http://sqlsaga.com/sql-server/how-to-calculate-running-totals-in-sql-server/%5B/url%5D
step by step explained...
Same thing there. It's a Triangular Join. No matter what, it will always use more resources than you could possibly imagine....
--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)

January 18, 2014 at 9:28 am

#1681344
RE: Running Total

Ford Fairlane (1/15/2014)
Refined and resolved !!!
Thanks for all your input.
This is the working query.
SELECT
YEAR(CAST (a.ENDDATE AS DATETIME)),
MONTH(CAST (a.ENDDATE AS DATETIME)),
(
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)

January 18, 2014 at 9:24 am

#1681343
RE: Create temp table using store prodecure

Just create the Temp Table using a CREATE TABLE statement (Temp Table names begin with the # sign) and then use normal inserts to populate it.
Temp Tables have 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)

January 18, 2014 at 9:12 am

#1681341
RE: Copy logins with their password

Lowell (1/17/2014)
microsoft supplies a proc named sp_help_revlogin here that scripts out sql users with hashed passwords, for importation onto other servers.
you'll need to grab the right version off 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)

January 18, 2014 at 8:54 am

#1681340
RE: SQL single column rows into multiple columns

Lynn Pettis (1/18/2014)
rabih_karam (1/18/2014)
I think we need more clarification about your case
But i have a solution for you as i understand from your question
Declare a table and then 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)

January 18, 2014 at 8:39 am

#1681337
RE: Embedd Image from databse mail

Lowell (1/17/2014)
actually, using the content id (cid:) is the right way.
by leaving it out, you are just taking advantage of some email clients smart features of filling in missing tags,...
--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)

January 17, 2014 at 9:19 pm

#1681318

Viewing 15 posts - 24,721 through 24,735 (of 59,099 total)