Viewing 15 posts - 40,216 through 40,230 (of 59,072 total)
A self join with a ROW_NUMBER reference would probably do it. If you want a coded answer, please see the first link in my signature line below.
--Jeff Moden
Change is inevitable... Change for the better is not.
January 17, 2010 at 9:40 pm
Ummmm... I tried to find xp_restore_filelistonly in my installation of 2k5 and it doesn't exist nor is it in Books Online.
--Jeff Moden
Change is inevitable... Change for the better is not.
January 17, 2010 at 9:33 pm
Simon Facer (1/17/2010)
MS recommends that you dont have any SP content database over 100GB
I'd really like to see the link for that, please.
--Jeff Moden
Change is inevitable... Change for the better is not.
January 17, 2010 at 9:27 pm
itsmeman (1/5/2010)
This issue is done for now....
Two way street here... please explain how this issue is "done for now".
--Jeff Moden
Change is inevitable... Change for the better is not.
January 17, 2010 at 9:26 pm
WHERE ImageBlob > 0x00
--Jeff Moden
Change is inevitable... Change for the better is not.
January 17, 2010 at 9:21 pm
Why would the log file know anything about the relationships between a staging table and a primary table?
--Jeff Moden
Change is inevitable... Change for the better is not.
January 17, 2010 at 9:11 pm
Ah... got it. Thanks, Matt.
--Jeff Moden
Change is inevitable... Change for the better is not.
January 17, 2010 at 9:08 pm
zafarthesultan (1/17/2010)
--Jeff Moden
Change is inevitable... Change for the better is not.
January 17, 2010 at 9:04 pm
Set up a trace to capture growth events.
--Jeff Moden
Change is inevitable... Change for the better is not.
January 17, 2010 at 8:58 pm
Heh... I'll also ask, why ask why? I've been frustrated many times in the past by certain things in many products. I've gotten to the point where instead...
--Jeff Moden
Change is inevitable... Change for the better is not.
January 17, 2010 at 8:56 pm
Ummmm.... where do you see a GOTO in any of that? 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
January 17, 2010 at 10:50 am
Understood and we already have that (it's what I meant when I said it sounds like a cursor)... it just doesn't need to be inline...
--= some very high performance sql...
--Jeff Moden
Change is inevitable... Change for the better is not.
January 16, 2010 at 7:24 pm
Ok... let's ask the next logical question...
Let's say that I DON'T want to use Master for anything but I would like to have a central repository of common code for...
--Jeff Moden
Change is inevitable... Change for the better is not.
January 16, 2010 at 6:08 pm
tvantonder-992012 (1/15/2010)
In my opinion the best would be creating a new table with the changed column and just transfering the data there. Then renaming the new and old table. Then...
--Jeff Moden
Change is inevitable... Change for the better is not.
January 16, 2010 at 1:25 pm
With Gail's thought about only experience getting hired... you can get some experience by volunteering for charity groups and churches.
She's also pretty much correct that the best chances are available...
--Jeff Moden
Change is inevitable... Change for the better is not.
January 16, 2010 at 1:15 pm
Viewing 15 posts - 40,216 through 40,230 (of 59,072 total)