Viewing 15 posts - 7,861 through 7,875 (of 19,560 total)
http://www.microsoft.com/download/en/details.aspx?id=26727
Precautions - backup system and user databases first. Review the fix list. Get a maintenance window to do it. Apply to Dev and QA first.
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
November 14, 2011 at 8:31 pm
Here is a tutorial on how to do it - basic level.
http://www.stylusstudio.com/sqlxml_tutorial.html
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
November 14, 2011 at 8:16 pm
What should the output look like?
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
November 14, 2011 at 8:11 pm
I like to have the Database Owner set as SA.
As for the access problem, is your server setup in mixed mode authentication?
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
November 14, 2011 at 4:39 pm
LutzM (11/14/2011)
SQLRNNR (11/14/2011)
Steve Jones - SSC Editor (11/14/2011)
Gianluca Sartori (11/14/2011)
Congrats Jason for winning T-SQL challenge 63!+1, congrats
Danke
Herzlichen Glückwunsch! 😛
When did they start to allow solutions other than a single query?
(It's...
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
November 14, 2011 at 1:06 pm
Jim Murphy (11/14/2011)
SQLRNNR (11/14/2011)
Steve Jones - SSC Editor (11/14/2011)
Gianluca Sartori (11/14/2011)
Congrats Jason for winning T-SQL challenge 63!+1, congrats
Danke
Yep. You rock man.
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
November 14, 2011 at 12:12 pm
Brandie Tarvin (11/14/2011)
I get that. I do.
It just seems lately that there are a lot of people on this forum (including long-time posters like us) have been jumping on 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
November 14, 2011 at 11:32 am
Brandie Tarvin (11/14/2011)
WOW......just... WOW.
EDIT: In regards to all the MERGE connect bug issues, that is.
Ah, thanks for clarifying.
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
November 14, 2011 at 11:28 am
Steve Jones - SSC Editor (11/14/2011)
Gianluca Sartori (11/14/2011)
Congrats Jason for winning T-SQL challenge 63!+1, congrats
Danke
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
November 14, 2011 at 10:52 am
Steve Jones - SSC Editor (11/14/2011)
Done,with travel for the year. 14 events, I think 20 presentations, a long year.
phew
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
November 14, 2011 at 9:03 am
Then as Cadavre did, use the developer needs and create a test case showing select * v. select explicit columns. This has been the most effective method for myself...
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
November 14, 2011 at 9:03 am
Run it down to execution plans and perf test for the developer. Ensure that developer truly needs every single column, generate tests and show the developer why it 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
November 14, 2011 at 8:19 am
Ninja's_RGR'us (11/14/2011)
SQLRNNR (11/14/2011)
Ninja's_RGR'us (11/14/2011)
SQLRNNR (11/14/2011)
Ninja's_RGR'us (11/14/2011)
SQLRNNR (11/14/2011)
Ninja's_RGR'us (11/14/2011)
SQLRNNR (11/13/2011)
Ninja's_RGR'us (10/19/2011)
I know I did. Just not sure if it was this exact version :-D.
So, i checked my email and 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
November 14, 2011 at 8:14 am
Ninja's_RGR'us (11/14/2011)
SQLRNNR (11/14/2011)
Ninja's_RGR'us (11/14/2011)
crookj (11/14/2011)
Ninja's_RGR'us (11/11/2011)
SQLRNNR (11/11/2011)
Ninja's_RGR'us (11/11/2011)
Confusing with Britney?Well they did kiss. I could see how that mistake could be made.
Good point! 😀
Adds a whole new meaning 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
November 14, 2011 at 8:13 am
Why are you trying to load just 1 record?
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
November 14, 2011 at 8:13 am
Viewing 15 posts - 7,861 through 7,875 (of 19,560 total)