Forum Replies Created
Viewing 15 posts - 601 through 615 (of 7,505 total)
-
Reply To: Does sp_recompile recompiles referenced objects?
no, it does *not* mark downstream objects to be recompiled too!
-
Reply To: Looking for odbc connect parameters in msdb-database
Check my little article to get you started:
"Logon monitoring in SQL Server and Azure Managed Instances - Adopting Extended Events"
-
Reply To: Hey, I am trying to learning SQL on my own and I am stuck in an error.
Select Avg(datediff(ss, Start_time , End_time )) as avg_time_duration_in_Seconds From table
-
Reply To: Deleteing BLOB-STORAGE files from an On-premise server.
I've had my Azure dev write an Azure Logic App to remove files of a given container path after 30 days.
-
Reply To: Creating index for a very huge table
- pre-extend the transaction log file to be able to cope with the extra create-index load.
- multiple files in the filegroup where the index is being created.
- multiple disks /...
-
Reply To: Performance of same query slower for a different user
julian.fletcher wrote:....
Could the fact that one was a Windows user and the other a SQL one have anything to do with it?
No
-
Reply To: Performance of same query slower for a different user
As SSMS plan compare shows, a huge chunk of time is wasted with the FILTER operator ! ( 8sec vs 43sec ! )
-
Reply To: Performance of same query slower for a different user
Replace the Scalar Value function with a (in-line) Table Value Function and you will have a stable running potentially fast query !
...
outer apply dbo.tvf_GenerateCostCode(CC.Code, SU.Code,... -
Reply To: explicite alternative to FORMAT() concerning DATE
Jeff Moden wrote:@Johan ... Do you have the code where you created and populated the #TallyDate table so that newbies can run your test?
Also, your good code doesn't need the DATEADD/DATEDIFF...
-
Reply To: explicite alternative to FORMAT() concerning DATE
The test is simple and straight forward
set statistics time , io on
go
select FORMAT(datecol, 'yyyy-MM-dd') as Datetext
from #TallyDate
--order by DateCol
/*
(10000 rows affected)
Table '#TallyDate__________________________________________________________________________________________________________000000000008'. Scan count 1, logical reads... -
Reply To: Availability Groups
just to add to Jeffrey's hints:
Keep in mind your secondaries will also need the same size available !
Don't forget your LDF files ! (these do not benefit from IFI !...
-
Reply To: Connecting Cloud Run to cloud sql
Which cloud(s) are you using?
how did you configure your connections?
how does your routing work?
did you configure the needed firewall rules?
-
Reply To: UNION from many linked servers
If possible, avoid linked servers.
your code may block others ( local to the linked server ) !
Maybe your process is even better off doing its stuff using e.g. SSIS (...
-
Reply To: How to put a variable content as attachment file saida.txt ?
You could put it all in a table ( non-# and non-## ), kind of a key-value pair thing.
Then have the query selecting your stored row from the table
June 15, 2022 at 12:59 pm
-
Reply To: How to put a variable content as attachment file saida.txt ?
Best is to have sp_send_dbmail execute the query and store the result in a given filename to be added to the email
e.g:
declare @subject varchar(1000)
set @subject = @@servername...
Viewing 15 posts - 601 through 615 (of 7,505 total)