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...
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
August 24, 2013 at 3:14 am
Indianrock (8/23/2013)
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
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...
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
August 23, 2013 at 4:23 pm
Can you explain the business rules for which CourseID in #CurrrentSchedule with which CourseID in #LastYearMark?
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
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.
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
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...
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
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,...
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
August 23, 2013 at 3:47 pm
TheSQLGuru (8/22/2013)
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
August 23, 2013 at 3:41 pm
HanShi (8/23/2013)
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
August 23, 2013 at 3:35 pm
Indianrock (8/22/2013)
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
August 23, 2013 at 3:32 pm
Please post the output from "SELECT @@version".
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
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...
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
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...
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
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...
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
August 23, 2013 at 12:38 am
And how many rows are there in the other table?
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
August 22, 2013 at 4:21 pm
Viewing 15 posts - 766 through 780 (of 1,219 total)