Viewing 15 posts - 9,001 through 9,015 (of 9,244 total)
set up some perfmon counters and profile the developers code. Once you have the trace and permon results you can tie them together and check for problems that way
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 19, 2008 at 9:31 am
from BOL 😉
SERVERPROPERTY ( propertyname )
InstanceName
Name of the instance to which the user is connected.
Returns NULL if the instance name is the default instance, if the input is...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 19, 2008 at 9:26 am
bodhilove (8/18/2008)
I am transfering a 2000 db to 2005. I haven't been given a test environment to work with. I am migrating by...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 19, 2008 at 5:40 am
Redgate gets my vote
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 19, 2008 at 5:22 am
create a domain account and have the agent service runas that account (use sql configuration manager to change the account details). Give this account permissions to whichever remote folders it...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 19, 2008 at 5:21 am
none of my registered servers have the green and white arrow only connected servers
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 18, 2008 at 9:48 am
Scott Duncan (8/11/2008)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 17, 2008 at 2:52 pm
fully review all operations that occur over the weekend before the log backup happens on the monday, something is interrupting your backup chain. Does your index rebuild or maintenance plan...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 17, 2008 at 2:45 pm
are both machines on a network?
if so, put the cd into the drive of the machine where installation was successful and share the disk out. The launch setup from the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 17, 2008 at 2:34 pm
you can also run the SQL setup from cd and that can be used to modify installed instances
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 17, 2008 at 2:30 pm
i would apply some normaliastion to table 2 as suggested first as you'll find yourself ending up with some extra tables which will change the query anyway
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 17, 2008 at 12:32 pm
i always favour migrating to a clean install rather than upgrade existing instances
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 17, 2008 at 12:27 pm
have you tried re running the patch? it'll tell if if its already installed, might be worth re applying if you can
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 16, 2008 at 11:54 am
am i correct in saying you want to remove the extra filegroup and extra log file?
to remove the filegroup all objects in that filegroup would need to be moved to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 15, 2008 at 5:43 am
the 64 bit database backend should be transparent to the apps. SQL is SQL.
However check with the vendor that their app supports sql2005 as a database platform
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 15, 2008 at 5:38 am
Viewing 15 posts - 9,001 through 9,015 (of 9,244 total)