Viewing 15 posts - 1,576 through 1,590 (of 2,917 total)
I think it depends on your workloads and environment. For example, if you have a data mart that gets re-loaded nightly using the truncate->reload methodology, and you are doing hourly...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
September 11, 2020 at 7:22 pm
There area lot that can do it I'm sure. The first few that come to mind are SSMS and Visual Studio though. Both of these can see all of the...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
September 11, 2020 at 7:05 pm
An alternate approach would be to look at the files in the file system. If you select multiple files (in Windows anyways), it will tell you the file size. And...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
September 9, 2020 at 2:34 pm
First - I'd recommend against crossposting. I found your post on here, Microsoft and VMWare. This is the only one with replies though.
I do not have failover clustering set up...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
September 8, 2020 at 9:48 pm
if I understand right, you want to do an insert into 2 different temp tables from a CTE in a single query? If so, I don't think that is possible. ...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
September 8, 2020 at 8:48 pm
My approach - get a monitoring tool to grab the data for you rather than watching things yourself and check the tool over a large timeline to get a baseline.
And...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
September 4, 2020 at 8:10 pm
I think the easiest way would be to join the tables in the query, but that may not be possible. Failing that, I think your second dataset would need a...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
September 4, 2020 at 6:44 pm
Another approach would be to go back to your query where you have all of those CTE's and UNION all of the data from the non-master table in your second...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
September 4, 2020 at 4:13 pm
a_car11 - Just so I understand the question correctly, you want to get all of the records that ONLY exist in 1 of the 50 tables, correct? I just want...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
September 3, 2020 at 10:15 pm
I think you will want to look into windowing functions. in this particular example, remove your GROUP BY and change your SUM to:
,SUM(B.MappedAmont) OVER (PARTITION BY A.BudgetId,...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
August 28, 2020 at 9:03 pm
Offhand, I am not sure if activity monitor could do that, but I would not be surprised. If I remember right, it opens a transaction when you open it and...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
August 28, 2020 at 8:45 pm
Not entirely sure why that would need to be "DNSLess"... you can use DNS without using ODBC. But maybe I'm just misunderstanding the terminology.
Which brings me back to the first...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
August 28, 2020 at 5:57 pm
My first thought - what is the error?
Without the error message, it is hard for us to help.
Also, when you say "DNSLess", i am assuming you mean you are connecting...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
August 28, 2020 at 4:23 pm
Something like this i think should work:
USE [Admin];
GO
SELECT
*
FROM[myTable];
DECLARE @CastedCols NVARCHAR(MAX);
SELECT
@CastedCols = COALESCE( @CastedCols + N','
, N''
) + N'CAST(' + QUOTENAME([c].[name]) +...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
August 26, 2020 at 10:05 pm
One solution may be to reduce the number of NCI's.
But, before looking at that, it may not hurt to grab an execution plan and see what is happening when you...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
August 26, 2020 at 9:53 pm
Viewing 15 posts - 1,576 through 1,590 (of 2,917 total)