Activity overview
Latest activity by TheSQLGuru
My laptop has 32GB of RAM. [image] If you have more 'active' data than the maximum memory limit of your version of SQL Server and your server doesn't have 20GB+ MORE than that limit, then you don't have enough RAM. Having said that, with clones you need some serious low-latency-high-throughput networking for it to be successful if the image files are not local. Does your server have a single 1Gb network card by any chance? Oh, and the storage that the images are on needs to be fast as well. Also, what is your server's storage comprised of? / comments
My laptop has 32GB of RAM. If you have more 'active' data than the maximum memory limit of your version of SQL Server and your server doesn't have 20GB+ MORE than that limit, then you don't have ...
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...
Filtering Not
I filtered out a large database to just do table stuff. Then waited almost 20 minutes while this query ran:
SELECT sm.object_id AS id,
definition AS text,
1 AS colid,
(CASE WHEN OBJECTPROPERTY(so.o...
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 ...
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?
Plus a bunch to this request. / comments
Plus a bunch to this request.
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...