Viewing 15 posts - 1,006 through 1,020 (of 1,825 total)
You are going to have to be a lot more specific about which statement is causing your performance problem. Check the links in my sig below for the best...
February 18, 2010 at 3:10 pm
Lynn Pettis (2/18/2010)
ROFLMA! I remember that article!!!
It made TV news here. Must of been a slow news day 🙂
February 18, 2010 at 3:06 pm
lmu92 (2/18/2010)
The Pythagoras will loose precision the longer the distance of the two points will get (increasig influence of the spherical shape)
True , but i dont think that the easting...
February 18, 2010 at 3:02 pm
Surely it does have to cease being an emergency after 24hrs.
There have been shorter wars.
http://www.sqlservercentral.com/Forums/Topic867521-1550-1.aspx
February 18, 2010 at 2:09 pm
GilaMonster (2/18/2010)
If my former company's primary DB had been down for 24 hours, they'd be out of business.
Being a call centre based company, we do have the luxury of being...
February 18, 2010 at 2:06 pm
With a simple google search i found this (very good) description.
http://en.wikipedia.org/wiki/Grid_reference
Would seem that simple Pythagoras need only be applied
February 18, 2010 at 1:58 pm
As far as i can make out, your company has now been down for 24hrs.
That to me points to the ,amazingly obvious, fact that you do not have enough skills...
February 18, 2010 at 1:47 pm
Watch your ordering !
Date desc,Time asc
Will return the first one on the last day,
Date desc,Time desc
Will return the last one on the last day
February 18, 2010 at 6:41 am
One method , untested but should be ok
with cteNotes
as(
select *,ROW_NUMBER() over (partition by Account order by Date desc) as Rown
from table
)
select * from cteNotes where Rown =1
--EDIT :...
February 18, 2010 at 4:58 am
Does anyone else read this response
http://www.sqlservercentral.com/Forums/FindPost867131.aspx
as implying that using a identity defines order ?
February 18, 2010 at 2:17 am
GT-897544 (2/17/2010)
As GSquared said, See you have an Identity column it gives the order you entered until unless you specify what order you want result set.EnjoY!
If i understand you...
February 18, 2010 at 1:42 am
Jeff Moden (2/17/2010)
February 17, 2010 at 3:21 pm
Well, if you find yourself at a loose end and fancy a beer or two , drop me a line.
February 17, 2010 at 11:13 am
Nether the less , its is best practice to manually update statistics after an upgrade.
If that doesnt help then follow the links in my sig for how to help...
February 17, 2010 at 9:19 am
Will do Gail.
Business or pleasure Steve ?
February 17, 2010 at 9:15 am
Viewing 15 posts - 1,006 through 1,020 (of 1,825 total)