Viewing 15 posts - 46 through 60 (of 1,583 total)
@jacob, thanks as well! I will take a look at this approach as well - much appreciate everyone's help!
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 25, 2016 at 4:52 pm
This was exactly the case! I can't believe I completely overlooked that...wow I feel like an idiot :hehe:
The developers used UniqueID as the PK because in the table they...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 25, 2016 at 4:48 pm
I'm not saying that at all. Check out the original execution plan, looks like it's doing some cartesian product in the portion of code I originally posted.
In the example...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 25, 2016 at 1:13 pm
Whoops, attachments added.
Yes it runs super quick using "test" data, but the original procedure can takes 20 minutes depending on how much data gets loaded into that temp table. ...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 25, 2016 at 1:02 pm
You'll immediately see the problem query in the original execution plan doing the 1.14 billion rows between the Table Spool and the Nested Loop
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 25, 2016 at 12:13 pm
I was hoping there'd be a "Oh you just need to do it this way" by looking at the code...but knew I'd get dinged on the lack of preparation on...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 25, 2016 at 12:11 pm
I don't fully understand how this works to detect changes at the table level. BOL states that 'ALL' is the default value yet using 'ALL' doesn't work when you...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 6, 2016 at 9:47 am
Winner Winner Chicken Dinner 🙂
Thanks a million man! Working like a champ!
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 20, 2016 at 4:57 pm
Not sure I follow you (sorry) or I am not communicating my intent properly.
This is a server that has the default MSSQL service and SSRS service already installed; and works...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 20, 2016 at 2:49 pm
To clarify, I am trying to use multiple SSRS instances on a single database instance
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 19, 2016 at 7:53 pm
I'm in need to accomplish the same thing on a SQL 2008 install. I installed the second reporting server instance...successful.
But how to set it up?
I don't see a 2nd...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 19, 2016 at 7:47 pm
Thanks a lot for this, had to create an index on the larger table been hit but it does work well!
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 8, 2016 at 2:19 pm
I had to completely disable replication altogether and start over.
In retrospect, I believe if I had run the distribution cleanup agents prior to attempting to re-add the publications, it might...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 7, 2015 at 9:59 am
Not sure if this helps or not but basically an rss file consists of a few basic "chunks":
1. Declarations
2. Parameters Collection
Full Rss File Example:
'Report Config Parameters
Dim format as string =...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 3, 2015 at 10:57 am
Short and sweet!:-)
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
October 20, 2015 at 6:29 am
Viewing 15 posts - 46 through 60 (of 1,583 total)