Viewing 15 posts - 31,921 through 31,935 (of 59,102 total)
Ninja's_RGR'us (11/21/2011)
Jack Corbett (11/21/2011)
Ninja's_RGR'us (11/21/2011)
Jack Corbett (11/21/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
November 21, 2011 at 5:34 pm
Jack Corbett (11/21/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
November 21, 2011 at 5:28 pm
Actually, there is. I believe that a recursive CTE, much like one that resolves hierarchical paths, might work here. I'm on my way to work and won't be...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 21, 2011 at 5:16 am
Thanks for the feedback, Texpic.
--Jeff Moden
Change is inevitable... Change for the better is not.
November 21, 2011 at 4:55 am
Post the CREATE TABLE statement for you table and any/all the indexes you may have on the table and I'll show you the "Quirky Update" method Cold Coffee is talking...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 20, 2011 at 8:05 pm
Tara-1044200 (11/18/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
November 20, 2011 at 2:16 pm
bharat sethi (11/20/2011)
How can we resolve Log full message in SQL Server 2008?Pl. guide.
How big is the current log file?
--Jeff Moden
Change is inevitable... Change for the better is not.
November 20, 2011 at 2:00 pm
Mvs2k11 (11/20/2011)
Thanks a lotHow to get the login name or user in the query.
Did you even look at the query I previously posted? 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
November 20, 2011 at 1:55 pm
opc.three beat me to the punch on a lot of the comments I was going to make, put I'll post them anyway because they're so important in this case. ...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 20, 2011 at 10:36 am
JonFox (11/20/2011)
I knew there had to be a better way than my original attempt! Looking forward to spending some time later today digging in and understanding how these solutions work...
This...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 20, 2011 at 8:12 am
GilaMonster (11/19/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
November 20, 2011 at 12:53 am
This should do it...
SELECT TOP 1 *
FROM sys.dm_exec_sessions
ORDER BY memory_usage DESC
--Jeff Moden
Change is inevitable... Change for the better is not.
November 20, 2011 at 12:47 am
Understood. I never assume the OP's description is correct in their request and I try to protect them as best I can when I think I see a less...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 20, 2011 at 12:31 am
ShawnTherrien (11/18/2011)
But with this logic, a student has 100+ attributes and 99% of them are optional. That's in...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 20, 2011 at 12:19 am
GilaMonster (11/19/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
November 20, 2011 at 12:09 am
Viewing 15 posts - 31,921 through 31,935 (of 59,102 total)