Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,231 through 43,245 (of 59,102 total)

RE: 911 - Cursor killing my trigger

Scott Coleman (6/26/2009)
Sorry, I got here through "Active Threads" and didn't notice that it was 2000.
You can use a self-join solution, although depending on your rowcounts and indexes this 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)

June 26, 2009 at 3:29 pm

#1016299
RE: Good SQL Server article

Florian Reischl (6/26/2009)
Sure, it's a task on my list, too. 😉 But it's really neat that he provides a complete test setup.
I agree... it just like some of the good...
--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)

June 26, 2009 at 3:25 pm

#1016297
RE: Good SQL Server article

Florian Reischl (6/26/2009)
Jeff Moden (6/26/2009)
jaclynmcatanzaro (6/26/2009)
Good SQL Server article
http://www.informationflash.com/%5B/url%5D
Which one?
Can't answer your question but the new article by Adam Machanic is really good in my opinion:
The Hidden Costs of INSERT...
--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)

June 26, 2009 at 3:19 pm

#1016295
RE: What has been your experience of agile development

Unless you're very careful, it becomes nothing more than an excuse for releasing bad or slow product with no documentation. Contrary to what many believe, it does take some...
--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)

June 26, 2009 at 3:08 pm

#1016292
RE: How to chage IDENTITY Column seed

DBCC CHECKIDENT
--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)

June 26, 2009 at 3:00 pm

#1016288
RE: Good SQL Server article

jaclynmcatanzaro (6/26/2009)
Good SQL Server article
http://www.informationflash.com/%5B/url%5D
Which 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)

June 26, 2009 at 2:53 pm

#1016285
RE: Reindex/Reorg Space Concerns

You can specify that the sort done during the rebuild will be done in TempDB which should make your life a whole lot easier when it comes to space used.
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)

June 26, 2009 at 2:49 pm

#1016282
RE: Reindex/Reorg Space Concerns

karthik_sql (6/24/2009)
Please try the below
1. Put db to Simple recovery
Absolutely NOT! That will make a mess of the log file for purposes of backup.
--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)

June 26, 2009 at 2:46 pm

#1016281
RE: select count(*) in a partitioned table takes 100%cpu

tejas parikh (6/26/2009)
Hi. I've a partitioned table based on 6 months. each partition has 2 files(1fg).
All I'm running is a simple count(*) below. The cpu usage goes to a 100%...
--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)

June 26, 2009 at 2:44 pm

#1016280
RE: pivot problem

vick.ram79 (6/26/2009)
I must be feeling the friday effect .... for those interested , here is the fix:
select batchID, [outfolder], [outfile]
from (Select batchID, paramName, paramValue From #foo) tmp
Pivot
(Max(paramvalue)
for paramName in (outfolder,...
--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)

June 26, 2009 at 1:55 pm

#1016268
RE: Why recursive cte ignores join hint?

I could be wrong but I'd have to say it's because a recursive CTE is just the same as a While Loop (sometimes, it's worse). It's only going 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)

June 26, 2009 at 1:51 pm

#1016267
RE: Retrieve comma-separated list within group by

I agree with Lynn. No sign of a triangular join in your query. Are you merely talking about the fact that you have a "derived table" in your...
--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)

June 26, 2009 at 1:48 pm

#1016265
RE: Query for Running Totals with respect to dept's

Adrienne (6/17/2009)
Can you just add this...
,(select sum(b.sal) from cte b where b.seq_no <= a.seq_no and b.deptno = a.deptno) as "RunningTotalWRTDept"
Ummmm.... no. While that works, it has no scalability 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)

June 26, 2009 at 1:43 pm

#1016263
RE: By Hour

Krasavita (6/26/2009)
Thank you:-)
Heh... wait a minute, now.... splitting the date and time is normally a really, really bad thing to do. Why do you need to do this?
--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)

June 26, 2009 at 12:49 pm

#1016244
RE: Enable sp_MakeWebTask in 2k5

Ah... no joy... I still need some help on this, please. Even though I've found the sp_MS_upd_sysobj_category stored proc in Master and modified the the Web.sql stored procedure 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)

June 26, 2009 at 12:43 pm

#1016240

Viewing 15 posts - 43,231 through 43,245 (of 59,102 total)