Viewing 15 posts - 136 through 150 (of 173 total)
Oh OK, so it's just about the amount of page splits? Added the specified columns (assume the one is what Gail was requesting):
index_idnameavg_fragmentation_in_percentpage_countavg_fragment_size_in_pagesforwarded_record_countavg_page_space_used_in_percent
13I_AGENT_SYSTEM_LOG_1_COMPUTER_ID_PLUS75.12559969274429008781.31531934029481NULLNULL
13I_AGENT_SYSTEM_LOG_2_COMPUTER_ID_PLUS0.0171315663.7942570891851NULLNULL
10I_SERVER_CLIENT_LOG_1_CLIENT_ID83.18965637221473592551.18832693834348NULLNULL
5I_SERVER_CLIENT_LOG_1_LOG_IDX99.22318898576143398511NULLNULL
0NULL99.15917657291973310178.06532332732323NULLNULL
0NULL22.897467619360231660434.3313814790718NULLNULL
7I_AGENT_TRAFFIC_LOG_1_LOG_IDX99.21425143953941833921NULLNULL
6I_AGENT_BEHAVIOR_LOG_1_LOG_IDX99.24384638326991139981NULLNULL
Dird
May 26, 2013 at 11:34 am
Lynn Pettis (5/26/2013)
Not necessarily. I would add the following columns to your query: ps.page_count, ps.avg_fragment_size_in_pages.
Here's some results with the extra columns...I take it you asked for these to make...
May 26, 2013 at 11:23 am
Oh this is old; I thought my emails were with new articles.
Sorry but I don't really see anything wrong with these job applications except for the MSRS and VB parts....
May 24, 2013 at 8:09 am
Maybe SQL12 will steal flashback 😮
Dird
May 23, 2013 at 2:41 am
Ankit Mathur-481681 (5/21/2013)
May 21, 2013 at 8:43 am
Ross.M (5/21/2013)
May 21, 2013 at 7:17 am
m.rajesh.uk (5/20/2013)
May 20, 2013 at 4:04 am
hisakimatama (3/21/2013)
The contract could lead to full employment, so I'll give everything I've got and see if I can get hired there.
Don't do that; contractors rake it in! 😛
Dird
May 20, 2013 at 3:02 am
In regards to the OP: labels are OK but aren't always the most accurate. I hate when companies specify a minimum number of years doing the role though. We have...
May 20, 2013 at 2:55 am
By "not decimal" I guess you mean like "10.0" (10), 8.0 (8) right?
If so the above posters answer should work:
SELECT * FROM y
WHERE column_y - CONVERT(int, column_y) = 0
Dird
May 20, 2013 at 2:26 am
UTF8 supports Chinese. So it would work.
Dird
May 14, 2013 at 8:02 am
Oh, so you have the language pack installed 😛 Yes. Clients with the package installed can read it. You just cant see the data on the server if you don't...
May 14, 2013 at 5:38 am
My guess would be no. If I type ????? can you read this chinese? When you get the data from the DB the client machine will attempt to display it;...
May 14, 2013 at 4:58 am
ranganathleo (5/13/2013)
It has not copied all the tables.Can someboby please help me more on it
Did you select all the tables you wanted to copy?
Dird
May 13, 2013 at 7:12 am
Viewing 15 posts - 136 through 150 (of 173 total)