Viewing 15 posts - 9,091 through 9,105 (of 9,248 total)
in SSIS create a new project. Drag a new "Data flow task" from the Control flow items. Edit the new "Data flow task" and in the Toolbox under "Data Flow...
July 29, 2008 at 7:03 am
filegroups offer managability but more over performance. They are primarily designed to be spread across disks\arrays and unless doing so are not going to be of any benefit to be...
July 29, 2008 at 6:59 am
i personally wouldnt boot from the SAN, i would have local disks for the OS, stick everything else on the SAN. You have many options available just be sure to...
July 29, 2008 at 2:05 am
Hi Andy
this was exactly the same line of thinking i had. Very informative. I think you're right no-one ever changes the default for stats during the create index
July 29, 2008 at 1:58 am
yes very important make sure you keep a copy of the enterprise system databases incase you need to bring them back online otherwise you'll need the install cd to repair...
July 28, 2008 at 1:11 pm
Jeffrey Williams (7/28/2008)
I am going to side with both Gail and Perry here
not to mention the tone with which the words echoed to whom i would class as a well...
July 28, 2008 at 1:04 pm
gunna48 (7/28/2008)
sp_dropserver '[YourOldDatabaseName]'--Present Server name goes here
go
sp_addserver '[YourNewDatabaseName]','local'--New Server name goes here ...
July 28, 2008 at 12:58 pm
jim.powers (7/28/2008)
If that switch is not already there, it does need to be added.
on the very rare odd occasion and normally for older processor architecture. 99% of the time the...
July 28, 2008 at 12:53 pm
george sibbald (7/28/2008)
what Perry and Terry (great name for a double act)
not a s good as Kevin and Perry,, yes mrs patterson 😀
July 28, 2008 at 7:02 am
are we talking 1 instance of sql server??
what are min and max memory set to on instance properties?
July 28, 2008 at 6:34 am
on SQL2005 queries that try to update the system catalogs will be rejected anyway 😉
July 28, 2008 at 6:32 am
Milton Gonsalves (7/25/2008)
So only Enabling /PAE should also help.., right?
if your using win 2003 enterprise it should address all the RAM straight off without editing the boot.ini
July 28, 2008 at 6:30 am
alimcitp (7/28/2008)
July 28, 2008 at 6:21 am
ensure you configure the "lock pages in memory" local security policy for the account SQL runs under. Generally its not recommended to use the /3GB switch for machines with 16GB...
July 25, 2008 at 10:01 am
just found the MS kb article, it seems 32 bit SQL2005 std can lock pages its just the 64bit that is an issue
July 24, 2008 at 9:31 am
Viewing 15 posts - 9,091 through 9,105 (of 9,248 total)