Viewing 15 posts - 8,701 through 8,715 (of 9,241 total)
for corporate there will be an anuual licence cost, it wont be as high as the intial purchase but still needs to be paid.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 3, 2008 at 1:08 pm
RAID 5 will only tolerate 1 disk failure at any time even if there are 3 spares. RAID 50 does allow multiple failures AFAIK but RAID 10 is a better...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 3, 2008 at 12:20 pm
smunson (12/3/2008)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 3, 2008 at 6:58 am
Ahmad Osama (9/22/2008)
work on Team foundation server and VSS....Does these application hav any future
recommend they bin VSS and get Subversion instead 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 2, 2008 at 4:36 pm
it sounds very much like there are foreign keys and they are missing column information.
i would query the system views and find out which foreign keys are affected. Drop them...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 2, 2008 at 3:24 pm
RAID 10 if you can RAID 5 if you want to keep it simple, RAID 0+1 involves mirroring over a striped set and is not as tolerant as RAID 10
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 2, 2008 at 3:12 pm
the 80 folder contains numerous backward compatability components
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 2, 2008 at 5:55 am
to get a list of database and filenames use
select name, fileid, filename from sys.sysaltfiles
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 1, 2008 at 6:27 am
you will need to install either SQL2005 express or developer. Enterprise and standard are for server systems only
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 30, 2008 at 2:30 pm
install a new instance with the correct collation and transfer any objects across, then remove the original instance. Pay close attention to the installer and select the right collation, check...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 30, 2008 at 2:19 pm
GilaMonster (11/30/2008)
You've left a lot of important information out.
you may or may not need to configure the /3GB switch in the boot.ini (i assume you meant this file and not...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 30, 2008 at 2:15 pm
Simon
not so much bad indexing, but yes they are related. The fill factor is defined as a default at server level which is usually 0 and means 100%. When rebuilding...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 27, 2008 at 8:05 am
what is your MDAC version
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 26, 2008 at 5:46 am
to make the trace easier to read\sort dump the output to a sql table
SELECT * INTO tablename
FROM ::fn_trace_gettable('d:\path to trace\tracename.trc', default)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 25, 2008 at 3:29 pm
the compound key has to be unique, you can have the same value in single columns as long as the combined values are unique
col1 ...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 24, 2008 at 3:25 pm
Viewing 15 posts - 8,701 through 8,715 (of 9,241 total)