I'm running a query on SQL Server based on a view. This view's main data source is a table with close to 50 million rows of data. For weeks I've been running the query in question and it's been completing in about 20 minutes. I tried running it recently and it is unusable. It takes more than 2.5 ...
One thing to look at when something is suddenly slower is out-of-date statistics.
As a software engineer, I need to sometimes describe a piece of code as something that lacks performance or was not written with performance in mind.
Example:
This kind of coding style leads to unmaintainable and unperformant code.
Based on my Google searches, this isn't a real word. What ...
I have a table with two datetime2 columns which I want to add the time it took from callstartdt to callenddt.
I have tried something like this
select
DATEADD(minute, callstartdt, callenddt) as summing
from Detail
where SeqNum = 87
but I always end up with a error like
Argument data ...
PRINT N'
EXECUTE MyDatabase.dbo.sp_addsubscription
@publication = N''MyPublication'',
@subscriber = ''' + CAST(SERVERPROPERTY('ServerName') AS SYSNAME) + ''',
@destination_db = ''SubscriberDatabase'',
@subscription_type = N''Push'',
@sync_type = N''automatic'',
@article = N''all'',
...
