Viewing 15 posts - 121 through 135 (of 7,428 total)
Expirementing a little more found this.
Look at syscacheobjects in master I discovered that whichever item is ran first temp table or table variable or table variable with primary key for...
May 30, 2008 at 11:58 am
OK decided to take a look at TempDB to see what happens in the log
(DBCC LOG 'tempdb',3)
and found that regardless of table variable or temp table both are logged...
May 30, 2008 at 9:17 am
You know looking at it directly you cannot see a table variable because of the scope but if you look at it this way
declare @t table
(OrderID int,
RequiredDate datetime...
May 30, 2008 at 8:49 am
Matt Whitfield (5/30/2008)
Again not necessarily true. Derived tables quite often end up as a system generated temporary table in tempdb, this is done by the...
May 30, 2008 at 8:26 am
As I recall the MS Ole Provider for Oracle only works with the 32 bit version of the Oralce driver. You might want to check with MS site to see...
May 5, 2008 at 9:38 am
Select
Table1.*, Table2.*
From Table1, Table2
Where Table1.File_Name = Table2.File_Name
and File_Desc = Trim(cbFileDesc.text) **Match text from combobox.
and Downloaded_Date = Act_Date
and Downloaded_Date = (Select Max(Downloaded_Date) from Table1)
The issue I don't see...
April 8, 2008 at 1:45 pm
Matt Miller (4/4/2008)
April 4, 2008 at 9:12 am
Sorry, additionally do note I don't use default values for any fields as I want to be sure the application is providing all for this particular SP so things like...
April 4, 2008 at 9:10 am
First off consider what actually happens in an UPDATE. If you look at the transaction log (DBCC LOG or whatever the function is for 2005) you will find that in...
April 4, 2008 at 9:08 am
Johndavidson719 (4/3/2008)
schumi (4/1/2008)
April 4, 2008 at 7:47 am
jason.stinson (4/3/2008)
Running SQL 2000, can you change the DB Owner from dbo to whatever you want through Enterprise Manager, or do you HAVE to run a script?
Just to clarify the...
April 3, 2008 at 7:46 am
I would suggest using the Oracle Ole provider as you are less likely to run into translation errors.
April 3, 2008 at 7:39 am
Greg Edwards (4/2/2008)
Looking at the number of hits generated, this was a good teaser. 😀Guess we just have to settle for our reality game we have today.
Greg E
Please do not...
April 2, 2008 at 8:15 am
Make sure I wasn't misunderstood. I said what matters most is how you feel about it. If you really think it is holding you back or you really want the...
April 2, 2008 at 7:30 am
Can you post what you have so far. I do better with a starting point. 😀
April 2, 2008 at 7:22 am
Viewing 15 posts - 121 through 135 (of 7,428 total)