2010-10-14
2,939 reads
Tom Brown
2010-05-07
3,601 reads
Using Triggers for Detective Work
When a value is changed that causes an error, finding what caused the error can be tricky. Here an application was truncating a column. The trigger helped to identify the culprit.
2008-09-25 (first published: 2008-07-17)
1,380 reads
Blogs
Power Platform Quick Tips – Episode 01: Fixing Power BI Column Sorting
By Devin-Knight
Check out this new series that I’ve started on Power Platform Quick Tips. This...
The curious case of CHAR(0)
Over the years I’ve seen quite a few strange things with SQL Server. This...
Transaction log Information gathering
By Vinay Thakur
Here are the different ways to know the tlog file related information sys.dm_db_log_stats –...
Forums
how can i see the last 100 select statements that were run by any user
how can i see the last 100 select statements that were run by any...
Dynamically execute SSIS package.
I am trying to figure out how to dynamically execute SSIS package based on...
Metric CPU show 100% , but Query Performance Insight show only 60% same period
Hi, I am investigation DTU spike for period specific period of time In my...
Ask SSC