Viewing 15 posts - 766 through 780 (of 1,219 total)
How could I forget! The solution curious_sqldba is looking for is available on my web site. sp_sqltrace accepts a T-SQL batch as parameter. It sets up a trace filtered for...
August 24, 2013 at 3:14 am
Indianrock (8/23/2013)
August 24, 2013 at 3:08 am
Yes, there are a number of ways you can audit this:
1) SQL Server Audit (which requires Enterprise Edition)
2) DDL triggers.
3) Event notifications.
If you mean how you could find out after-the-fact...
August 23, 2013 at 4:23 pm
Can you explain the business rules for which CourseID in #CurrrentSchedule with which CourseID in #LastYearMark?
August 23, 2013 at 4:20 pm
Change tracking?
ADO Sync Framework?
Merge replication?
BULK INSERT?
SSIS?
Triggers?
Service Broker?
There are plenty of options, but which is the best depends on your situation - which we know nothing about.
August 23, 2013 at 4:10 pm
Eugene-928407 (5/25/2012)
The odd thing is that the 1st query runs much slower. According to the execution plan it's relative cost is 96% compared to 4%.
It is not surprising that the...
August 23, 2013 at 4:07 pm
TheSQLGuru (8/22/2013)
2) use explicit transaction control3) use error handling to rollback and exit and stop looping if error occurs
Note that you cannot wrap the whole thing into a single transaction,...
August 23, 2013 at 3:47 pm
TheSQLGuru (8/22/2013)
August 23, 2013 at 3:41 pm
HanShi (8/23/2013)
August 23, 2013 at 3:35 pm
Indianrock (8/22/2013)
August 23, 2013 at 3:32 pm
Please post the output from "SELECT @@version".
August 23, 2013 at 3:23 pm
My preference is to have tempdb on a separate disk, as there can be some quite heavy action in tempdb. If master, model and msdb are on the same disk...
August 23, 2013 at 3:21 pm
It is not about what you are logged in as! It is what SQL Server is logged in as!
Open SQL Server Configuration Manager, find the service, select Properties, check...
August 23, 2013 at 12:52 am
The correct approach is to model your data correctly and enforce primary keys. It seems that you have a lot of duplicate rows. DISTINCT is only a band-aid to fix...
August 23, 2013 at 12:38 am
And how many rows are there in the other table?
August 22, 2013 at 4:21 pm
Viewing 15 posts - 766 through 780 (of 1,219 total)