Viewing 15 posts - 7,696 through 7,710 (of 59,072 total)
For a direct, single table update, the alias shouldn't be needed.
Correct... it shouldn't be. But sometimes and in a most unpredictable fashion, it works out better.
February 21, 2020 at 9:43 pm
I know that it won't seem like it should make any difference but try the following and see if it does...
UPDATE tt
set SQL_DETAIL='SELECT ROWID_OBJECT, HUB_STATE_IND, MDM_ID, SEQ_NM, MSP_END_CUST_NM,...
February 21, 2020 at 4:32 pm
You say it should scale to 1PB and so this sounds like some hardware that's pretty important to the company. And, it sounds like you have something to do with...
February 21, 2020 at 1:23 pm
Sorry... I missed that last post. Interesting idea. I'll have to test it against the million node adjacency list.
February 20, 2020 at 6:02 pm
I know that it won't seem like it should make any difference but try the following and see if it does...
UPDATE tt
set SQL_DETAIL='SELECT ROWID_OBJECT, HUB_STATE_IND, MDM_ID, SEQ_NM, MSP_END_CUST_NM, SEQ_TYP_CD, OST_NM,...
February 20, 2020 at 3:22 pm
Great article by Mr. Ferris, Grant. And great observations (I don't want to call it "advice" because I think that wouldn't be in the same good spirit it was offered)...
February 20, 2020 at 3:03 pm
I have never changed the fill factor on an instance or index level, so it will be using the default of 100% (or 0%), unless the database/indexes are setup...
February 20, 2020 at 2:30 pm
Brian,
Here's what my morning report looks like. It only reports missing servers, disks that have 10% or less free space, or disks that have the "IsDirty" bit (indicates that a...
February 19, 2020 at 6:36 pm
Ah... and I forgot to mention that, in the process, it tests for connectivity and, if it fails that, it also does a ping test and reports on both along...
February 19, 2020 at 2:35 pm
Ok. Thanks, Thom.
Now, if the OP would get back to his post and answer my question about disk status, I might be able to help a bit more. I have...
February 19, 2020 at 2:30 pm
Jeff Moden wrote:What would you use to run the PowerShell script on a scheduled basis? Please don't say the "Windows Task Scheduler".
SQL Server Agent can run Powershell tasks natively.
Can you...
February 19, 2020 at 2:17 pm
What would you use to run the PowerShell script on a scheduled basis? Please don't say the "Windows Task Scheduler".
February 19, 2020 at 2:01 pm
Mmmmm... Not digging that answer, but I'm not stupid enough to start an argument with Kendra.
Roger that!
February 19, 2020 at 5:03 am
Team
I have populated list of ServerName from the sql server query. I would like to add a column stating 'Ping Status' > The result should be reachable or not...
February 19, 2020 at 3:15 am
Viewing 15 posts - 7,696 through 7,710 (of 59,072 total)