Viewing 15 posts - 1,666 through 1,680 (of 2,918 total)
heh... now you have me second guessing myself on that atom file thing... Been forever since I used that as I found it to be unreliable and annoying to work...
July 29, 2020 at 6:57 pm
As far as I know, if a row has no guaranteed way to be unique, SQL adds a hidden column onto the end to make it unique. Since you didn't...
July 29, 2020 at 5:29 pm
Disadvantage to exporting to Excel from the SSRS site is that you get a static output of the report. Nice thing of Power Pivot is you can click a button...
July 29, 2020 at 4:01 pm
I forgot about one - power pivot inside Excel. Using that you can pull the data from the SSRS server into Excel. Still technically uses the SSRS web stuff and...
July 29, 2020 at 3:40 pm
If you are running Windows 10 and have it stored in your profile, that could be your problem. I've had files (not specifically dtsx files, but pictures) just disappear on...
July 28, 2020 at 9:49 pm
to reproduce the error, set strType to a value other than AAA or BBB. This is easy to do in the debugger (breakpoint, add a watch on "strType" and change...
July 28, 2020 at 5:43 pm
That I am not entirely sure. Best guess - I am wrong on how it is matching things up with the recursive query which I was actually able to prove...
July 28, 2020 at 5:26 pm
Nice! Thanks for the followup!
Only thing I see that may be of concern is that if cmd.ExecuteScaler() throws an exception, that exception is going to be passed back to the...
July 27, 2020 at 9:54 pm
To confirm, you SEE this blocking? The reason I ask is that a SINGLE SQL query, even a recursive one, will use the SAME SPID for the lifetime of the...
July 27, 2020 at 9:41 pm
did you get this sorted out?
July 27, 2020 at 9:20 pm
looking at the graphs doesn't mean much if you don't have a reasonable scale. your scale of 0 to 100 doesn't really tell us much as 0 to 100 bytes...
July 27, 2020 at 9:18 pm
Looking at the execution plan images (as we have no actual execution plan to review) your biggest hitters are the DELETE and the INSERT, so I too am wondering if...
July 27, 2020 at 8:02 pm
First step to troubleshooting this is to look at the error message.
Can you post that?
Doing a differential backup should be very similar to a tlog backup or a full backup,...
July 27, 2020 at 7:19 pm
If you have the RDL file, you can open that in Visual Studio.
Alternately, if you don't want to open a report URL, you could build a tool that essentially opens...
July 27, 2020 at 5:21 pm
it looks to me like you declare one variable, but use one that never existed a few lines later:
i think you declared "SQL", but dynamically create "strSQL" a few...
July 27, 2020 at 5:18 pm
Viewing 15 posts - 1,666 through 1,680 (of 2,918 total)