Viewing 15 posts - 12,211 through 12,225 (of 19,560 total)
Jeff Moden (9/19/2010)
GilaMonster (9/19/2010)
Steve Jones - Editor (9/18/2010)
I think most of us would be hard pressed to impress Gail in an interview :w00t:
Nah. Know what you claim to know 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
September 21, 2010 at 8:54 pm
Julie Breutzmann (9/20/2010)
My favorite session was given by Alexander Kuznetsov on Defensive Programming. He had simple, understandable examples, was well-paced to give the audience time 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
September 21, 2010 at 8:51 pm
K - this has to be posted here.
http://www.sqlservercentral.com/Forums/Topic990456-61-1.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
September 21, 2010 at 8:48 pm
RichardDouglas (9/21/2010)
I'm sure there's some BI peeps here who'll slice & dice the posting stats for the last 30 days and produce odds from that.
don't even need to go that...
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 21, 2010 at 8:47 pm
Grant Fritchey (9/21/2010)
GilaMonster (9/21/2010)
dbowlin (9/21/2010)
I will probably go with one of the editors, but it could be anyone.....even me!
One of the editors? The only editor here is Steve. The rest...
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 21, 2010 at 8:45 pm
Steve Jones - Editor (9/21/2010)
Best bets are Gail, Jeff, or me. Anyone want to take us or the field?
I will take the field. Remember, the field has more points...
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 21, 2010 at 8:44 pm
Tune a view like you would tune a query.
Depending on the circumstance, your view may be a candidate for a clustered index on the view.
I only use views when necessary...
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 21, 2010 at 8:42 pm
We would script out the settings and then submit them to source control. When a failover occurs, then run the scripts as a step in the DR plan.
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 21, 2010 at 8:38 pm
You can name the datasource the same as the database. The datasource can be shared amongst reports. if you document the naming convention, then there should be no...
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 21, 2010 at 8:37 pm
Do it one instance at a time.
Stop the instance dependencies from cluster management.
Change the password in services.msc
start the instance from cluster management.
Repeat the process for the other instance.
I recommend stopping...
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 21, 2010 at 8:34 pm
what other fields are in these tables (anything that would create BLOBs)?
Have you checked the indexing and fragmentation levels?
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 21, 2010 at 8:29 pm
Have you tested altering a proc after granting create? IIRC, create also grants the ability to alter.
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 21, 2010 at 8:26 pm
iqtedar (9/21/2010)
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 21, 2010 at 8:24 pm
Duplicate post
Post answers here - http://www.sqlservercentral.com/Forums/Topic990823-146-1.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
September 21, 2010 at 8:21 pm
A registry cleaner should be able to clean those out.
Did you run the uninstall from Add/Remove programs or some other means?
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 21, 2010 at 8:20 pm
Viewing 15 posts - 12,211 through 12,225 (of 19,560 total)