Viewing 15 posts - 1,171 through 1,185 (of 19,560 total)
Lynn Pettis (7/13/2015)
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
July 13, 2015 at 10:14 pm
Hugo Kornelis (7/13/2015)
SQLRNNR (7/13/2015)
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
July 13, 2015 at 10:13 pm
Scott Coleman (7/13/2015)
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
July 13, 2015 at 4:16 pm
Eirikur Eiriksson (7/13/2015)
SQLRNNR (7/13/2015)
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
July 13, 2015 at 4:11 pm
TomThomson (7/13/2015)
Eirikur Eiriksson (7/13/2015)
This is a very trivial example, the structure of the XML and the size makes it ill fit for any performance testing.😎
Yes, quite so. 😎
Doing 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
July 13, 2015 at 2:19 pm
Alvin Ramard (7/13/2015)
Steve Jones - SSC Editor (7/13/2015)
Alvin Ramard (7/11/2015)
Hopefully you'll submit it for SQL Saturday in Memphis, hopefully later this year. 🙂
When is Memphis?
We're hoping to have...
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
July 13, 2015 at 2:13 pm
Steve Jones - SSC Editor (7/13/2015)
Brandie Tarvin (7/11/2015)
Usually...
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
July 13, 2015 at 12:39 pm
Mikael Eriksson SE (7/13/2015)
SELECT
col.value('(Title/text())[1]', 'varchar(50)') AS 'Book'
FROM @x.nodes('/root/Books/Book') a(col)
Using text() in the values clause removes one call to a...
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
July 13, 2015 at 11:40 am
GilaMonster (7/13/2015)
SQLRNNR (7/13/2015)
GilaMonster (7/13/2015)
Yes, yes, yes, yes!!!!!!!!Congratulations. You have complied with the requirements prescribed for your degree, and are cordially invited to the graduation ceremony
Congrats on the latest degree. Was...
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
July 13, 2015 at 11:04 am
GilaMonster (7/13/2015)
Yes, yes, yes, yes!!!!!!!!Congratulations. You have complied with the requirements prescribed for your degree, and are cordially invited to the graduation ceremony
Congrats on the latest degree. Was this 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
July 13, 2015 at 9:48 am
TomThomson (7/13/2015)
Jeff Moden (7/13/2015)
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
July 13, 2015 at 8:10 am
Brandie Tarvin (7/11/2015)
Usually the call for speakers is...
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
July 11, 2015 at 1:03 pm
Echoing what has been said. Just use the 2014 version of AW. The database likely won't change much for 2016. It hasn't really changed in that last few releases.
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
July 11, 2015 at 1:01 pm
malcolm.garbett (7/11/2015)
Hi Lowell,Many thanks for rapid response.
Will attempt the connection from SSMS on Monday.
(Here's hoping my predecessors in the job have left the login password in the documentation!)
Hopefully the environment...
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
July 11, 2015 at 9:49 am
Database admin(DBA) (7/10/2015)
shrinking the log files on primary server. As i understand it will impact on performance and it will increase the log file again.
because...
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
July 10, 2015 at 5:10 pm
Viewing 15 posts - 1,171 through 1,185 (of 19,560 total)