Viewing 15 posts - 10,051 through 10,065 (of 19,560 total)
Try this
http://www.newhorizons.com/LocalWeb/WA/Seattle/SQL-2008.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, 2011 at 3:02 pm
3% difference? Getting a 5% annual raise would be fantastic. Haven't seen too many of those. 1% is typically the cap at places I have worked.
The last...
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, 2011 at 2:51 pm
Steve Jones - SSC Editor (5/20/2011)
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, 2011 at 2:44 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, 2011 at 2:24 pm
Try DATALENGTH('My Data ')
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, 2011 at 2:17 pm
Robert Hermsen (5/20/2011)
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, 2011 at 2:09 pm
As an FYI, just having sp_ (as Gus said) does not a system stored proc make. There are more requirements. You can read here for info on 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
May 20, 2011 at 1:47 pm
Take the performance hit - it is really tiny as Gail said. I would then look at implementing a policy for proc naming conventions for new procs. You...
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, 2011 at 1:42 pm
Peter Trast (5/20/2011)
SQLRNNR (5/20/2011)
SQLRNNR (5/20/2011)
bcsims 90437 (5/20/2011)
SQLRNNR (5/20/2011)
PassedCongrats?
yup - more to come
Congrats!
Thanks
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, 2011 at 1:28 pm
Here is a more updated query for the first one listed in this article
select er.session_id, blocking_session_id, wait_type
, wait_time, last_wait_type, database_id
, user_id, er.cpu_time,...
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, 2011 at 1:22 pm
GilaMonster (5/20/2011)
SQLRNNR (5/20/2011)
GilaMonster (5/20/2011)
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, 2011 at 1:14 pm
GilaMonster (5/20/2011)
See http://www.microsoft.com/learning/en/us/certification/cert-sql-server.aspx#tab3
Beat me 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
May 20, 2011 at 1:12 pm
GilaMonster (5/20/2011)
I wrote my 2008 dev exams out of order, ITP...
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, 2011 at 1:11 pm
GilaMonster (5/20/2011)
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, 2011 at 1:06 pm
Craig Farrell (5/20/2011)
SQLRNNR (5/20/2011)
For any interested, my recent exam experience is posted.
*claps*, very nice. You're taking the low courses first though? I figured you'd go straight after 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, 2011 at 12:45 pm
Viewing 15 posts - 10,051 through 10,065 (of 19,560 total)