Jeff Moden

Forum Replies Created

Viewing 15 posts - 33,001 through 33,015 (of 59,099 total)

RE: The Woes of Cloud Computing

I've found that one of the biggest reasons why people originate or move databases to the cloud is so that you don't have to have a lot of hardware locally....
--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 3, 2011 at 10:13 pm

#1363433
RE: Question.. maybe a dumb one lol

rjdpa2 (8/3/2011)
thanks!! that helps a lot but it also requires me to change the compatibility level of the DB, which i can't really do. is there another alternative?
What compatibility level...
--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 3, 2011 at 10:01 pm

#1363431
RE: Do DBA admins rather restore whole databases then restoring individual tables?

danymorales17 (8/3/2011)
Hi, I hope this is the right category to discuss this. We currently use a 3rd party vendor to backup and restore our databases. The only thing...
--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 3, 2011 at 9:53 pm

#1363430
RE: SQL code issue

pwalter83 (8/3/2011)
This is ridiculous I am not asking to create a stored procedure from scratch, this is just a one line query we are talking about here....belos is the sql...
--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 3, 2011 at 9:38 pm

#1363425
RE: Need to avoid table spool in view

daveriya (8/3/2011)
hi
i cant put my all execution plan,all oher field is 0%,except table spool and key lookup.
i dont understand how to increase my time
daveriya,
Without any additional information, the best suggestion...
--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 3, 2011 at 9:18 pm

#1363421
RE: How to write the output of "print" messages to a file - path (c:\test.txt) ??

There is no answer to this question that will satiate the primordial fears of all the DBA's in the world. With that in mind, what will you allow? ...
--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 3, 2011 at 9:10 pm

#1363420
RE: Are the posted questions getting worse?

WayneS (8/3/2011)
LutzM (8/2/2011)
Changing subject:
@Wayne:
Did you notice you have a sibling? (at least in terms of your avatar...) 😀
For a moment I was confused (more than usual)
Interesting. But since I actually...
--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 3, 2011 at 7:23 pm

#1363411
RE: What is faster, MAX() with GROUP BY, OR CTE with ROW_NUMBER()?

Pagan DBA (8/3/2011)
The reason I joined this forum - to learn.
Not sure it will help at this point, but I recognized that. Looking back at what I posted,...
--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 3, 2011 at 6:49 pm

#1363409
RE: How do we solve this issue without using a CURSOR or WHILE loop?

Here's the "Full Monty" for this problem using the very high performance Quirky Update method. I've included not only the new safety check for the method (thank you Paul...
--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 3, 2011 at 9:38 am

#1363164
RE: Funny calculation and grouping problem

Ninja's_RGR'us (8/3/2011)
Jeff Moden (8/3/2011)
Flexdog (8/2/2011)
Hi Ninja,
I wonder if the conversion is outside of the aggregate, would perf improves?
'avg'=sum(Value)/cast(COUNT(*) as float)
...ignoring sum() int overflow scenario.
On my machine, that runs about 3...
--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 3, 2011 at 6:33 am

#1362976
RE: Funny calculation and grouping problem

Ninja's_RGR'us (8/2/2011)
Jeff Moden (8/2/2011)[hr
I haven't actually done a performance test but I know enough about machine language at the cycle level to say that it will always take fewer cycles...
--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 3, 2011 at 12:07 am

#1362825
RE: Funny calculation and grouping problem

Flexdog (8/2/2011)
Hi Ninja,
I wonder if the conversion is outside of the aggregate, would perf improves?
'avg'=sum(Value)/cast(COUNT(*) as float)
...ignoring sum() int overflow scenario.
On my machine, that runs about 3 times faster 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 3, 2011 at 12:03 am

#1362823
RE: What is faster, MAX() with GROUP BY, OR CTE with ROW_NUMBER()?

Pagan DBA (8/2/2011)
Seriously, I did say I was getting sporadic results. How would I know that if I hadn't tested?
The idea behind the question was to get some insight into...
--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 2, 2011 at 11:10 pm

#1362807
RE: Indexed View with tables referencing to itself

Thinky Night (8/1/2011)
I have a query but could not change it to a indexed view:
My query is like:
alter view dbo.Query_Test(col1,col2,col3) WITH SCHEMABINDING
select a.col1,b.col2,c.col3
from table1 a
inner join table1...
--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 2, 2011 at 8:01 am

#1362171
RE: How do we solve this issue without using a CURSOR or WHILE loop?

There's actually a serious improvement that can be made to the code which will guarantee that if something goes wrong, an error will be generated. If you can wait,...
--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 2, 2011 at 7:59 am

#1362166

Viewing 15 posts - 33,001 through 33,015 (of 59,099 total)