Viewing 15 posts - 14,176 through 14,190 (of 19,560 total)
I would recommend not to use sys.sysindexes since it is a soon to be deprecated view. It will work currently but may not be in the next release of...
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
May 6, 2010 at 5:17 pm
NJ-DBA (5/6/2010)
I will bet $$ that this server is running diskkeeper.
It's also possible that there is some other form of disk defragmenter on the system that runs a scheduled defrag.
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
May 6, 2010 at 5:09 pm
Trey Staker (5/6/2010)
Trey Staker (5/6/2010)
CirquedeSQLeil (5/6/2010)
Lynn Pettis (5/6/2010)
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
May 6, 2010 at 5:06 pm
Paul White NZ (5/6/2010)
Grant Fritchey (5/6/2010)
And by the way, just passed 8000 points. #10 to do so.Now I'll let Jason & Paul pass me.
Jason's gone through. I'm more...
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
May 6, 2010 at 5:05 pm
Lynn Pettis (5/6/2010)
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
May 6, 2010 at 3:51 pm
Lynn Pettis (5/6/2010)
CirquedeSQLeil (5/6/2010)
Lynn Pettis (5/6/2010)
crookj (5/6/2010)
sing4you (5/6/2010)
crookj (5/6/2010)
CirquedeSQLeil (5/6/2010)
bcsims 90437 (5/6/2010)
El Paso? Salsa... it's almost lunchtime.Jalapenos
Chili Cookoff (New Mexico or Arizona style!)
Joe
Don't forget Texas. ...
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
May 6, 2010 at 3:48 pm
Of 928 respondents only 21 have answered it correctly. A whopping 2% correct.
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
May 6, 2010 at 3:46 pm
Lynn Pettis (5/6/2010)
crookj (5/6/2010)
sing4you (5/6/2010)
crookj (5/6/2010)
CirquedeSQLeil (5/6/2010)
bcsims 90437 (5/6/2010)
El Paso? Salsa... it's almost lunchtime.Jalapenos
Chili Cookoff (New Mexico or Arizona style!)
Joe
Don't forget Texas. It may be...
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
May 6, 2010 at 3:37 pm
rambilla4 (5/6/2010)
SELECT top 5 *
FROM sys.dm_db_session_space_usage
ORDER BY...
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
May 6, 2010 at 3:35 pm
MANU-J. (5/6/2010)
Query 2 output for spotlight process(Session_id 118 is Spot light monitoring tool user connected to QuestWorkDatabase) as per internal_objects_alloac_page_count is 606664 pages i.e. 4.63gb.
That is the one I...
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
May 6, 2010 at 3:34 pm
The second part of Lynn's question - what to present on in lunch n learns.
Anything you want that you have been working on.
Best practices
Indexes
Mirroring
Disk setup for optimal DB performance
Performance tuning
Execution...
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
May 6, 2010 at 3:33 pm
Lynn Pettis (5/6/2010)
CirquedeSQLeil (5/6/2010)
Lynn Pettis (5/6/2010)
Jeff Moden (5/5/2010)
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
May 6, 2010 at 3:31 pm
Here is the update then:
DECLARE @Scores TABLE
(
ID INT,
...
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
May 6, 2010 at 3:26 pm
vijay.s (5/6/2010)
No ReturnPercent its only name it have full numeric value like amount.
But for client 1 your sample data is summing that column with the cumulative column.
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
May 6, 2010 at 1:50 pm
I just noticed that you have two different formulas occurring in your sample data as well. For Client 1 you are summing (correct based on cumulative) and for client2...
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
May 6, 2010 at 1:50 pm
Viewing 15 posts - 14,176 through 14,190 (of 19,560 total)