Viewing 15 posts - 1,186 through 1,200 (of 19,560 total)
SQLisAwE5OmE (7/10/2015)
As long as the mirroring is not removed, the log will not be truncated on the principal side. You need to identify what exactly causing the mirroring 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
July 10, 2015 at 3:19 pm
Grace09 (7/9/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 10, 2015 at 1:44 pm
Grant Fritchey (7/10/2015)
And the first several chapters of my book on query tuning should help.
+1
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 1:38 pm
Sean Lange (7/10/2015)
Alvin Ramard (7/10/2015)
If they must be allowed...
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 1:35 pm
Eirikur Eiriksson (7/10/2015)
Revenant (7/10/2015)
SQLRNNR (7/10/2015)
DonlSimpson (7/10/2015)
Ed Wagner (7/10/2015)
SQLRNNR (7/10/2015)
Ed Wagner (7/10/2015)
Patrick StewartDempsey
Jack
Gene
Hackman
Popeye
Williams
Mork
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 1:14 pm
Luis Cazares (7/10/2015)
That's probably the best way to write it, I'd just add and additional condition for Type IN(3, 4).Why do you want to change it?
In support of this, here...
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 1:11 pm
tchaturvedi (7/10/2015)
Thanks Jason,I need help for this custom code, can you suggest where I should look?
The custom code will depend entirely on your environment and database. You would need 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
July 10, 2015 at 1:05 pm
Then I would opt for the linked server option and custom code to keep the data pumping across to MySQL.
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 12:41 pm
DonlSimpson (7/10/2015)
Ed Wagner (7/10/2015)
SQLRNNR (7/10/2015)
Ed Wagner (7/10/2015)
Patrick StewartDempsey
Jack
Gene
Hackman
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 12:37 pm
Sean Lange (7/10/2015)
DonlSimpson (7/10/2015)
Ed Wagner (7/10/2015)
SQLRNNR (7/10/2015)
Ed Wagner (7/10/2015)
Patrick StewartDempsey
Jack
Gene
Kelly
's Heroes
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 12:36 pm
Is this a 1 time deal or will you need to continuously transfer data from SQL Server to MySQL?
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 12:08 pm
Ed Wagner (7/10/2015)
Patrick Stewart
Dempsey
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 9:34 am
DonlSimpson (7/9/2015)
Ed Wagner (7/8/2015)
DonlSimpson (7/8/2015)
djj (7/8/2015)
Ed Wagner (7/8/2015)
crookj (7/8/2015)
Ed Wagner (7/8/2015)
DonlSimpson (7/7/2015)
Revenant (7/7/2015)
Ed Wagner (7/7/2015)
crookj (7/7/2015)
Ed Wagner (7/7/2015)
djj (7/7/2015)
Ed Wagner (7/7/2015)
TomThomson (7/7/2015)
LeafBranch
Root
Administrator
SA
Disabled
Challenged
Heracles
Hercules
Theseus
Thesaurus
Wordy
Loquacious
Locutus
Picard
What's 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
July 10, 2015 at 9:02 am
Sean Lange (7/10/2015)
Just saw this posted as an explanation to a problem.I'm new to SQL already researched in the Chinese do not think swimming on my mistake
:w00t:
Whu??
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 8:59 am
DonlSimpson (7/6/2015)
crookj (7/6/2015)
Ed Wagner (7/6/2015)
TomThomson (7/5/2015)
SQLRNNR (7/4/2015)
TomThomson (7/4/2015)
Revenant (7/4/2015)
Eirikur Eiriksson (7/4/2015)
SQLRNNR (7/2/2015)
SQL CRUISETom
Thomson
Tired old man
Feathered
Friends
Lifelong
Bro or Sis
Sibling
Unique
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 9, 2015 at 12:59 pm
Viewing 15 posts - 1,186 through 1,200 (of 19,560 total)