Reputation
246
Top tag
Next privilege 250 Rep.
View close votes
Badges
1 6
Newest
 Revival
Impact
~13k people reached

  • 0 posts edited
  • 0 helpful flags
  • 2 votes cast
Feb
17
comment How can I get the correct offset between UTC and local times for a date that is before or after DST?
+1 I used a modified version of this to solve a problem. This is exactly what I needed for my scenario.
Feb
17
comment How can I get the correct offset between UTC and local times for a date that is before or after DST?
Regarding Michael Green's comment, you can address the issue by changing it to SELECT DATEADD(MINUTE, DATEDIFF(MINUTE, GETUTCDATE(), GETDATE()), @utc).
Oct
30
awarded  Revival
May
15
revised Master slave replication in mysql seconds behind master goes on increasing
edited body
May
15
answered Master slave replication in mysql seconds behind master goes on increasing
Apr
3
awarded  Yearling
Dec
4
revised Backup sql database directly to FTP server
added 445 characters in body
Jul
4
answered Greyed out menu options, broken activity monitor
Apr
4
answered Backup sql database directly to FTP server
Jan
15
awarded  Student
Jan
14
comment SQL Server Reporting Services Slow TotalTimeDataRetrieval Fast ExecuteReaderTime
Which code? The stored procedure is SELECT Column1, Column2, Column3 FROM SomeDatabase.dbo.SomeTable (NOLOCK) WHERE FilterId = @SomeIntParameter; The report RDL file itself is a simple tablix, a single dataset, and a single parameter. I've noticed the report execution is fine after the first execution completes for a user so long as the ExecutionId doesn't change even if they pick completely different parameter values. When digging through the AdditionalInfo column in ExecutionLog3, it shows the ConnectionOpenTime goes to almost nothing in the subsequent executions.
Jan
14
comment SQL Server Reporting Services Slow TotalTimeDataRetrieval Fast ExecuteReaderTime
Yes, statistics are updated multiple times a day on the underlying table that powers the report. This is not a query performance issue. This is something else.
Jan
14
awarded  Editor
Jan
14
revised SQL Server Reporting Services Slow TotalTimeDataRetrieval Fast ExecuteReaderTime
added 221 characters in body
Jan
14
comment SQL Server Reporting Services Slow TotalTimeDataRetrieval Fast ExecuteReaderTime
Yes. SQL Profile Traces show the stored procedures are taking milliseconds. Internal logging in the stored procedures show they are taking milliseconds.
Jan
14
asked SQL Server Reporting Services Slow TotalTimeDataRetrieval Fast ExecuteReaderTime
Jan
31
awarded  Teacher
Jan
30
answered SQL Analysis Services - SSAS
Dec
20
awarded  Supporter
Dec
20
awarded  Autobiographer