Viewing 15 posts - 1,141 through 1,155 (of 2,496 total)
My experience is that if you have a transaction table that is significantly smaller than the master table and the master table is into the many millions of rows, then...
November 11, 2009 at 4:04 am
I agree that you absolutely must test this upgrade. If you just run it in production without any previous testing you should expect that your applications will not work...
November 9, 2009 at 5:58 am
It is not in itself wrong to have different fix levels for different components of SQL Server. If a new CU is issued and it contains no fixes for...
November 9, 2009 at 5:49 am
As Gift Peddie says, this is a known UI bug that should not occur more than once on a given machine. I have not done a SQL 2008 install...
November 9, 2009 at 5:42 am
My experience is that most standard interview questions, no matter what they are 'designed' to do, just arbitarily eliminate x% of applicants using a reason that could stand up to...
November 9, 2009 at 5:39 am
As I said in a previous post, the business expect IT to provide the most cost-effective service, and is not interested in our turf wars. Backup technology is moving...
November 6, 2009 at 2:40 am
I agree the right way to do this is to make SQL Server dependant on the SAN connectivity service. But if the SAN service reports it is started before...
November 4, 2009 at 4:25 am
You will have to build the two environments and try out your queries.
If you are going to make a purchasing decision as a result of the tests you should make...
November 4, 2009 at 4:12 am
If you want someone without sysadmin rights to use xp_cmdshell in SQL 2000, you need to set up a proxy account.
Books Online (BOL) gives good details on how...
November 3, 2009 at 2:37 am
Running the SP install with parameters /quiet and /allinstances should update all the SQL 2005 instances, plus the tools, on your server.
The same parameters apply for a Cumulative Update installation....
October 30, 2009 at 5:17 am
Security has changed in Windows 2008 and above. The problem you are seeing is not caused by SQL Server, but be Windows 2008.
You used to be able to add...
October 30, 2009 at 5:00 am
The post mentioning data type differences is right. This is a documented feature of SQL 2005 and above.
The best way to find if this affects you is to look...
October 29, 2009 at 5:01 am
What is in the install logs? These are normally found in C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Logs
You get one folder in \Logs for every time you run SETUP, so look...
October 28, 2009 at 5:13 am
I think you need to talk to your AD and Security people. You will need to use Kerberos security for SQL Server and enable an AD Trust relationship between...
October 28, 2009 at 4:36 am
On a 32-bit server Task Manager does not know about memory above the 4GB line.
If you enable AWE you will have to look in the SQL Errorlog file...
October 28, 2009 at 4:25 am
Viewing 15 posts - 1,141 through 1,155 (of 2,496 total)