Viewing 15 posts - 1,276 through 1,290 (of 6,679 total)
If you reread what I wrote, you would see that I don't agree with creating a view for future proofing.
I stated that using a view for refactoring is acceptable and...
February 21, 2021 at 2:38 am
Thank you for the feedback, happy to help
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...
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...
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...
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...
February 20, 2021 at 3:19 pm
The default for the MAX columns is in-row...not sure why that choice was made.
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...
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...
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...
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...
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...
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...
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...
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...
February 18, 2021 at 7:50 pm
Viewing 15 posts - 1,276 through 1,290 (of 6,679 total)