Viewing 15 posts - 6,586 through 6,600 (of 19,560 total)
I prefer SQL Compare as well.
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
March 28, 2012 at 5:15 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
March 28, 2012 at 5:11 pm
Good - glad you posted back that you found the answer.
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
March 28, 2012 at 4:51 pm
See if this answers your questions.
http://msdn.microsoft.com/en-us/library/ms144275(v=sql.100).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
March 28, 2012 at 4:49 pm
You should be ok with that.
http://msdn.microsoft.com/en-us/library/ms143241(v=sql.110).aspx
The referenced article describes a scenario of a distributor on 2008, transactional replication between a 2000 and 2005 box.
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
March 28, 2012 at 4:43 pm
Ask the vendor if they have a rollback script.
Sometimes they do.
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
March 28, 2012 at 3:55 pm
Kill the connections still using msdb.
But rather than that - I would likely just drop the new objects and move on.
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
March 28, 2012 at 3:32 pm
There is logging with Michelle's too. I like to use hers because it works very well for the Index Maintenance.
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
March 28, 2012 at 3:27 pm
That's good to hear
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
March 28, 2012 at 3:25 pm
That index is not covering for your query. And since an emailaddress is more than just the two characters (or three since you are probably searching for com, org,...
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
March 28, 2012 at 3:02 pm
Change your query
select fk_fha_number,max(date_final_settlement) max_settlement_date
from mf_fha_claim
where date_final_settlement is not null
and fk_fha_number in (06435113,
07135575,
09235585,
09235599,
06235384,
10135218,
09235399,
08544032,
08435265,
08535312)
group by fk_fha_number--,date_final_settlement
order by fk_fha_number
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
March 28, 2012 at 2:50 pm
JeffRush (3/28/2012)
No one is likely (hopefully) going to just answer your homework questions...
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
March 28, 2012 at 2:44 pm
The second query can do a scan or seek (most probably a scan) depending on indexes.
What are the index definitions you have in place?
What is the selectability of the value...
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
March 28, 2012 at 2:40 pm
Brandie Tarvin (3/28/2012)
L' Eomot Inversé (3/28/2012)
GSquared (3/28/2012)
I can just see it now. We're going to end up with a Reality Show on The Thread: Waiting for 40k
Do you think...
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
March 28, 2012 at 2:29 pm
David Burrows (3/28/2012)
SQLRNNR (3/27/2012)
When did we start doing milestones for the 5k posts? I thought it was 10k.
A milestone is a milestone is a milestone, don't be so damn...
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
March 28, 2012 at 2:27 pm
Viewing 15 posts - 6,586 through 6,600 (of 19,560 total)