Viewing 15 posts - 8,701 through 8,715 (of 9,244 total)
have you changed the account sql service runs under by any chance?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 3, 2008 at 2:58 pm
clustering does not provide load balancing only fail over.
what is it you are looking to do specifically
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 3, 2008 at 1:17 pm
TheSQLGuru (12/3/2008)
2) IIRC Lock pages in memory is only useful for SQL Server Enterprise Edition.
this only applies to sql 64bit, its ok under 32bit
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 3, 2008 at 1:13 pm
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
Viewing 15 posts - 8,701 through 8,715 (of 9,244 total)