Viewing 15 posts - 3,631 through 3,645 (of 5,394 total)
Check your local server connectivity settings.
You will find it in your start menu: MS SQL Server --> Configuration Tools --> SQL Server Configuration Manager.
Select from the tree view on the...
December 3, 2010 at 1:24 am
amitdotchauhan (12/3/2010)
I need to know when my job was enabled/disabled last time.
You can get the last modified date from msdb.dbo.sysjobs, but it is referred to the whole job, not just...
December 3, 2010 at 1:17 am
Junglee_George (12/2/2010)
Ya, I agree with Michael
You mean you read the whole Thread?
Congrats...
December 2, 2010 at 2:33 am
WayneS (12/1/2010)
You might be able to plan around with generating the query plan without the function calls, and then store that plan for use by these queries?
I don't know how...
December 1, 2010 at 10:23 am
I tried downloading the plans from the URLs in my first post and they contain:
with_repl_predicates.sqlplan --> index scan
without_repl_predicates.sqlplan --> index seek
I already tried running the query without the ISPALUSER...
December 1, 2010 at 9:02 am
WayneS (12/1/2010)
Brandie Tarvin (12/1/2010)
I don't see ISPALUSER in BOL. Can you script that function out for me?
Thank you, Wayne!
It also took me to Paul Ibson's site, that...
December 1, 2010 at 8:43 am
Brandie Tarvin (12/1/2010)
Cannot view XML input using style sheet....
December 1, 2010 at 8:41 am
Brandie Tarvin (12/1/2010)
Gianluca Sartori (12/1/2010)
None of these predicates need to access the tables, so why a scan?
Because you've got them all lumped together??? To my eyes, the code should say:
...
December 1, 2010 at 8:39 am
Yup. It is not my code, anyway. This has been generated by the merge replication setup.
I find lots of (system) views with this filter, named msmerge_whatever.
What I don't understand is...
December 1, 2010 at 8:21 am
Jack Corbett (12/1/2010)
Gianluca Sartori (12/1/2010)
http://www.sqlservercentral.com/Forums/Topic1028498-291-1.aspx
One of our contractors installed an application that relies on merge replication and now that performance is ugly,...
December 1, 2010 at 7:26 am
Heeeelp!!! Is any of you familiar with replication?
http://www.sqlservercentral.com/Forums/Topic1028498-291-1.aspx
One of our contractors installed an application that relies on merge replication and now that performance is ugly, they called me to...
December 1, 2010 at 7:05 am
I'm sure you know that this is a presentation issue, not related to how you store your data.
You can fill a text box with comma separated values, then split on...
November 30, 2010 at 2:24 am
You could take a look at performance data collector:
http://www.simple-talk.com/sql/learn-sql-server/sql-server-2008-performance-data-collector/
November 30, 2010 at 12:58 am
CELKO (11/29/2010)
Why don't you normalize your data instead? That would probably give you tables for Authors (entity), Books (entity), and Authorship (relationship between authors and their books).
Excellent point.
100% agreed.
November 29, 2010 at 10:26 am
You're welcome.
I did nothing, you managed by yourself.
November 29, 2010 at 7:33 am
Viewing 15 posts - 3,631 through 3,645 (of 5,394 total)