Forum Replies Created
Viewing 15 posts - 1,486 through 1,500 (of 6,676 total)
-
Reply To: Need help STRING_SPLIT
In SQL Server 2017 and higher - you can use STRING_AGG...and Informix has LISTAGG: https://www.ibm.com/support/knowledgecenter/SSGNPV_2.0.0/com.ibm.db2.luw.sql.ref.doc/doc/r0058709.html
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs -
Reply To: Execution Log Clean Up
You cannot change the time when that process runs - but you can disable the process that removes log entries and perform that step manually.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs -
Reply To: SIS gets stuck on data flow task loading screen upon opening project
If you are using the Excel connection as a destination - it expects to find a file with the specified name in the directory. If that file does not exist...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs -
Reply To: comma issues in sql statement
I don't see anything in your query that needs to be done dynamically - can you show the actual code you are attempting to create as a dynamic query and...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs -
Reply To: Temporal Tables - rownumber field
What do you mean by row number? How is that column created and populated - is it really an identity column? If it is really an identity column then the...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs -
Reply To: Need help configuring replication at the Instance not DB level
DCL wrote:Jeffrey - We are using availability groups. I am not at a high enough level to know how to do that using triggers or an agent job. Any help...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs -
Reply To: Need help configuring replication at the Instance not DB level
For AG's - you need to build a script that adds the database to the availability group. This may be something that can be done using automatic seeding - depends...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs -
Reply To: Need help configuring replication at the Instance not DB level
What replication technology are you using now? Is this an availability group - or something else?
If availability group, then you would need to add each new database to the availability...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs -
Reply To: Logshipping for Migrating from SQL Server 2008 to 2019
You want to take a final tail-log backup on the 2008 system at cutover...this will be the final log file for the database(s) and will take the database offline (so...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs -
Reply To: SQL agent job failed
The agent job runs under the context of the owner of the agent job - or the service account if the owner is a sysadmin. Verify the owner of the...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs -
Reply To: Report based on dynamic columns
Without further information or detail - I would recommend modifying your query to return just the levels needed. For example - your query would filter based on the input parameter...returning...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs -
Reply To: Stored procedure that runs quickly in SSMS hangs up in SSRS
Not much for us to go on - not sure how to help diagnose a problem when I cannot see the problem. As a guess - whatever you added is...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs -
Reply To: Restoring Database from Snapshot on the different Server
It is not possible to port a snapshot - because the snapshot is entirely dependent on the source database. The snapshot only contains the delta changes that have occurred in...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs -
Reply To: Get Particular Date from a Month
Interesting - earlier you showed that your scalar function ran significantly faster than your inline...I was just curious as to why that would be the case and thought maybe it...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs -
Reply To: Get Particular Date from a Month
SwePeso wrote:No wonder mine is faster. SQL Server managed to parallelize my function. With MAXDOP 1 my function runs in 1600 ms and Jeffreys in 1100 ms.
I don't have SQL...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 15 posts - 1,486 through 1,500 (of 6,676 total)