Viewing 15 posts - 46 through 60 (of 77 total)
What's the query look like that you are running? A table with a few hundred thousand records shouldn't take long to run, and shouldn't need to be partitioned. ...
July 18, 2010 at 11:26 pm
Merge replication has conflict which should put records into the conflict resolution panel (if I'm remembering SQL 2005 correctly). Peer to Peer replication doesn't have any sort of conflict...
July 18, 2010 at 11:23 pm
SQL Server 2008 R2 was announced as the official product name a while back. It has been in public beta for at least a month or two now.
December 23, 2009 at 1:02 pm
Using xp_cmdshell pretty much isn't ever a good idea, as for security reasons xp_cmdshell should be disabled.
December 14, 2009 at 1:15 am
Sounds like the account which is running the SQL Server is either a domain account, or doesn't have access to the network share.
In either case the account needs to be...
December 12, 2009 at 6:33 pm
Running a registry cleanup tool against a server, especially a production server is a bad idea. I've been doing this for a decade and have never found the need...
November 19, 2009 at 12:25 pm
No, when SQL installs and does the SKUUPGRADE it will leave all the databases alone. After the installer is done everything should look just as it did before, just...
October 16, 2009 at 2:01 pm
Yes this is possible. You would need to buy the new license, then do a SKUUPGRADE install. Basically you launch the installer off of the Enterprise Edition CD/DVD...
October 15, 2009 at 9:55 pm
If Microsoft is planning a 2010 release nothing would be known until closer to then. You could probably called SQL 2008 R2 (currently in beta) the 2010 release as...
September 10, 2009 at 1:58 pm
That upgrade path should work. Are you trying to go from 2005 Enterprise Eval to 2008 Standard by any chance?
September 2, 2009 at 1:50 pm
I would say that Junior DBA, DBA, and Senior DBA titles have there purpose.
The differences come with years of experience, knowledge of the product. With as large a product...
August 25, 2009 at 3:11 pm
SQL 2000 will take TEXT and NTEXT as input parameters for stored procedures so you can pass in values over 4000 characters.
August 25, 2009 at 12:53 pm
By any chance is the new server case sensitive, and the old server can insensitive?
August 4, 2009 at 1:13 pm
In the script that you ran, are the database names listed correctly?
August 3, 2009 at 2:50 pm
We killed the idea of shipping database backups early on in this thread as shipping diffs or transaction logs requires that the database servers both be the same version.
August 3, 2009 at 12:20 pm
Viewing 15 posts - 46 through 60 (of 77 total)