Viewing 15 posts - 556 through 570 (of 2,462 total)
it seems that you are quite familiar with this forum . so table defintion , index , test data was expected. it is better to get the result faster.
Anyways...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 8, 2013 at 11:22 pm
What about the setting up maximum limit of Memory.... (I might be hitting the nail in dark holding with it other hand. 😀 )
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 8, 2013 at 11:16 pm
peacesells (1/8/2013)
what columns would be best suitable to have indexes on in dimension and fact tables.
indexs should include column which are part of
Where
order by
group by
JOINs...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 8, 2013 at 11:11 pm
you need to test (as i havent tried this )but i think you cant restore database of prior versions.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 8, 2013 at 2:48 am
Always post table defintion along with test data to get faster resultsl.people here steal their time to help others , sometimes they dont have time to frame everything here.please see...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 8, 2013 at 2:43 am
Oracle_91 (1/8/2013)
Do you have any steps to reproducing the error?
NO.
but see if these link can help you
http://support.microsoft.com/kb/918483
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 8, 2013 at 2:12 am
DIB IN (1/8/2013)
If in a database MDF file Size is 10 GB and LDF file size is 50 GB.What are the steps require to reduce to log file size.
LDF...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 8, 2013 at 1:03 am
see this link too Statistics
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 8, 2013 at 12:52 am
jitendra.padhiyar (1/8/2013)
1. Is it using indexing and sorting for this process ?2. Is it using TempDB for data collection (for static purpose) ?
NO.
Have you read the link which...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 8, 2013 at 12:46 am
Minaz Amin (1/7/2013)
Is it possible to have multiple keys as partitons keys?
let me guess it is because "to cover most of the queries" ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 7, 2013 at 11:36 pm
Oracle_91 (1/7/2013)
“A significant part of SQL Server process memory has been paged out. This may result in performance degradation".
ANy reason why you ONLY need this particular error msg?:w00t:
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 7, 2013 at 11:34 pm
Another link http://sqlserverplanet.com/troubleshooting/sql-server-slowness
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 7, 2013 at 11:30 pm
djordan 4543 (1/7/2013)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 7, 2013 at 11:16 pm
Jason-299789 (1/7/2013)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 7, 2013 at 2:37 am
Kyalo (1/6/2013)
Contract Number 1234, contract startdate 1/3/2012, contract enddate 30/09/2012, contract amount $5000
And how will you show output result for above
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 7, 2013 at 1:20 am
Viewing 15 posts - 556 through 570 (of 2,462 total)