Viewing 15 posts - 1,801 through 1,815 (of 4,080 total)
Those runes look more like Dwarvish, Paul:
Barak Khazad!! Khazad ai-menu!!
Loosely translated: Keyboards of the the DBAs!! The DBAs are upon you!!
Note: ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 18, 2010 at 6:19 am
When the developers ask already what's the best solution, then that's a good sign even if the answer is not so easy.
I couldn't agree more.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 18, 2010 at 6:09 am
Did somebody order a babelfish?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 17, 2010 at 10:44 pm
Adrian, I have nothing against those two approaches you listed. At a glance, they appear perfectly workable. Please understand that no techniques were deliberately excluded, other...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 17, 2010 at 10:15 pm
No problem. Declare the variable as geometry and use your x-y values. The polygon can have irregular sides and the area calculation should still work.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 17, 2010 at 4:31 pm
You may not.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 17, 2010 at 4:19 pm
Hrrrrrrm.....
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 17, 2010 at 4:17 pm
Thanks, Gus. 🙂
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 17, 2010 at 4:09 pm
There are several approaches to solving the "get all columns of only one row from a group" problem.
Three different approaches are described here[/url].
But for a small number of rows in...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 17, 2010 at 4:06 pm
Okay... can someone explain to me why a DBA might choose to disable statistics on tempDB?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 17, 2010 at 3:47 pm
Good luck. If that situation doesn't change, then every time you use a temp table you are going to have to use hints. Not good...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 17, 2010 at 3:45 pm
No problem, Ryan. We're not all DBA's. I'm a developer too.
I'm kind of curious though. Why would anyone disable statistics on tempDB?...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 17, 2010 at 3:26 pm
Jason, I hadn't planned on a sequel. No pun intended. Right now I have another writing commitment to honor before I can do another article. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 17, 2010 at 3:10 pm
Ryan, could you possibly post up the code and an execution plan so we can see what is going on?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 17, 2010 at 12:35 pm
Sure, just use the STArea() method. Here's an example from Books online.
DECLARE @g geography;
SET @g = geography::STGeomFromText('POLYGON((-122.358 47.653, -122.348 47.649, -122.348 47.658, -122.358 47.658, -122.358 47.653))', 4326);
SELECT...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 17, 2010 at 12:08 pm
Viewing 15 posts - 1,801 through 1,815 (of 4,080 total)