Viewing 15 posts - 886 through 900 (of 2,612 total)
SQL Server licenses are backwards compatible to all supported versions. If you purchase a SQL 2008 license, you can install SQL 2005 under that license.
Unsupported versions (say SQL 7...
July 28, 2008 at 12:42 pm
The query plan is read from right to left.
So, it starts with something a bit strange - the Comm_Link table. This is weird because you are LEFT OUTER JOINing...
July 28, 2008 at 12:30 pm
Getting the same execution plan and vastly different performance is unusual.
Assuming the hardware in each environment is similar:
- Make sure statistics are updated on the reporting database.
- Verify your indexes...
July 28, 2008 at 5:52 am
So you have 4 servers? 2 of them are clustered for the production environment, and two are clustered for the reporting environment?
I suppose that does not really matter. ...
July 28, 2008 at 4:54 am
Regardless of checking "Save Password" in connection dialogs, SSIS does not save passwords. You have to use package configurations or set the password at execution time by modifying the...
July 28, 2008 at 4:49 am
The error is coming from the driver being used to connect to your Intersystems database. I am not familiar with Intersystems, but if you are using some kind of...
July 28, 2008 at 4:44 am
You can't.
Buy the Enterprise Edition license.
July 28, 2008 at 4:40 am
It would seem as reasonable to assume the problem is VMWare as to assume the problem is the processor settings.
Are you just getting data returned in a different order?
I am...
July 28, 2008 at 4:37 am
Look up CREATE PROCEDURE in books online and look at the OUTPUT Parameters section.
July 25, 2008 at 12:51 pm
I would not do anything with the logs by default, but it is a consideration.
As far as if it makes a difference on the SAN - make sure these are...
July 25, 2008 at 10:47 am
Sorry to hear you say that, I find it great.
It is way beyond DTS, and considering it comes with the SQL Server license it's quite a bargain compared to other...
July 25, 2008 at 10:39 am
Create a user variable. Make it an expression variable and make the expression the system variable you want to see. Include this variable in your read-only variable list.
July 25, 2008 at 10:08 am
That's a reasonable start. I usually put the OS and SQL Install on the same drive. Depending on the SQL logs (not the log files) you may want...
July 25, 2008 at 10:04 am
Pull down some components from here:
At least you get the source code. Some of it is well-documented. It's a good start.
July 25, 2008 at 8:00 am
Viewing 15 posts - 886 through 900 (of 2,612 total)