Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,261 through 37,275 (of 59,098 total)

RE: Huge size of unused space problem

John's pretty much spot on. You need to check if the tables have clustered indexes. We also need to check what the clustered indexes are on. It...
--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 18, 2010 at 6:28 am

#1208423
RE: How to split character from string

mayank_tyagi (8/16/2010)
Dear KMPASS ,
It can be solved by very good article for all string related query
with the help of Tally table:
Wriiten by Jeff Moden
http://www.sqlservercentral.com/articles/T-SQL/62867/
features are:
Stepping Through Characters,
do the "Split".
One...
--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 17, 2010 at 8:53 pm

#1208248
RE: Single DELETE statement show high reads

Eugene Elutin (8/17/2010)
Ok, the number of logical reads will also depend on how many rows is affected by your query and how many indexes it should update.
As you have index...
--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 17, 2010 at 8:47 pm

#1208247
RE: clustered or nonclustered index for UserId?

ashish.kuriyal (8/17/2010)
from performance perspective, it should be clustered index with appropriate fill factor.
Also make sure the index is being updated regularly for threshold limit like :-
if fregmentation is <30 then...
--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 17, 2010 at 8:38 pm

#1208245
RE: Run SQL script with SQLCMD

As well thought out as many of the answers are, I believe none of them will actually work. The reason is because of the backslash in the server instance...
--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 17, 2010 at 8:31 pm

#1208243
RE: Date Conversion Fills the Transaction log

R0gu3Tr4d3r (8/17/2010)
I have 2 sql server 2005 instances running on 2 different boxes, one is 32 bit Win Server 2003, the other is a 64 bit.
now, I load a table...
--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 17, 2010 at 8:28 pm

#1208242
RE: DATEADD

Heh... maybe I've taken things to far. No one has to write code about the Tally table anymore. 😛
--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 17, 2010 at 8:22 pm

#1208241
RE: Please Help me improve this SPROC!!! It runs too slow!

gregory.perry2 (8/17/2010)
Because there is a large amount of data in the table (60k+ records per month) it is taking the query a long time to pull the dataset back and...
--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 17, 2010 at 8:18 pm

#1208238
RE: The Logic, Mathematics, and Utility of NULLs

David Webb-200187 (8/17/2010)
WOW, over my head on the first post. OK, I'll just grab the popcorn and sit back and absorb.
Carry on.
Heh... I'll summarize. In fact, it's already...
--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 17, 2010 at 8:13 pm

#1208234
RE: Creating history audit table data

Steve Jones - Editor (8/17/2010)
You don't want to use a variable. Think trigger. What if multiple rows are changed?
You use some table var and then drop that into your audit...
--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 17, 2010 at 7:55 pm

#1208232
RE: Are the posted questions getting worse?

Alvin Ramard (8/17/2010)
As I was saying, I like my pork chops well done. 😀
... and is a good sport about it, too! 🙂
--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 17, 2010 at 7:51 pm

#1208230
RE: Are the posted questions getting worse?

jcrawf02 (8/17/2010)
I actually like livemeeting, works better than some of the others I've been involved with, especially for feedback during the meeting (status color thingy) meetingplace and webex are 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 17, 2010 at 7:46 pm

#1208227
RE: Are the posted questions getting worse?

Alvin Ramard (8/17/2010)
jcrawf02 (8/17/2010)
Jeff Moden (8/17/2010)
jcrawf02 (8/17/2010)
speaking of which, anybody used yuuguu before? supposedly the presenter installs, and the audience doesn't have to do anything to view the presentation, not...
--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 17, 2010 at 7:30 pm

#1208225
RE: Are the posted questions getting worse?

jcrawf02 (8/17/2010)
Jeff Moden (8/17/2010)
jcrawf02 (8/17/2010)
speaking of which, anybody used yuuguu before? supposedly the presenter installs, and the audience doesn't have to do anything to view the presentation, not sure 'zackly...
--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 17, 2010 at 7:17 pm

#1208223
RE: The Multi-valued Parameters problem in Reporting Services

gary.bland (8/17/2010)
What I am trying to accomplish is when I choose a parameter I need to pass the result into another parameter in order to limit the number of available...
--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 17, 2010 at 2:36 pm

#1208139

Viewing 15 posts - 37,261 through 37,275 (of 59,098 total)