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,429 reads
EVERYDAY MSBI/SQL CHALLENGES
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
396 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,500 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,299 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
636 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
500 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
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
Blogs
Deployment Pipelines in Fabric – What Are They?
By HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
TempDB Internals – What’s New (SQL Server 2016 to 2022)
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers