Viewing 15 posts - 2,551 through 2,565 (of 3,061 total)
This is not an Oracle issue, this is a Windows issue.
Open ODBC Data Source Administrator
Select the offending Data Source
Click Configure
Check "Force Retrieval of Long Options" option.
Click OK
Click OK
May 15, 2009 at 12:15 pm
In short, SQL Server monitoring is sending out an alert about a process consuming a large amount of memory... check here: http://support.microsoft.com/default.aspx?scid=kb;en-us;959004&sd=rss&spid=2855
Interesting enough the very act of sending out the...
May 15, 2009 at 12:07 pm
I'm not sure I got a clear picture of your scenario and issue/s. Perhaps I'm getting to old for this, perhaps is the fact that there is no coffee yet...
May 15, 2009 at 6:03 am
Grant Fritchey (5/14/2009)In... what was that, 1995? I was working with both back then.
:w00t: So I'm not the only dinosaur around, huh? 😀
May 14, 2009 at 7:31 am
sabutp (5/14/2009)I am not sure in MS SQL but in Sysbase SQL separate indexes are created automatically for primary and foreign keys.
MS SQL Server != Sybase
They departed ways when...
May 14, 2009 at 6:46 am
Technically this is a distributed transaction so I would go with BEGIN DISTRIBUTED TRAN instead of BEGIN TRAN.
May 14, 2009 at 6:38 am
sabutp (5/14/2009)As I heard from the documentation that, when we creating a FK, create an index automaticaly, no need for an additional index key for the FK
This is a urban...
May 14, 2009 at 6:30 am
As far as I know explicitily dropping a partition remains to be an Oracle feature; in the SQL Server world you have to switch the partition out.
May 14, 2009 at 6:23 am
Steve Jones - Editor (5/13/2009)you need a person (not a developer)
you made my day 😀
May 13, 2009 at 1:57 pm
Joel Ewald (5/13/2009)
Lets say for instance you want to...
May 13, 2009 at 10:45 am
David (5/13/2009)Depending on the size of your shop.
Agreed.
David (5/13/2009)they are not allowed to do anything in production though.
Couldn't agree more.
May 13, 2009 at 10:35 am
Barkingdog (5/13/2009)
Bad habit: we generally make developers "dbo" of dev, test, and production databases.
Oh yes... this is a very bad one.
There is no reason in the world to grant a...
May 13, 2009 at 10:09 am
This shouldn't be considered a bad habit.
In a three tier deployment model the "test" better saying UAT version of any given database should be a production size database refreshed from...
May 13, 2009 at 10:01 am
Gift Peddie (5/12/2009)Now there is addin for Java and none .NET developers from third party so yes it is a SQL Server question albeit not direct.
Cool! can't wait until seeing...
May 12, 2009 at 4:44 pm
Nice article RBarr, Thank you!
I'll revise my rule of thumbs about this matter 😉
May 12, 2009 at 2:51 pm
Viewing 15 posts - 2,551 through 2,565 (of 3,061 total)