Viewing 15 posts - 58,696 through 58,710 (of 59,048 total)
This works so nice that I thought I'd put it out here now in case someone else needs it right away and then write the article. Man, did I get...
August 6, 2005 at 10:25 pm
Never mind folks... I got it... it's a bit convaluted but I'll clean up what I did in the form of step by step instructions and post it... hmmm... maybe an...
August 6, 2005 at 8:39 pm
Yeah, I didn't say that quite right... BOL has a better way of saying what I so poorly said...
Each time an instance of SQL Server starts, it recovers each database,...
July 25, 2005 at 8:02 pm
"I want to fetch code from each file (in Query Analyzer) and then do as you said i.e. execute the code.
But how do i loop through a dos directory in...
July 25, 2005 at 7:56 pm
...or do you mean you want to execute them in a DOS batch run (ie. filename.BAT)? If you want to execute the files from there, then you would use OSQL...
July 25, 2005 at 5:52 am
Here's the calculation you requested... it's quite a bit more complicated that when weekends are Sat/Sun because SQL Server's "Week" datepart always breaks between those two days. And, DateFirst has...
July 24, 2005 at 9:42 pm
>is it okay to clear transaction log in mssql server ?
Yes... unless the server crashed and you need to roll some data forward.
>if it's ok, how to clear transaction...
July 17, 2005 at 9:28 am
Either way, there have been problems with SP_OA and memory leaks of one form or another. My recommendation is to test it for memory leaks before you put it into production...
July 9, 2005 at 11:39 pm
A version without a correlated sub-query... but only if you can guarantee that the date you use is a month end date and that all of the DateMonthEnd dates are...
July 9, 2005 at 8:41 pm
I found it and I was correct...
They first found memory leaks in the SP_OA procs in SQL Server 6.5 and supposedly fixed it... see the following URL:
http://support.microsoft.com/kb/151601/EN-US
I guess...
July 9, 2005 at 8:13 pm
It sounds like you may need to build a "Calendar Table". Lot's of folks have wriiten about their construction and use. I'd also recommend taking a peek at the following...
July 9, 2005 at 11:27 am
Jon,
What kind of VB functionality are you looking to do?
July 9, 2005 at 9:18 am
IF OBJECT_ID('TempDB..#Results') IS NOT NULL
DROP TABLE #Results
SELECT IDENTITY(INT,1,1) AS RowNum,
...other columns as you need...
INTO #Results
FROM ...your tables and joins...
ORDER BY ...the order you...
July 7, 2005 at 8:18 pm
You CAN get an estimated execution plan when you use temp tables by first executing just the code that makes the temp tables and then doing the execution plan. If...
July 7, 2005 at 7:51 pm
Pretty sharp, Womalley... sometimes ya gotta do what ya gotta do.
July 7, 2005 at 7:45 pm
Viewing 15 posts - 58,696 through 58,710 (of 59,048 total)