Viewing 15 posts - 196 through 210 (of 2,883 total)
It is not likely you are going to find someone who will download a random zip file from someone to help with something like this. A better solution is to...
July 8, 2024 at 9:29 pm
True... Could you have the page break in as an expression that depends on how many rows are in the main report? What I mean is if the main report...
July 5, 2024 at 10:33 pm
Offhand I am not certain, but is it possible in the parent report (the one that will contain the sub-report) to put a page break before the sub-report?
July 5, 2024 at 8:00 pm
I don't have any issues with allowing traces to be run in the DEV environment. If I had to wait for a DBA to do that for me, it...
July 5, 2024 at 3:42 pm
My opinion - a developer shouldn't need to run a trace. That's a thing a DBA should be doing. If the developer needs a trace run, the DBA should initiate...
July 4, 2024 at 3:51 pm
Just to reply to both Jeff Moden and Seketon567 - I do agree that Fox was ONE of the places reporting on it, but I heard about it elsewhere. A...
July 4, 2024 at 3:27 pm
Weird question but did you upgrade from a previous version of SQL (2017 or older) to 2019? If so, your maintenance plan MAY be in a previous version format that...
July 3, 2024 at 7:57 pm
one thing you could try is to change @json table variable to a permanent table. That way you can read the response from the WEB API call.
Now, that being said,...
July 3, 2024 at 7:46 pm
Have you checked the official docs:
From there you can see what User Scans is showing you - Number of scans by user queries that did not use 'seek' predicate. So...
June 17, 2024 at 5:52 pm
I would start by not following the news from Fox, but that's just a personal bias against Fox News. I would check tech news sites like the register (for example)...
June 17, 2024 at 5:41 pm
The other thing that helps is once you do the presentation at least once, you get a feel for what parts engaged the audience and what parts were boring and...
June 17, 2024 at 5:29 pm
The way things are set up in my environment, IT doesn't let me auto-generate my SPN's. I can't even make the SPN's. I need to put in a support request...
June 14, 2024 at 9:58 pm
Have you tried googling the error? There are a lot of pages on google with similar errors such as this one:
https://dba.stackexchange.com/questions/188833/sql-linked-server-returning-error-suddenly-upon-query
In that scenario, the problem was a faulty NIC.
I recommend...
June 14, 2024 at 8:34 pm
I may be mistaken but I am pretty sure that the error "The specified network name is no longer available" means that your computer lost access to the server for...
June 14, 2024 at 8:30 pm
Just to add, data manipulation operations (INSERT, UPDATE, and DELETE) on a table need to modify most (all?) indexes on the table. So adding indexes to improve performance of deletes...
May 30, 2024 at 5:25 pm
Viewing 15 posts - 196 through 210 (of 2,883 total)