FIND OBJECTS BEING REFERRED BY SSRS REPORT
Hi Everyone
In the daily team meeting today, we had a requirement to find out the stored procedure used/referenced by SSRS...
2016-04-07
1,473 reads
lokesh sharma
- Interests: Writing and troubleshooting SQL Queries obviously :-). Other than that a fitness freak
SOME BUGS IN SQL-SSRS 2005
Hi Guys
I know sql 2005 is getting outdated and there would be no support from Microsoft from this month. But lets not...
2016-04-01
397 reads
Handling decimal and non numeric types using Case statement
Hi Guys
Just encountered a scenario where I needed to handle numeric and non numeric types using Case statement. Here is the...
2015-10-14 (first published: 2015-10-06)
3,509 reads
syntax error in textheader of stored procedure - Cause and Solution
Hi Folks,
Comments play an important part in writing any code. Especially when somebody else reads your code. So the other...
2015-08-30
1,307 reads
2015-04-26
Data Rendering Eye Opener SSRS
Hi Folks
Greetings to everyone!!!
So last week one of the report was having a performance issue. It had 10 datasets ,5...
2015-04-22 (first published: 2015-04-12)
6,355 reads
Toggle Functionality Looses In excel--ssrs 2005
Hi Folks
Highlighting on the issue that I faced last week while working on reporting services 2005.
Requirement :- A data region (table)...
2015-04-03
640 reads
Date Range Challenge in sql
Hi Folks,
When you work in a offshore - onsite setup in IT industry and if you are fortunate 🙂 to be a...
2015-03-15
502 reads
Bug In ado.net enumerator in foreach loop in SSIS 2012
Hi Greetings to everyone,
Today I am going to report a bug in SSIS 2012. In one of the packages I...
2014-07-27
991 reads
CTE - Limitations
Hi
Wanted to explore one of the major limitation of CTE in sql 2012 i.e. it cannot be used inside if...
2014-07-27
1,440 reads
Blogs
T-SQL Tuesday #198 Roundup: How Do You Detect Data Changes?
Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the...
Optimizing Redshift Performance by Configuring WLM Queues
Efficient query performance in Amazon Redshift often comes down to how well you manage...
PowerShell Strikes Back: Return of the Loop
By gbargsley
Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is...
Forums
Dealing with huge heap tables
Recently, our dev teams approach me for advice on improving their huge heap table...
Merge Replication failing with Error converting data type nvarchar to numeric
After upgrading 2 Merge Replicated databases to SQL 2022 and re-establishing the Merge Replication...
Why Your Index Isn't Being Used? - Reading Execution Plans to Find the Real Culprit
Comments posted to this topic are about the item Why Your Index Isn't Being...
Question of the Day
Distance Metric Algorithms
What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?
See possible answers