Viewing 15 posts - 1,951 through 1,965 (of 1,988 total)
Matt Miller (#4) (8/31/2011)
ZZartin (8/31/2011)
What aboutSELECT TOP 1 * FROM #JobOrder WHERE Complete = 0 ORDER BY Operation ASC
This will work only if the #jobOrder table ever hold one...
August 31, 2011 at 11:42 am
What about
SELECT TOP 1 * FROM #JobOrder WHERE Complete = 0 ORDER BY Operation ASC
August 31, 2011 at 11:00 am
I believe which server is doing the bulk of the work will depend on how your SSIS package is set up. Any database level commands would do their work...
August 31, 2011 at 10:52 am
I have a few questions regarding this technique:
1. Has anybody out there used a technique like this?
2. What are the performance and cost implications of constructing dynamic SQL using this...
August 29, 2011 at 1:29 pm
The newer versions of excel can display more than 65K rows, the older versions won't truncate the data they just won't display it. I know this because some people...
July 26, 2011 at 12:21 pm
Do you happen to have a back up you can recover and see if that will work well enough if they don't want to give you more details?
July 20, 2011 at 2:38 pm
set allow updates on and then update sysdatabases and set the status to 36767 for that database.
Sorry if this is slightly off topic but isn't modifying system tables disabled...
July 20, 2011 at 10:57 am
Well shrink database will only shrink the file if there's actually free space in the physical file to shrink. If there is free space SQL Server will use it...
July 19, 2011 at 1:46 pm
You can use an Execute Package task in the control flow to execute another package from within a package.
July 19, 2011 at 1:33 pm
Are you doing a straight table to table transfer? Or are there any filters either in the query you're using to grab the rows from your oracle table or...
July 19, 2011 at 1:28 pm
ijjoycemail (7/11/2011)
I was just having trouble with this myself. Try putting quotes on the datepart variable ("d" instead of dd).
This would be at least part of the problem, the...
July 11, 2011 at 4:12 pm
So it sounds like you have a table with a bunch of SQL commands stored in a column that you need to read from the table, modify in real time,...
July 11, 2011 at 4:04 pm
Koen Verbeeck (7/4/2011)
On a sidenote: isn't a dataflow with 50 flows a little too big? Can't it be split into smaller...
July 5, 2011 at 12:39 pm
How you handle your old records will probably be dependent on your business needs. For example will you need access to the old data at some point in the...
June 29, 2011 at 2:22 pm
Hmmm.. it filled up the entire 135 GB drive we have allocated for the log files in less than an hour, we backup the transaction logs every hour, during normal...
June 28, 2011 at 3:19 pm
Viewing 15 posts - 1,951 through 1,965 (of 1,988 total)