How about building a temp table/table variable of the result set you require then inserting data from Table3 and Table4 as needed and returning a...
You may need to monitor the process info as the trace logging may not be occurring regularly. You can use sp_who to get the same information via a...
Is there any identifying information in the trace data? You could check the "Process Info" node under "Current Activity" in EM for connecting user...
It's all stored in... SELECT * FROM dbo.syscomments ...however I'd second Madhivanan's post and use sp_helptext 'procedure_name' to access.
Did you mean user tables from a database? I don't think there is one.
According to this article... http://www.sql-server-performance.com/tips/query_execution_plan_analysis_p1.aspx ...you may want to consider the...
You can use the extended stored procedure xp_cmdshell to execute a bulk copy program (bcp) statement to execute a query or stored procedure into a...
If you specify multiple column names in an ORDER BY clause, the columns will be sorted in the order in which they appear. ORDER BY ColA, ColB, ColC...
Well I don't know how to change them all at once, and I wouldn't recommend editing any of the system tables directly. However, you could easily...
Use sp_defaultdb to change the default database on a login. See BOL for full info.
Yes. I assumed from your example that you were working with either VARCHAR or CHAR data types.
If I'm understanding your problem correctly, you have two options. 1 - You could RTRIM(LTRIM(colname)) on all the columns in your source...
It really depends on how much redundancy you're looking for. You say you have RAID 5, which is good for disk redundancy, but what if the RAID...
From EM - To find out what port your instance is configured for, open up EM, right click on the instance node you're interested in and select the...
Here is a more complete response to your second question... Create a Script Task and connect it to your data loading task (whatever type that might...
You can add steps prior to your data loading step that check for existence of files. You will want to add script steps, and then using vbscript you...
While both to use memory and disk, it's my understanding is that table variables are much more efficient with memory usage then temporary tables are....
According to Microsoft, a table variable will use the tempDB if it needs to......
I'm afraid I'm not familiar with the article, but are you referring to something like different file system cluster size? I believe that could...
Unless I'm missing something, there really shouldn't be duplicates if both columns are primary keys.
Separate names with a comma.
