Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,396 through 37,410 (of 59,098 total)

RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

Toby Harman (8/6/2010)
As an aside (and without reading all 20 pages on this thread) I played around with the PIVOT operator on a SELECT statement and found some interesting performance...
--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)

August 6, 2010 at 3:41 am

#1203326
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

srweal (5/6/2010)
You are a gun Jeff. Got this tasty article in my inbox and was so glad I stopped by for a read. PIVOT scared me off 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)

August 6, 2010 at 3:40 am

#1203323
RE: TSQL or SSIS

KBSK (8/5/2010)
KBSK (8/4/2010)
Jeff Moden (8/2/2010)
It's sometimes difficult to "fight city hall" and you may have to kowtow to their wishes by using SSIS... in which case, I can't help. 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)

August 5, 2010 at 9:25 pm

#1203236
RE: Rolling 3 Weeks

Heh... of course, how much are you actually going to trust an article that gives the following kind of bad advice??? :Whistling:
C. Searching for all datetime2 values in a day
•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)

August 5, 2010 at 9:13 pm

#1203235
RE: Rolling 3 Weeks

drew.allen (8/5/2010)
To add and subtract for all date and time data types, use DATEADD and DATEDIFF.
That's good enough reason for me.
I guess it's a matter of how you read something...
--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)

August 5, 2010 at 8:56 pm

#1203231
RE: Hi i am a sql dba.In my organizastion i am only the who will take care sql servers.2 servers are going to production within 2 days.

Well done on the handle change, Minto...
Getting back to your original problem... the recommendation that a lot of people make is to do daily full backups and transaction log...
--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)

August 5, 2010 at 8:38 pm

#1203230
RE: Null Fun

skcadavre (8/5/2010)
Steve Cullen (8/5/2010)
Note that you can do this:
SELECT 1 WHERE NULL is NULL
Indeed. Or even
SELECT CASE
WHEN NULL IS NULL...
--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)

August 5, 2010 at 8:28 pm

#1203229
RE: Null Fun

skcadavre (8/5/2010)
Jeff Moden (8/5/2010)
Nulls cannot be compared to anything, not even other Nulls. NULL = NULL returns false. NOT IN is like saying NULL <> NULL and even...
--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)

August 5, 2010 at 8:23 pm

#1203228
RE: how to update millions of records quickly........

gah (8/3/2010)
If its "wrong" to use the quiirky update in this manner....
Absolutely not wrong. Well done, Graham. Heh... I was going to write a second article 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)

August 5, 2010 at 8:11 pm

#1203224
RE: how to update millions of records quickly........

TheSQLGuru (8/3/2010)
Hmm, I thought the quirky update WAS primarily a performance tool since it can solve problems where you need a triangular join or actual TSQL cursor to get 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)

August 5, 2010 at 8:03 pm

#1203221
RE: Data Type size

Sanjay-940444 (8/5/2010)
but if we are using varchar datatype sql s. will reserve space as much required for actual value.Any say??
Yep... how many bytes does it take to store the number...
--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)

August 5, 2010 at 7:41 pm

#1203217
RE: CrossTab or Pivot

Novicejatt (8/5/2010)
Hi
I don't want to write a query for every week. I want that the query should recogonise any week like say within a year(or the date range specified).
I just...
--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)

August 5, 2010 at 7:34 pm

#1203214
RE: Casing For Built-In Function Names

Michael.D (8/5/2010)
Thanks, Jeff.
That's what I figured.
Out of curiosity, does it work as advertised in say, the Developer or Enterprise editions?
What a stupid little nicety to disable in 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)

August 5, 2010 at 7:29 pm

#1203211
RE: Trigger validate

monkeytesiorna (8/4/2010)
CREATE TRIGGER t_del_emp ON [dbo].[empmas]
FOR DELETE
AS
declare @empid varchar(10)
SELECT @empid=d.empid FROM DELETED d
declare @empdetid INT
IF EXISTS(SELECT * FROM empdet WHERE empid=@empid AND deactivated is null)
BEGIN
SET @empdetid = (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)

August 5, 2010 at 7:21 pm

#1203207
RE: Are the posted questions getting worse?

Steve Jones - Editor (8/5/2010)
Wish me luck. My PASS Board interview is tomorrow. We'll see if I'm still in the running after that.
Break a leg, Steve. You'll do well.
--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)

August 5, 2010 at 7:13 pm

#1203204

Viewing 15 posts - 37,396 through 37,410 (of 59,098 total)