Viewing 15 posts - 18,691 through 18,705 (of 19,560 total)
Robert Frasca (12/17/2009)
select *FROM PM.vw_LastSelfPayPaymentActivity --where account_id = 107246
...
The query plan for the slow one says that it is performing a clustered index seek where the cost is 100%. ...
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
December 17, 2009 at 12:52 pm
Thanks for posting back and updating the forum.
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
December 17, 2009 at 12:49 pm
This might get you headed in the right direction:
http://deepakrangarajan.blogspot.com/2007/06/role-change-in-sl-2005-log-shipping.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
December 17, 2009 at 12:35 pm
novice_coder (12/17/2009)
GilaMonster (12/17/2009)
novice_coder (12/17/2009)
We will probably have about 3-5 million records by the end of next year. I guess then I will have to think about partioning.
That's not 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
December 17, 2009 at 12:30 pm
Or this would work too:
;WITH uppity (id, lft, rght, idx)
AS
(
SELECT t.col_01
...
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
December 17, 2009 at 12:22 pm
The second set of insert statements for your FROM_UPD table do not match your table definition.
Could you clarify which set of statements and the requirements?
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
December 17, 2009 at 11:32 am
The method Emily is describing has worked for me in the past.
Using xp_cmdshell, run a dir of the directory. Output the results of that directly to a table.
Once in...
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
December 17, 2009 at 11:16 am
Magi
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
December 17, 2009 at 10:07 am
What are the options you selected for the backup? Did you specify the with move option as the error text indicates?
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
December 16, 2009 at 9:11 pm
As a separate step you could execute xp_cmdshell if this must be done via SQL Server. However, you could do this using an OO language rather than TSQL.
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
December 16, 2009 at 8:59 pm
Paul White (12/16/2009)
Jeff Moden (12/16/2009)
Hmmm... hair color is just about right. Need to add a "No RBAR" tatoo, though. 😛It's the no-RBEAR 😀
ROFLMAO
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
December 16, 2009 at 8:53 pm
I'm sure that could be arranged (tattoo).
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
December 16, 2009 at 8:50 pm
Do you have an internal QA department?
Previous test cases for the application?
Are you able to go through the application given certain scenarios and receive expected results?
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
December 16, 2009 at 6:32 pm
Most excellent suggestion Jeff. The update will need to happen at some point anyway with Text going away in a future release.
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
December 16, 2009 at 5:45 pm
More options include altering the job so only Indexes that meet certain criteria are re-orged or re-indexed (frag % and number of pages are common delimiters). Make those criteria...
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
December 16, 2009 at 5:41 pm
Viewing 15 posts - 18,691 through 18,705 (of 19,560 total)