Viewing 15 posts - 1 through 15 (of 331 total)
this is valuable feedback. thanks a million, very much appreciated!
May 14, 2020 at 10:34 am
thx for the suggestin Jeff. I'd really prefer NOT to free the cache.. Looking for the command to mark the procs for RECOMPILE -- across all DB's..
May 13, 2020 at 3:05 pm
I agree. Our SQL Replications (Log reader agents, Distributor agents, Snapshot agents) are all running clean with no issue. It's just when we start up Repl Monitor that the RED...
April 16, 2020 at 10:12 am
I found these via a GOOGLE search:
- Splashtop (Advertising)
- Chrome Remote Desktop
- Microsoft Remote Desktop
Again, just looking for feedback from those who highly recommend a...
March 11, 2020 at 1:56 pm
ERROR: The 'Microsoft.ACE.OLEDB.16.0' provider is not registered on the local machine
Thoughts on how to configure our Windows 10 laptop running SSMS 2017 v18.3 on SQL 2017 Developer Edition to allow...
September 27, 2019 at 11:09 am
Andrey, thanks. This is very helpful. I was hoping there was a 1 line, auto-magical script which could perform much of this but I understand it is a multi-step process.. ...
July 29, 2019 at 12:37 pm
thanks! that worked perfectly. My test results:
To decompress/uncompress a table, I simply changed the DATA_COMPRESSION attribute from PAGE back to NONE:
-- to Compress:
ALTER TABLE [dbo].[my_tablename] REBUILD PARTITION = ALL...
May 28, 2019 at 1:40 pm
this worked: EXEC master.dbo.sp_serveroption @server=N'ServerLINKEDServer', @optname=N'name', @optvalue=N'Server_NEW_LINKEDServer'
( I did not need to specify my ServerABC name which is the SQL Server housing the original Linked Server name: ServerLINKEDServer )
December 11, 2018 at 9:25 am
excellent feedback Steve. fyi, I've deployed Ola's backup, IndexOptimize and Integrity Check solution on every server so we're good w/ the system & application DB backups (FULLs, DIFFs and T-logs)...
August 28, 2018 at 9:01 am
So, based on your feedback -- w/ master and msdb restored to the same-named, remote server name (assuming the original server was destroyed). we'd get the following objects restored:
August 28, 2018 at 7:49 am
Jeff - thanks for your reply. Question - in a D/R recovery scenario, once I restore all my system DB's & application DB's (including SSISDB and Distribution DB) onto my...
August 28, 2018 at 5:49 am
August 1, 2018 at 5:37 am
I embedded my original commandinto the -Invoke-Command ----- and specified the -ComputerName followed by the -ScriptBlock contents which was my original command.
Invoke-Command -ComputerName MyComputeName1...
July 5, 2018 at 7:21 am
I found the answer to this question. I brought up SSDT, opened my SSRS Solution, clicked on "VIEW" on the toolbar, and clicked on the last item in the popup...
June 26, 2018 at 6:05 am
thx for the quick reply. When I look at my txt box properties (text box is named [Active]), I right mouse click, then click fx Expression, I see: =Fields!Active.Value
May 24, 2018 at 7:23 am