Viewing 15 posts - 31 through 45 (of 248 total)
hi Sam
check best practices for SSISDB first
https://www.mssqltips.com/sqlservertip/4811/sql-server-integration-services-catalog-best-practices/
better purge job
https://www.timmitchell.net/post/2018/12/30/a-better-way-to-clean-up-the-ssis-catalog-database/
It is possible to move SSISDB like other databases.
September 26, 2019 at 8:31 am
Since SQL2016 already.
https://logicalread.com/installing-sql-server-management-studio-for-sql-server-2016/
September 25, 2019 at 2:48 pm
for connection string try the following :
tcp:hostname,portname
link:
September 25, 2019 at 2:08 pm
another possible reason:
"The Database Engine can also reduce the degree of parallelism if the leading key column of a non-partitioned index has a limited number of distinct values or the...
September 25, 2019 at 1:46 pm
Hi Paul!
If i'm not mistaken, you have issue with running the same proc in parallel sessions simultaneously.
I suspect there's lock escalation happens which affects second session.
I would try to disable...
September 5, 2019 at 11:19 am
the code has second problems for you?
Sorry, I don't get the question.
September 5, 2019 at 10:59 am
I have a T-SQL procedure that runs on 2 different servers, on the same db, has different execution times:
server 1, not in production, 4 minutes
server 2, in production, 18...
September 5, 2019 at 10:41 am
How about if I want to cycle the log every week ?
Does it mean I need to set up the maximum of error log = 12 ?
as I want...
September 5, 2019 at 10:24 am
Sam,
what will the following command return?
exec sp_spaceused 'dbo.CONTROL_HIST'
It looks like you have BLOB data types, however I don't see it in the table definition.
September 5, 2019 at 10:14 am
I don't believe in magic, there should be differences in query plans (prod slow, prod fast maxdop 1, dev fast) and/or statistics.
Also, it's worth to compare "select @@version" on both...
September 4, 2019 at 3:56 pm
One of the things to try :
if it works fine with maxdop 1, enable QueryStore if it's not enabled yet, get fast plan captured in it and force the query...
September 4, 2019 at 11:43 am
Oh go on Steve - pick an easy solution!
Doesn't help for my 12 month task (the joys of a PCI audit), but I do wish I'd thought of that.
Another...
September 4, 2019 at 11:33 am
SELECT
Operation,
[Transaction Id],
[Transaction SID],
[Transaction Name],
[Begin Time],
[SPID],
Description
FROM fn_dblog (NULL, NULL)
WHERE [Transaction Name] = 'DROPOBJ'
is not available in Azure?
It's an option, but when you have no control over backups (log backups, for...
August 30, 2019 at 10:11 am
The object drop events are logged in the default trace, and from there you can get date/time, session login name, etc.
Default trace is not available in Azure ...
August 30, 2019 at 10:07 am
Hi All,
Someone has dropped a table from azure database and i want to track who did it.
afaik, it's not possible out-of-the-box in Azure.
How to know the which user...
August 29, 2019 at 3:36 pm
Viewing 15 posts - 31 through 45 (of 248 total)