Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,736 through 21,750 (of 59,098 total)

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
RE: What are First Steps for a dba in new Office?

sm_iransoftware (1/23/2015)
No :blush:
I think I should Know more about these tools and performance Basics.
Thank you
Take a look at my previous post. It talks about a simple built-in tool 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)

January 23, 2015 at 3:45 pm

#1772849
RE: ABS value

sharonsql2013 (1/23/2015)
Well the Error was #Error.
Yowch. Not fun. I hate such "informative" error messages.
I'm sure there's an SSRS-language function to do the same thing but the multiplication will...
--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 3:41 pm

#1772848
RE: Logiacl Sql server SSIS question

stevenb 63624 (1/23/2015)
sqlmaverick (1/23/2015)
Hi, please help me to get below logic in Derived transformation, SSIS.
Logic:ensure the Docket number is 5 digits and populate with leading zeros if not.
I have 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)

January 23, 2015 at 2:00 pm

#1772829
RE: Where can I find the definistion of this table value function

MMartin1 (1/23/2015)
EXEC SP_HELPTEXT 'schema.viewName';
This formats the output across multiple lines rather than just one. I find it way handier when copying long definitions to the SSMS window.
Unless you're 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)

January 23, 2015 at 1:51 pm

#1772825

Viewing 15 posts - 21,736 through 21,750 (of 59,098 total)