Viewing 15 posts - 16 through 30 (of 144 total)
Have a look at the query plans generated by both of the servers. They will almost certainly be different. Does the production query actually finish? If so, you can tell...
December 10, 2019 at 4:14 pm
True, but a COPY_ONLY log backup will not truncate the log, which is what I was getting at.
December 6, 2019 at 4:40 pm
Am I the only one who struggled with item 1 thinking "What if the previous log backup was done with COPY_ONLY?"
December 5, 2019 at 9:26 pm
There are a few things that you will need to keep in mind if you add indexes to the subscriber database.
Never change a primary key. This goes for the structure,...
November 18, 2019 at 4:55 pm
Can you install SSRS on a cluster? Yes and no. Yes, you can install it on individual nodes as a standalone instance, but no, it will not failover. If you...
November 13, 2019 at 4:10 pm
First place I would check is the SQL Server error log. You can get this through the file system, and it is a text file, so you can open it...
November 8, 2019 at 7:31 pm
In some of the earlier iterations of column store indexes, the space used was reported a bit low, if I recall. Could that be contributing here?
November 7, 2019 at 9:42 pm
A nice gotcha warning. I was looking for permission related issues on the ImageFiles table, and not reading the title of the question.
November 7, 2019 at 3:08 pm
For SSIS, make sure you have the 32-bit Oracle driver installed. I believe the wizard uses 32-bit .dlls and such.
November 4, 2019 at 7:07 pm
I have seen this happen to machines that have DHCP enabled. The SQL Engine comes up before the DHCP address is resolved. If this is the case, you should be...
October 31, 2019 at 7:42 pm
Excellent question. I think I read this story years ago, and it was in that vague "I think I heard about this" urban-legendary part of my brain. Surprised I got...
October 31, 2019 at 3:59 pm
Maybe I will go as a wall. But then the developers will say I am not wearing a costume...
October 31, 2019 at 3:55 pm
in the few experiments I have done with Polybase, it seems that it has a lot of JAVA underneath the covers. The External Data Sources are just JDBC connection strings,...
October 30, 2019 at 6:33 pm
This could be a number of things. I would check:
October 30, 2019 at 2:02 pm
In any RDBMS (SQL Server, Oracle, MySQL, etc.) when you do a restore, you have to have all of the files, and all of the pages agree what version you...
October 28, 2019 at 7:58 pm
Viewing 15 posts - 16 through 30 (of 144 total)