Viewing 15 posts - 13,861 through 13,875 (of 19,560 total)
Pretty straight forward.
Backup user and system databases.
Run the SP executable
Test your apps.
You should apply the sp in dev or qa long before trying to update a production system as well.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 20, 2010 at 7:40 pm
Backup your user database, and system databases.
Run the executable
Test your applications.
You should be doing this in an environment such as dev or QA prior to trying to update production.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 20, 2010 at 6:21 pm
SP4 for the OS or for SQL 2005?
According to the SQL Server site at Microsoft, only SP3 is available.
http://msdn.microsoft.com/en-us/sqlserver/bb671254.aspx
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 20, 2010 at 6:19 pm
logixmike (5/18/2010)
Anybody having good experience with Idera?Thx.
Just in case it changes again - this it the topic to which I recently replied.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 20, 2010 at 6:02 pm
It seems that the question has changed topics after the thread began.
I have used Idera in the past. It is ok but we saw some bugs with it and...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 20, 2010 at 6:01 pm
I think I would be fine with it even now if they came back and asked permission. The problem is they are pulling the feed without permission from the...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 20, 2010 at 5:58 pm
Interesting, I get nothing but Clustered Index scans for all three select statements.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 20, 2010 at 5:45 pm
Leo.Miller (5/20/2010)
Brad is normally very good
Agreed. It is good to verify what one says because people do occasionally make mistakes.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 20, 2010 at 5:06 pm
Jeff Moden (5/20/2010)
CirquedeSQLeil (5/20/2010)
GilaMonster (5/20/2010)
CirquedeSQLeil (5/20/2010)
I was searching for the SQLSat Utah information and came across this blog. I am uncertain if it...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 20, 2010 at 4:23 pm
GilaMonster (5/20/2010)
CirquedeSQLeil (5/20/2010)
I was searching for the SQLSat Utah information and came across this blog. I am uncertain if it is RSS'd or...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 20, 2010 at 3:57 pm
Jack Corbett (5/20/2010)
CirquedeSQLeil (5/20/2010)
...
Looks like they are grabbing the RSS from SSC. On the right side where they list contributors they list SSC and the other sites that they...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 20, 2010 at 3:04 pm
You're welcome.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 20, 2010 at 2:43 pm
Looking for insight / opinions on this.
I was searching for the SQLSat Utah information and came across this blog. I am uncertain if it is RSS'd or if they...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 20, 2010 at 2:29 pm
sqlbi.rahul (5/20/2010)
try thisSELECT REPLACE(SUSER_NAME(), HOST_NAME() , '\','') as userId
i hope it works..
i have mine setup as
SELECT REPLACE(SUSER_NAME(), 'Dom-cs\','') as userId
That will not work due to too many parameters passed to...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 20, 2010 at 2:15 pm
Digs (5/20/2010)
So what does one do to manage a database size.Back ups sure..
Doesnt a SQL server need maintenance after records have been deleted ?
The maintenance to perform after deleting records...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 20, 2010 at 12:19 pm
Viewing 15 posts - 13,861 through 13,875 (of 19,560 total)