Viewing 15 posts - 181 through 195 (of 464 total)
The snapshot reflects committed data at the time it was created, and it will always reflect that version regardless of any changes made to the source database.
March 11, 2009 at 11:02 am
If they have a backup of the database prior to the data being deleted then they can restore (to another database) and copy the appropriate information across. If they...
March 11, 2009 at 10:56 am
Check your plan for the view query - it should show a clustered index seek on PK_t1, which means that the optimizer determined that the requested data could only exist...
March 11, 2009 at 10:10 am
What are the constraints on t2 and t3? If you only added a constraint to t1 then it's not doing any kind of partitioning as the view will need...
March 11, 2009 at 8:40 am
Going back to the original question, the DMV information (for seeks/scans/lookups at least) may be misleading as they are the most efficient methods based on that specific set of indexes....
March 5, 2009 at 2:49 pm
It won't be any different to your current performance if all of the data is on the same disk; you might see some benefits to splitting it over multiple disks...
March 2, 2009 at 9:25 pm
Well you can always rotate those backups so that each is restored at least once per period (probably best defined by being better than any external requirement for verifying backups...
February 25, 2009 at 11:28 am
Steve Jones - Editor (2/23/2009)
Produce new SKUs? Why not "unlock" features? You have the technology in the XBOX group to unlock things according to some event.
You mean if you successfully...
February 25, 2009 at 11:09 am
I tried this a while ago and ran into problems, I forget the exact nature but I believe it was with Virtual Server rather than SQL. I'd love to...
February 20, 2009 at 8:23 am
Try connecting by providing the ip address with the port as server:port. The port can be obtained from the configuration manager -> protocols -> TCP - I assume this...
February 17, 2009 at 1:51 pm
Is C a default instance or a named instance? If it is named, do you have the SQL Browser service running?
February 17, 2009 at 1:22 pm
As long as they are updates to the database and not the instance, then mirroring will handle them correctly with no effort on your part. You would only need...
February 16, 2009 at 11:53 am
Check the share permissions and the permissions on the underlying folders ... it's possible that they aren't secured.
February 14, 2009 at 9:47 am
You weren't taking log backups by any chance?
February 14, 2009 at 9:37 am
This is available on Microsoft Books 24x7 for those that subscribe. I'm not sure if there are free trials available at the moment. I've read a few chapters...
February 14, 2009 at 9:27 am
Viewing 15 posts - 181 through 195 (of 464 total)