Viewing 15 posts - 2,581 through 2,595 (of 39,818 total)
Yes, the login isn't correct. That's what the error is.
July 22, 2020 at 3:38 pm
The best way to speed up backups is to stripe them. The SQL engine can then spew out pages to multiple locations. If you have good hardware, I'd look at...
July 22, 2020 at 3:37 pm
Does it pause at the same point each time?
I'd start to break apart the package and test things separately. Pick a certain item, then make a new package to do...
July 22, 2020 at 3:32 pm
I like the idea of altering the temp file to include missing columns. It's a simple solution that means the important part, the reads, don't change and you don't get...
July 22, 2020 at 3:25 pm
Consummable data means posting the CREATE TABLE statements, with some INSERTs for sample data. Not just describing the columns.
July 22, 2020 at 3:21 pm
+1 for Brian's thoughts. The indexing is driven by the query patterns.
July 22, 2020 at 3:20 pm
This isn't out of the box. SQL Prompt does this, as does SSMS Tools Pack, but you pay for both.
Disclosure: I work for Redgate, developer of SQL Prompt.
July 22, 2020 at 3:19 pm
I'd agree with you, but how do you prevent someone that admins a database from making a change? Our platforms don't do a great job of preventing this. Something like...
July 22, 2020 at 3:08 pm
That's a good system, Chris Wooding. Not perfect, but likely it works well unless you have a rogue admin. I still like the idea of using a pipeline of sorts...
July 22, 2020 at 2:56 pm
I'll post a note to Microsoft and see if I can get a response.
July 22, 2020 at 1:52 pm
Nope, that was all I wanted to say. I'll add in the a few more words.
July 22, 2020 at 1:50 pm
To add to what Grant said, create the role in your database and then add the group (I assume this is an AD group) to the role with ALTER ROLE...
July 21, 2020 at 4:22 pm
Is that the only output? Isn't there something from DBCC besides what you are returning?
July 21, 2020 at 4:16 pm
You are running EE, so no memory limits. 64GB might be small these days. I think I'd go to 128GB at a minimum or 256 if I think this workload...
July 21, 2020 at 4:11 pm
Viewing 15 posts - 2,581 through 2,595 (of 39,818 total)