Viewing 15 posts - 61 through 75 (of 476 total)
With that said - the SSIS approach can simplify the SQL side (simpler queries) but at a cost of a more complexity in the package. If you are heavily...
February 19, 2021 at 5:29 am
SQL does not guarantee the order of the data unless there is an ORDER BY. This may work just fine - until it doesn't...
Ahhhh ... so true, thanks. I...
February 18, 2021 at 5:58 pm
My understanding is that the Developer version of SQL Server can be used for Dev and Test environments. I would be inclined to use multiple VMs..
That's obvious, now you...
February 18, 2021 at 4:46 pm
Michael, Thank you, that's very helpful.
If there is a specific set of requirements, such as auditing or compliance, where you need to isolate these environments, there should be no...
February 18, 2021 at 4:45 pm
I had a chat with our IT Services and the world has moved on such that we can see a way to a very straightforward segregated DEV / TEST environment...
February 18, 2021 at 12:15 pm
Each release we have a single upgrade script for the DB. Which is generated from database object files (SPs, views, UDFs) that changes after a given SVN commit revision...
February 18, 2021 at 11:57 am
Where will it end? Can the planet store every YouTube, which every YouTuber creates every day ... forever? In ever increasingly High Definition quality?
Even if that is not an issue...
February 18, 2021 at 6:31 am
The main export data output is 85 columns. They must be delimited by the bar character per the recipient's requirements.
If you just want to output the data "raw"...
February 18, 2021 at 6:11 am
I thought about doing a new Row 1 with just these items and then filling in the following columns with empty data and then a Union All, but then...
February 17, 2021 at 4:58 pm
The reason to put the work ID/ticket ID in the commit message is so that if, for example, there is a problem, say in an stored proc file, you...
February 17, 2021 at 2:19 pm
We set "Attributes" on a column (in our own Meta Data) for things like this.
I would hate to intrust it to a bunch of updates, in a script disassociated from...
February 17, 2021 at 1:27 pm
I've never put anything in the Commit Message (never is too strong, but certainly not individual notes on each COMMIT such a Ticket No related to the change I made)....
February 17, 2021 at 12:37 pm
FWIW I think the MS Default location for database files
C:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQL\DATA\
is a dreadful choice. Quite apart from storing them under the PROGRAM FILES folder, also included the SQL...
February 17, 2021 at 6:17 am
Are you just trying to set the initial value, when the column is created (i.e. and then DROP the DEFAULT and thereafter apply the value from programming?)
Or are you looking...
February 17, 2021 at 5:54 am
Can't remember when I last had to said what I did to someone who would know what it was ... so to lay-folk, in answer to "What do you do",...
February 17, 2021 at 5:28 am
Viewing 15 posts - 61 through 75 (of 476 total)