Viewing 15 posts - 16 through 30 (of 1,837 total)
Okay, maybe I misunderstood the OP, but I thought from their explanation of the problem that they were trying to use the TOP clause to only get part of the...
July 23, 2020 at 1:14 pm
...we renamed the new server to MyServer and the original server to MyServerOld... Then we got some error message in the new server's log
DESCRIPTION: Login failed for user 'mydomainname\myServerOld$',...
July 23, 2020 at 12:57 pm
You still never gave us what your answer was...
July 23, 2020 at 12:42 pm
In addition to everything Grant said, and he literally wrote the book on execution plans:
I'd also point out that the ORDER BY dufp.FeatureName will cause a sort to happen,...
July 22, 2020 at 8:46 pm
Salliven,
What is the error on the server side? Look at the SQL Server Logs in the Management folder of Object Explorer, or run a SQL command like:
EXEC...
July 22, 2020 at 8:38 pm
the easiest way to see how often OS is paging is looking at "Pages Input / sec" counter in the "Memory" section of Performance Monitor (perfmon)
July 21, 2020 at 8:13 pm
...Production SQL server. It has 24 Gig of RAM and a 4 Gig page file. Their hosting company said they can increase the page file to a set value,...
July 21, 2020 at 5:38 pm
Maybe I'm misunderstanding them, but these specifications sound a bit old fashioned to me. Does your organization have a SAN? If so that would be the best place to put...
July 21, 2020 at 4:27 pm
...These sheds always contained a comfy chair, a radio (tuned to a station giving the best sports coverage), usually some home brewing equipment (in active use), a few magazines...
July 20, 2020 at 9:37 pm
I'd probably do something with a GROUP BY clause and HAVING clause, maybe:
SELECT MemberNumber, MAX(ContactNumber) AS last_ContactNumber, MAX(ContactDate) AS last_ContactDate
FROM AllEnc f
GROUP BY...
July 15, 2020 at 9:07 pm
This doesn't seem too complicated, what have you tried so far?
July 15, 2020 at 8:35 pm
Another thought on this, what operations are happening in this SSIS package?
If there are any SQL Tasks in it, have you compared the execution plans from the old server to...
July 15, 2020 at 8:27 pm
duplicate posting, see original at:
July 15, 2020 at 8:15 pm
...When looking at hardware online, the specs almost never detail internal info such as used and available drive bays and card slots...
That's actually one of the things I...
July 15, 2020 at 6:54 pm
now we are using ArcServe, and I'm just responsible for 'transactional' data backups coz the vendors will do the nightly backups of all servers.
Doing a quick Google search shows...
July 7, 2020 at 7:14 pm
Viewing 15 posts - 16 through 30 (of 1,837 total)