Viewing 15 posts - 15,151 through 15,165 (of 19,560 total)
I agree on the salary cap. I would also like to see revenue sharing implemented in baseball like in the NFL. I think the revenue sharing has made...
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
April 7, 2010 at 11:40 am
RBarryYoung (4/7/2010)
CirquedeSQLeil (4/7/2010)
the tables are stored in the protected hidden resource db.
Well, some of it is, but a lot of it is not even there. Rather, much of 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
April 7, 2010 at 11:38 am
boris_shvartsman (4/7/2010)
I agree 100%.. no doubt, but I worry that those "dead" tables in the sysobjects are somehow pulling the performance... reading your link..
Fair enough.
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
April 7, 2010 at 11:34 am
Carla,
You're welcome - it was really Paul's script. I just added a little mod to 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
April 7, 2010 at 11:34 am
In your dev environment, will you be merging from the dev server to another dev server? Or are you trying to merge with another database on the same dev...
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
April 7, 2010 at 11:32 am
GSquared (4/7/2010)
Alvin Ramard (4/6/2010)
GSquared (4/6/2010)
Steve Jones - Editor (4/6/2010)
Those are good suggestions. We are getting some people up there, so I ought to add more.
Since I'm closing in on SSChampion,...
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
April 7, 2010 at 11:27 am
boris_shvartsman (4/7/2010)
thanks a million for your...
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
April 7, 2010 at 11:26 am
the tables are stored in the protected hidden resource db.
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
April 7, 2010 at 11:19 am
It is possible. If you are doing that full time you may have enough down for the exam at that point.
My recommendation would be to try as many scenarios...
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
April 7, 2010 at 11:17 am
vkkrishn,
Do you have any of the information / answers for the questions asked?
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
April 7, 2010 at 11:01 am
RBarryYoung (4/7/2010)
boris_shvartsman (4/6/2010)
... I need to only select the system tables and run update stats and reindex on them. ...
OK, I'll be the dumb non-DBA here and ask the question:...
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
April 7, 2010 at 10:59 am
You can try looking at the default trace file.
Otherwise, you should set up some sort of auditing to determine that information.
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
April 7, 2010 at 10:57 am
You could consolidate it. You would need to take your time with it and plan.
I don't see there being any real hindrance other than the additional licensing and hardware...
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
April 7, 2010 at 10:55 am
Paul White NZ (4/7/2010)
Paul White NZ (4/4/2010)
There are answers to most connectivity problems on the SQL Server Protocol Team's blog:http://blogs.msdn.com/sql_protocols/archive/2005/09/28/474698.aspx
http://blogs.msdn.com/sql_protocols/archive/2005/12/22/506607.aspx
http://blogs.msdn.com/sql_protocols/archive/2005/10/29/486861.aspx
...etc.
From earlier. 🙂
Not the same link exactly, but the same...
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
April 7, 2010 at 10:52 am
The D should also be marked active.
Were you also unable to see the drive during SQL 2008 setup?
Somewhat perplexing if you can write to the drive outside of SQL Server....
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
April 7, 2010 at 10:50 am
Viewing 15 posts - 15,151 through 15,165 (of 19,560 total)