Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,706 through 21,720 (of 59,072 total)

RE: ID or Id

RonKyle (1/24/2015)
What are the issues with DATETIME2 and DATEDIFF?
Simple. Given a single row that contains StartDate and EndDate columns as DATETIME2 columns, write the code to calculate the duration...
--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 24, 2015 at 10:53 am

#1772913
RE: Please explain what this Trigger query does

Let's answer the questions in the reverse order of your posts.
lawlietdba (1/24/2015)
Hi Jeff,
Please spare me, im asking same doubt again, :unsure:
Im doing the testing of the new trigger without...
--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 24, 2015 at 10:41 am

#1772911
RE: Please explain what this Trigger query does

lawlietdba (1/24/2015)
Hi Jeff,
Sorry for the late reply, I took some time to find out things you asked...
I also come up with doubts regarding the things you said,
Please spare me...
--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 24, 2015 at 2:35 am

#1772892
RE: HTML stored in a varchar max column being truncated, how do I return it?

Ugh! Understood.
Are you, by any chance, defining a tag as <a>, <col>, or <del>somewhere in the mix? Or maybe there's an "unclosed" tag somewhere? Other than 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)

January 24, 2015 at 12:26 am

#1772884
RE: Possible sources of fragmentation on Clustered Index

ErikMN (1/23/2015)
I have a table that has a clustered index that is only the identity column on the table. The table is somewhere around 200K rows and has 3800...
--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 24, 2015 at 12:03 am

#1772883
RE: ID or Id

TomThomson (1/23/2015)
Sean Lange (1/23/2015)
Eric M Russell (1/23/2015)
Date/Time: datetime, offset, varchar?
There is only one option here. Datetime.
I suppose if your dBMS is anccient enough that's excusable. But it probably...
--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 23, 2015 at 11:44 pm

#1772882
RE: HTML stored in a varchar max column being truncated, how do I return it?

There is a difference between what you can see on the screen from SSMS and what is actually in a column. You've already seen that. How do 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)

January 23, 2015 at 11:04 pm

#1772880
RE: HTML stored in a varchar max column being truncated, how do I return it?

Sorry... post withdrawn. Let me look at your post again.
--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 23, 2015 at 10:58 pm

#1772879
RE: What is the best practice about maintain and using Big Log Database

sm_iransoftware (1/23/2015)
CREATE TABLE [dbo].[...](
[Id] [bigint] IDENTITY(1,1) NOT NULL,
[SessionId] [bigint] NOT NULL,
[RegDate] [date] NOT NULL,
[RegTime] [time](0) NOT NULL,
[ReferrerUrl] [nvarchar](2000) NOT NULL,
[LandingUrl] [nvarchar](2000) NOT NULL,
CONSTRAINT [PK_TBL_Request_Id] PRIMARY KEY CLUSTERED
(
[Id] DESC
)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)

January 23, 2015 at 10:45 pm

#1772877
RE: Today's Random Word!

whereisSQL? (1/23/2015)
Ed Wagner (1/23/2015)
SQLRNNR (1/23/2015)
yikes
Away
journey
First-Step
--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 23, 2015 at 10:21 pm

#1772876
RE: Which is Quicker ? - updating 90 million records

simon_s (1/23/2015)
Hey Jeff
thanks for the input
as far as I was concerned the updated flag was a poor choice but the only one I had, the updated data isnt...
--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 23, 2015 at 10:11 pm

#1772875
RE: Are the posted questions getting worse?

Sean Lange (1/23/2015)
Jeff Moden (1/23/2015)
Sean Lange (1/23/2015)
Oh lordy...I just handed a stored proc and was asked advice on how to make it faster. The proc is 3700 lines long, there...
--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 23, 2015 at 9:34 pm

#1772873
RE: All Monday date of each month.

Cadavre (1/23/2015)
ChrisM@Work (1/23/2015)
SELECT MondaysThisMonth = DATEADD(DAY,n,MondayBeforeFOM)
FROM (
SELECT FirstOfMonth, MondayBeforeFOM = DATEADD(DAY,DATEDIFF(DAY,0,FirstOfMonth)/7*7,0)
FROM (SELECT FirstOfMonth = DATEADD(MONTH,DATEDIFF(MONTH,0,GETDATE()),0)) d
) e
CROSS JOIN (SELECT 7 UNION ALL SELECT 14 UNION ALL SELECT 21 UNION ALL...
--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 23, 2015 at 6:49 pm

#1772863
RE: Are the posted questions getting worse?

Grant Fritchey (1/23/2015)
Steve Jones - SSC Editor (1/23/2015)
Sioban Krzywicki (1/23/2015)
GilaMonster (1/23/2015)
I haven't got any clue for a costume. Maybe cheat, buy a green hoodie and go as Arrow (but without...
--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 23, 2015 at 4:04 pm

#1772853
RE: Are the posted questions getting worse?

Sean Lange (1/23/2015)
Oh lordy...I just handed a stored proc and was asked advice on how to make it faster. The proc is 3700 lines long, there are almost 200 parameters...
--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 23, 2015 at 4:00 pm

#1772852

Viewing 15 posts - 21,706 through 21,720 (of 59,072 total)