Comments
Sort by recent activity
The obvious question is have you verified that the production database is in fact not corrupted? Did you try recreating the clone? Do you get the same error if you do the same operation from a different client? / comments
The obvious question is have you verified that the production database is in fact not corrupted? Did you try recreating the clone? Do you get the same error if you do the same operation from a diff...
OK. Lets take a different tack then: Is there a way to use SQL Prompt such that you just see differences for objects/object types selected - without concern for anything else? I presume not, but it would be helpful in my current use case (finding differences between numerous supposedly-identical databases).
Regarding decrypt objects helping with performance, that should only make a difference if there actually are lots of encrypted objects, right? / comments
OK. Lets take a different tack then: Is there a way to use SQL Prompt such that you just see differences for objects/object types selected - without concern for anything else? I presume not, but it...
First thing is to research your RDP tool to see if you can adjust screen size. Failing that, the next best idea is to get a better RDP tool. :-)
However, for a window that is not maximized you can click the upper left corner of the window and select Move from the drop down menu. So check to see if there is a keystroke combo that will get you that menu so you can get Move selected (with down-arrow and enter) and then you can use down-arrow to reposition the window. / comments
First thing is to research your RDP tool to see if you can adjust screen size. Failing that, the next best idea is to get a better RDP tool. :-)
However, for a window that is not maximized you can ...
Plus a bunch to this request. / comments
Plus a bunch to this request.
I'm not sure what the OP is asking for, or did, either. Offline as in detach the database? / comments
I'm not sure what the OP is asking for, or did, either. Offline as in detach the database?
These must be stored as cookie values, right (or perhaps table row values)? Either way it should be trivial allow a right-click to remove a value that is no longer desired to be in the list. That would also allow us to keep one-offs from forcing more used/useful values off of the list. / comments
These must be stored as cookie values, right (or perhaps table row values)? Either way it should be trivial allow a right-click to remove a value that is no longer desired to be in the list. That w...
+1.
Right-click a drop-down row and Remove should be easy, right? Allowing CTRL-Click to allow for removing multiple at once could be a bonus. / comments
+1.
Right-click a drop-down row and Remove should be easy, right? Allowing CTRL-Click to allow for removing multiple at once could be a bonus.
Not sure if it comes into play, but could file zeroing be a thing here? Would Instant File Initialization be helpful if so?
Other than that, I would say it is VERY dependent on your IO read, network, IO write capabilities and latencies - which can each be a HUGE impediment to throughput. / comments
Not sure if it comes into play, but could file zeroing be a thing here? Would Instant File Initialization be helpful if so?
Other than that, I would say it is VERY dependent on your IO read, networ...
You do not move the data multiple times when you use SQL Clone. One move to create the image (from a backup or directly from a live database). Then it is just "mounting" that image as a new read/write database on any SQL Server. Each time you do this it takes 10-15 seconds and ~50MB of local disk space.
Now, if you actually ACCESS data (say for tuning some query or running some report) then you move the data to the local box. Thus the network becomes much more important piece of the infrastructure pie (as does the storage you create the image on). / comments
You do not move the data multiple times when you use SQL Clone. One move to create the image (from a backup or directly from a live database). Then it is just "mounting" that image as a new read/wr...
I agree with Grant, but with a rather large caveat. The query plan you get is drastically influenced by the "server" capabilities. In the vast majority of cases the machine you mount a clone on will be a fraction of the hardware (especially the optimizer-affecting ones of CPU and RAM) that the production box is. So you could wind up chasing a red herring or worse. Another potential gotcha is the edition/version/build of SQL Server the clone is mounted on. / comments
I agree with Grant, but with a rather large caveat. The query plan you get is drastically influenced by the "server" capabilities. In the vast majority of cases the machine you mount a clone on wil...