Viewing 15 posts - 4,861 through 4,875 (of 39,740 total)
The only way poor code in Azure makes you pay more is if you need to change your DTU level up to account for more workload. As Grant and
September 11, 2018 at 12:03 pm
From what I understand, if you're changing the password, I believe this means you're exporting the cert again with a new password on the private key file. That's essentially a...
September 11, 2018 at 11:58 am
chrisn-585491 - Monday, September 10, 2018 11:00 AMI was really enamored with Azure as a service last week. :Whistling:
It happens, and...
September 10, 2018 at 2:44 pm
September 10, 2018 at 2:42 pm
Eric has good points. This can be tough in an hour. I think even a star schema is tough in an hour, but perhaps you can just cover higher level...
September 10, 2018 at 2:40 pm
A DACPAC should only have schema changes, so I wouldn't expect that much space. Did you check what the changes were that could have been applied? That might help you....
September 10, 2018 at 2:40 pm
Moving the authorization to a new user works.
September 10, 2018 at 8:07 am
There are times you'll get this but if you look at your current query, it can be connected with the DAC, but you've gotten an error from the Object Explorer...
September 10, 2018 at 8:00 am
Good answer above. For querying and manipulation of updates, normalized tables are better. Trying to update a set of values in multiple XML documents is slow and problematic. Is this...
September 10, 2018 at 7:57 am
I'd certainly use a calendar table here to help set ranges. A tally table in a CTE will help build this. I'd then have to put in CASEs that would...
September 10, 2018 at 7:55 am
A few things. First, Adventureworks is built as a sample to show off features for Microsoft. It's not necessarily a great database design.
A PK is for uniqueness in...
September 10, 2018 at 7:53 am
I prefer the windowing function in general, but you ought to test both, watching the number of logical reads each incurs.
September 10, 2018 at 7:50 am
You can read about log escalation, but if you are updating lots of rows, SQL might decide it's quicker to get an exclusive table lock rather than thousands of individual...
September 10, 2018 at 7:48 am
The results aren't in memory, but rather the table data used to generate the results. When you query the table, SQL Server loads most of the data into the buffer...
September 10, 2018 at 7:46 am
The answer here is A. You restore the database since there was no corruption in that backup. Of course, you need to re-run dbcc to verify this after the restore.
September 10, 2018 at 7:45 am
Viewing 15 posts - 4,861 through 4,875 (of 39,740 total)