Viewing 15 posts - 1 through 15 (of 566 total)
Luis Cazares (9/19/2014)
The column is not needed, but...
Jason Wolfkill
September 19, 2014 at 12:03 pm
ohack (9/19/2014)
Another SQL Server 2000 mystery, perhaps related to my last post (http://qa.sqlservercentral.com/Forums/Topic1611514-5-1.aspx).
A stored procedure (the same one) disappears from syscacheobjects - usually before the usecounts counter reaches...
Jason Wolfkill
September 19, 2014 at 10:42 am
Hi Luis,
Are the row counts typical of this process?
Since the estimated plan shows clustered index scans of both tables, I'd first check to be sure you didn't lose a...
Jason Wolfkill
September 19, 2014 at 10:21 am
okbangas (9/19/2014)
Jason Wolfkill
September 19, 2014 at 9:35 am
SQLRNNR (8/22/2014)
In other news, what does everybody think of the Mythbusters news from last night?
I think it's a shame. I always enjoyed Tori, Kari, and Grant's segments more than Adam...
Jason Wolfkill
August 22, 2014 at 8:10 am
DavidL (8/14/2014)
wolfkillj (8/14/2014)
Did you try using the code mickyT posted above to find the rows where the vppblong value contains some character other than the digits 0-9, decimal point (.),...
Jason Wolfkill
August 14, 2014 at 12:20 pm
DavidL (8/13/2014)
SELECT f.vpid#
,f.numlat As Latitude
,CONVERT(NUMERIC(12,8),f.[IntPart]) +
CONVERT(NUMERIC(12,8),f.[Mantissa]) AS Longitude
FROM
(
select vpid#, vppblat
, convert(numeric(12,8),vppblat) as numlat,...
Jason Wolfkill
August 14, 2014 at 11:23 am
jcrawf02 (8/13/2014)
rodjkidd (8/13/2014)
Ed Wagner (8/13/2014)
rodjkidd (8/13/2014)
Ed and Jason,Some serious rain there. Glad to hear you are all OK.
Rodders...
Thanks for all the well wishes, everyone. Things are starting to...
Jason Wolfkill
August 14, 2014 at 8:43 am
KoldCoffee (8/12/2014)
Jason Wolfkill
August 12, 2014 at 1:53 pm
Evil Kraig F (8/11/2014)
Jason Wolfkill
August 12, 2014 at 12:56 pm
v4vaas 19815 (8/11/2014)
Jason Wolfkill
August 12, 2014 at 12:32 pm
vip.blade (7/15/2014)
Hey,do you have any ideas on that or do you need further information?
Best regards!
I think we would need more information about what the application is trying to do,...
Jason Wolfkill
July 16, 2014 at 10:48 am
Steve Jones - SSC Editor (7/16/2014)
GilaMonster (7/16/2014)
Jeff Moden (7/15/2014)
To be honest, I'm glad this person is taking such caution and has such FUD about it.
I would be, if he...
Jason Wolfkill
July 16, 2014 at 10:26 am
Koen Verbeeck (7/10/2014)
Jack Corbett (7/10/2014)
Koen Verbeeck (7/10/2014)
I saw Jeff was endorsed 9 times for...
Jason Wolfkill
July 11, 2014 at 11:59 am
wolfkillj (7/8/2014)
GilaMonster (7/8/2014)
The Dixie Flatline (7/8/2014)
I abandoned any thoughts of playing it when I realized I already have a job.
🙁 EVE hasn't taken over my life. Not entirely anyway....
Jason Wolfkill
July 8, 2014 at 5:41 pm
Viewing 15 posts - 1 through 15 (of 566 total)