Viewing 15 posts - 58,141 through 58,155 (of 59,048 total)
Does anyone have a Microsoft link or know the lookup in BOL that says that Temp Tables are logged (or not?). I know there is a log file associated with TempDB...
June 9, 2006 at 7:37 am
A bit oversimplified on my part put if you have 4 working stored procedures, why not just use UNION ALL to convert it all to a single record set?
SELECT yada-yada
...
June 9, 2006 at 7:34 am
My appologies, Lorna... I did think you were being sarcastic... glad you figured it out and thank you for the courtesy you intended. Ian is correct... we had no way...
June 8, 2006 at 4:59 pm
It's a forum... not an instant help button. Your impatience may have cost you a great answer from one the good folks on this forum... we all work regular jobs...
June 7, 2006 at 8:58 pm
Both Temp Tables and Table Variables start out in memory and both spill into TempDB when they get big enough... there are many other differences, as well...
http://support.microsoft.com/default.aspx?scid=kb;en-us;305977&Product=sql2k
...draw your own...
June 7, 2006 at 8:46 pm
Sure... no problem...
OSQL -SwSRVR01 -E -Q"set nocount on select name from sysobjects" -n -h-1
June 7, 2006 at 5:23 pm
Doh! The simplest answer is usually the best and the most elusive... that'll sure do it, Tim! Good thinkin'
June 6, 2006 at 8:06 pm
Nice job Lowell,
Small correction, though... the switch to turn off the header and the dotted line is -h-1 and not just -h1.
June 6, 2006 at 5:31 pm
Check the size of TempDB on both servers.
June 6, 2006 at 5:19 pm
Checking with the DBA revealed that there had been instances where temp tables remained after the end of... |
June 5, 2006 at 8:14 pm
Thanks dee-oh-gee... little hint... document as you go and you'll never get behind.
June 5, 2006 at 8:02 pm
| Our DBA had a job to check for "orphaned" temp tables and delete them. |
If you mean find the...
June 5, 2006 at 6:41 am
| I don't see why you would say that. Table variables are certainly no panecea, but they can be... |
June 3, 2006 at 2:59 pm
This usually works... I'm sure this will be followed by warnings of injection attacks...
CREATE PROCEDURE dbo.SampleProc
@CSVParams VARCHAR(8000) -- List of params with comma delimiters
AS
June 2, 2006 at 11:31 pm
If you'd rather just have the last day of the month, substitute any valid date for GETDATE() in the following...
SELECT DATEADD(mm,DATEDIFF(mm,0,GETDATE())+1,0)-1
If you really want the number of days...
June 2, 2006 at 11:15 pm
Viewing 15 posts - 58,141 through 58,155 (of 59,048 total)