Viewing 15 posts - 28,681 through 28,695 (of 39,771 total)
You'd have to read about performance tuning. Seeks are good, scans aren't. There are various performance tuning books out there, Ben-Gans is the best I think that can help...
May 6, 2008 at 10:11 am
I'mn not sure you can do this. There isn't a way to necessarily determine which table a column is coming from. Unless you have a way of determining which value...
May 6, 2008 at 10:10 am
I heard that in 2008 there will be rolling upgrades, meaning you patch the inactive node, failover, patch/upgrade the formerly active/now inactive node.
W2K8 is much different, but the rolling...
May 6, 2008 at 9:56 am
I believe they are triggered with an update to any row for that column. your code needs to handle which rows get inserted / updated in another table.
May 6, 2008 at 9:53 am
Posted a couple questions at MS. Are you keeping Windows the same? Is it 2003 or 2008?
May 6, 2008 at 8:37 am
How are you trying to connect?
The SAC is removed in 2008 and you need to sp_configured or use SSMS to make changes. If you are on the server, can you...
May 6, 2008 at 8:18 am
My guess is that 2008 will be very similar. The changes in 2008 are mostly add-ons from what I can tell and most of the same functionality in the core...
May 6, 2008 at 8:18 am
Encrypting everything in 2005 will cause issues. You can't index well. Think about whether you really need to index all the information or even most of it. If there's any...
May 5, 2008 at 4:55 pm
I don't think there's a good overall tool.
No tool can discover all instances. There are too many ways these can be setup and configured. The best is a tool...
May 5, 2008 at 4:52 pm
I'd look at the SPN and be sure you don't have timing issues (system time differences) between the two domain servers and the SQL server host.
May 5, 2008 at 4:50 pm
What is getting updated? Are these columns not reachable from the web? Could people be entering bad data?
Are you only using stored procedures with ASP and the stored procedure object?
You...
May 5, 2008 at 4:47 pm
Service account an admin? I think that was an issue in the past.
May 5, 2008 at 4:46 pm
Please don't cross post. Answered here: http://www.sqlservercentral.com/Forums/Topic495330-338-1.aspx
May 5, 2008 at 4:44 pm
This is an Enterprise only feature for 2008. That could change in the future.
Restore times should be much quicker, similar to backup time savings. Less reading from disk (slow) and...
May 5, 2008 at 10:36 am
Viewing 15 posts - 28,681 through 28,695 (of 39,771 total)