Viewing 15 posts - 17,941 through 17,955 (of 26,489 total)
You never showed us the code. Question, in the code, are you using table variables??
December 15, 2009 at 11:52 am
Unfortunately, I can't see what you see. I know that when I run Activity Monitor on my desktop system against one of my servers that Activity Monitor is displayed...
December 15, 2009 at 11:45 am
Does the account under which SQL Server Agent run have appropriate permissions to the source and destination directories/shares?
December 15, 2009 at 11:40 am
First, the only way you will learn is to do. If you have problems, ask specific questions.
Second, if you really want help, then please read and follow the instructions...
December 15, 2009 at 11:26 am
CirquedeSQLeil (12/15/2009)
The Dixie Flatline (12/15/2009)
Barry (aka MISTER 10K) made an heroic effort to participate in the final sprint down the stretch and...
December 15, 2009 at 11:22 am
I'm wondering if properly indexed temp tables in place of the table variables might not be a solution without converting the cursors? I'd move the creation of the temp...
December 15, 2009 at 11:15 am
Also seeing the use of table variables. Do you know on average how many rows of data may be inserted into each of these tables? As the number...
December 15, 2009 at 11:06 am
We had a performance issue with our PeopleSoft Finance application when we upgraded from SQL Server 2000 to SQL Server 2005. Long story short, there was a table used...
December 15, 2009 at 10:46 am
Ack!! I just looked at the code you posted. Cursors! Have you looked at rewriting the cursor-based code as set-based?
And, no, I haven't starting looking at the code...
December 15, 2009 at 10:15 am
Personally, I'd need more specifics regarding your requirements. You indicate that each day the filename changes, but when you say file1 one day then file2 the next, is the...
December 15, 2009 at 10:02 am
Are you copying or moving the files. If you are moving the files, they are removed from the source location, so if you run it once in VS (BIDS),...
December 15, 2009 at 9:46 am
Or: select * sys.tables
Have you even bothered to read ANYTHING in Books Online? Do you even know what it is? Many of your questions could easily be answered...
December 15, 2009 at 9:35 am
Magy (12/15/2009)
SELECT machineID, machineType FROM machinema A
LEFT JOIN modelma B ON B.startmachine = A.machineID
WHERE A.modelID = @modelID
ORDER BY startmachine DESC
it is in the order I...
December 15, 2009 at 9:29 am
What is the table definition for XMLmodelMap and what indexes are defined?
Also, the only way to ensure order in a query is to include an ORDER BY clause in the...
December 15, 2009 at 8:01 am
Another option, you can make your nonclustered indexes covering indexes by including the columns from the table used frequently in the index using the INCLUDE clause of CREATE INDEX.
In this...
December 15, 2009 at 7:29 am
Viewing 15 posts - 17,941 through 17,955 (of 26,489 total)