[dba-SQLServer] SP4

I'm testing sp4 on my dev box right now, so far it seems to peform right on, 
but some of the features it brings such as improved #temp table handling I 
have not noticed mainly because my programming practice, which is, I 
explicitly create the #temp table first via Create Table #temp, and then 
populated rather than the lazy Select * into #temp From table

it does have updated XML support which will come in handy in my new project, 
but I haven't gotten there yet. I think you want to patch SP4 first then 
follow up with the analysis pak

but should you upgrade?.. 
list of bug fixes for sp4 http://support.microsoft.com/kb/888799/
list of bug fixes for sp4 (analysist pak) 
http://support.microsoft.com/kb/888800/


On 5/13/05, Charlotte Foust <cfoust at infostatsystems.com> wrote:
> 
> OK, I admit it. I am NOT a SQL Server person, even though I have to
> develop front ends against it. Can anyone explain SP4 and when, why and
> how it should be applied? The baseline security gizmo says I need it on
> my laptop. But I can't figure out how to apply it. I downloaded the
> several files, but I get stuff about sa not having a secure password.
> It does, it does, but I use Windows authentication! When I try to apply
> the analysis services version, I get un unenlightening error message and
> it aborts. Do I need this for anything? HELP!!
> 
> Charlotte Foust
> Infostat Systems, Inc.
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
> 


-- 
-Francisco
http://pcthis.blogspot.com |PC news with out the jargon!
http://sqlthis.blogspot.com | Tsql and More...