Viewing 15 posts - 1,276 through 1,290 (of 6,676 total)
Thank you for the feedback, happy to 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
February 21, 2021 at 1:05 am
Thank you for the response. I am using unique bar codes in both files. I want the result to split in two, match and no match OlE DBs.
When you...
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 20, 2021 at 5:59 pm
Any issues with references can be mitigated by creating these views with schema binding. That will mean that changes to the table cannot be made until that binding is removed...
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 20, 2021 at 5:57 pm
Nothing wrong or problematic using views - or using views in this manner. The problem with views comes into play when you have a view of a view of a...
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 20, 2021 at 3:31 pm
Script the login from the primary - with the SID - and create the login on the secondary with that SID. I use SQLCMD mode to create the login 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
February 20, 2021 at 3:19 pm
The default for the MAX columns is in-row...not sure why that choice was made.
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 19, 2021 at 5:43 pm
The only thing I can think of is to make sure the nvarchar(max) column is stored off-row. By default it will be stored in-row and that is where you would...
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 19, 2021 at 5:22 pm
Ah thanks. That explains it all. I'm going to see if I can't leverage this to do some CSV parsing (I have a task to deal with a bunch...
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 19, 2021 at 4:24 pm
Definitely test the process...
After bring the database online on the secondary - yes, you will have both databases available, but since it has been removed from the AG this won't...
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 19, 2021 at 4:17 pm
@JeffModen - your solution and my solution are very close to the same. If we pass in 2022 as the starting year - both version return an empty set. 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 19, 2021 at 4:11 pm
You can change the default file locations when installing SQL Server. You can also move the system databases later if you want to.
I have always found this...
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 8:48 pm
This can be simplified - without having to use fnTally to:
With t(n)
As (
Select t.n
From...
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 8:42 pm
You can change the default file locations when installing SQL Server. You can also move the system databases later if you want to.
I have always found this to be...
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 7:59 pm
On the source system - what principle is defined as the database owner? It appears that the database on the source system is not owned by sa - which leads...
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 7:50 pm
This should sort the output by SECTION (header first) and then my [MyPKCol] - a column(s) from your actual table so that the individual data rows are ordered. You...
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 6:53 pm
Viewing 15 posts - 1,276 through 1,290 (of 6,676 total)