Viewing 15 posts - 1,291 through 1,305 (of 6,676 total)
The problem is your header record...if you don't have an ORDER BY on the query then that row could be returned by SQL Server as the first row, the last...
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
February 18, 2021 at 5:31 pm
This has a p
I thought about doing a new Row 1 with just these items and then filling in the following columns with empty data and then...
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
February 18, 2021 at 4:49 pm
That is why I asked how you are doing this now...it seems you are using the import/export wizard, or you used that and saved the package.
@JeffModen probably has a set...
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
February 17, 2021 at 8:49 pm
What process are you using to create this file? Is it an SSIS package - BCP output - Powershell - something else? It really depends on how you are building...
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
February 17, 2021 at 7:13 pm
You don't have to delete the database on the secondary - you can recover the database and then restore.
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
February 17, 2021 at 3:21 pm
This might help: https://docs.microsoft.com/en-us/sql/relational-databases/performance/specify-query-parameterization-behavior-by-using-plan-guides?view=sql-server-ver15
But - research and test fully on your system.
Also - take a look at the setting 'Optimize for ad-hoc workloads'. This might also be an option.
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
February 15, 2021 at 5:28 pm
First things first - you should review this document: https://www.brentozar.com/archive/2014/06/trace-flags-1117-1118-tempdb-configuration/. If you are on a version lower than 2016 then you might want to enable the trace flags so auto growth...
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
February 15, 2021 at 5:21 pm
It isn't clear what you are asking - what does moving from server A to server B have to do with availability groups? You also stated there is no connectivity...if...
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
February 15, 2021 at 3:46 pm
I 'reported' the message so it should no longer be visible or available.
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
February 13, 2021 at 6:40 pm
Ok so I attached a zip with a bunch of files (.xml and .csv file and the actual report .rdl). The xml has data with it. I'm not sure...
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
February 13, 2021 at 6:32 pm
Attached a modified RDL
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
February 13, 2021 at 6:29 pm
4. You really have to know the tools that you're working with. As Jeffrey Williams stated in the first reply on this thread, the original problem could be avoided...
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
February 13, 2021 at 5:17 pm
I don't have Report Builder - nor do I have data to support the report. But go ahead and put it up here and I will see what I can...
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
February 13, 2021 at 4:46 pm
Since you are on 2014 - the only method will be to backup/restore - apply tlog backups - and join. If you were on 2016 or higher you could set...
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
February 12, 2021 at 10:25 pm
To merge cells - you need to select the cells, not the row. On the far left - right-click the gray area and insert a new row in the table. ...
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
February 12, 2021 at 8:32 pm
Viewing 15 posts - 1,291 through 1,305 (of 6,676 total)