Viewing 15 posts - 12,586 through 12,600 (of 19,560 total)
Steve Jones - Editor (9/3/2010)
Alvin Ramard (9/3/2010)
The next 90 minutes are gonna go...
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
September 3, 2010 at 3:35 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
September 3, 2010 at 11:33 am
Paul White NZ (9/3/2010)
Steve Jones - Editor (9/3/2010)
Be safe, hope no major damage.All good here - it was centred on the other island 300km from me. Earthquake map:
http://www.geonet.org.nz/earthquake/quakes/3366146g-maps.html
The quake...
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
September 3, 2010 at 11:20 am
Paul White NZ (9/3/2010)
7.4 magnitude quake hits New Zealand (Christchurch, Sth Island) http://on.cnn.com/d3tTtl
Wow - good no serious damage or tsunami - yet.
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
September 3, 2010 at 11:11 am
Just shrinkfile and wait - but don't remove all free space.
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
September 3, 2010 at 11:09 am
I run active/active as well - same principle. The patch will detect both instances and prompt you to update both instances in the active/active cluster.
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
September 3, 2010 at 11:04 am
MSDE is a scaled back version of SQL server that is Free. Do not confuse it with Enterprise Edition or Personal Edition.
If you are just installing MSDE - 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
September 3, 2010 at 11:03 am
I prefer to do those in series. Typically better performance - from observation and not hard metrics.
I don't have a script to auto-generate the shrink scripts though.
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
September 3, 2010 at 10:59 am
It's pretty straight forward.
Here's a link that should help.
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
September 3, 2010 at 10:57 am
I would rely on the Serverproperty function. It will return the various editions (standard, enterprise, eval)
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
September 3, 2010 at 10:55 am
Jack Corbett (9/3/2010)
Gianluca Sartori (9/3/2010)
Steve Jones - Editor (9/3/2010)
Relax, ultimately you want to be professional, but it's a job. Give you opinion, document, go...
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
September 3, 2010 at 9:52 am
Alvin Ramard (9/3/2010)
CirquedeSQLeil (9/3/2010)
Any that are interested, my UG is having another livemeeting on Sep 9, 2010 @ 6PM PST.https://www.livemeeting.com/cc/UserGroups/join?id=C7N873&role=attend
Meeting ID is C7N873 (just in case you need it).
Thanks Jason....
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
September 3, 2010 at 9:49 am
There's a place for these devices and I think they could be highly useful - despite the cost.
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
September 3, 2010 at 8:46 am
crookj (9/3/2010)
CirquedeSQLeil (9/3/2010)
crookj (9/3/2010)
Colorado Springs Labor Day Balloon Festival!Good times!
Joe
Somebody's gettin' high.;-)
That and - Just a drop in the water.
Love it when the do dips into the lake.
Joe
I would too...
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
September 3, 2010 at 8:44 am
crookj (9/3/2010)
Colorado Springs Labor Day Balloon Festival!Good times!
Joe
Somebody's gettin' high.;-)
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
September 3, 2010 at 8:34 am
Viewing 15 posts - 12,586 through 12,600 (of 19,560 total)