Viewing 15 posts - 8,491 through 8,505 (of 9,241 total)
we're not using SQL 2008 but SQL2005. Have you checked the ESRI website for details of ArcGIS 9.2 and SQL2008
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 26, 2009 at 11:05 am
GSquared (1/22/2009)
how often in a DBA's career does it really matter that pages are 8k in size,
database sizing springs to mind, something a DBA may well be required to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 22, 2009 at 3:48 pm
sridevi_kj (10/21/2008)
I added the SMO reference in .net 2.0 in one machine in which sql server 2005 is installed. I used the SMO...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 22, 2009 at 6:14 am
regular log backups would stop the transaction log getting huge if in full recovery mode. They also provide point in time restore capability. If all you need is a backup...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 22, 2009 at 6:07 am
regular log backups would stop the transaction log getting huge if in full recovery mode. They also provide point in time restore capability. If all you need is a backup...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 22, 2009 at 6:07 am
you cannot shrink past the active portion of the log. if the log has an active portion near the end of the file it will not shrink beyond that no...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 21, 2009 at 3:39 pm
george sibbald (1/21/2009)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 21, 2009 at 1:44 pm
Colin, i have never encountered changing the max degree of parallelism either.
george sibbald (1/21/2009)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 21, 2009 at 10:44 am
we use SQL2005 std edition! What version ArcGIS are you using?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 20, 2009 at 5:19 pm
that would be the path i would recommend 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 20, 2009 at 2:09 am
yeah i already checked with him. He wasnt trying to upgrade the SBS instances just one of the 2 new instances
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 19, 2009 at 3:28 pm
Matt, it would seem he has a mixture of sql2000 instances, 2 of the instances are the MSDE which SBS installs. The other 2 seem to be developer edition
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 19, 2009 at 2:35 pm
malcolmwatt (1/18/2009)
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) ...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 19, 2009 at 10:07 am
how did you get on?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 18, 2009 at 11:22 am
he was probably looking for something along the lines of
sql server stores data on disk in pages which are 8Kb in size. 8 pages make up one extent and these...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 18, 2009 at 10:51 am
Viewing 15 posts - 8,491 through 8,505 (of 9,241 total)