Viewing 15 posts - 811 through 825 (of 2,462 total)
mah_j (11/18/2012)
What do you mean by partitioning?Do you mean using partitioning with an appropriate range of data in that table to separate the files?
see this for advantages ...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 19, 2012 at 2:14 am
mah_j (11/18/2012)
But i can not test any thing on main server.Is there any other way to find the hot index?
this can help you here http://msdn.microsoft.com/en-us/library/ms188917(v=sql.90).aspx
mah_j (11/18/2012)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 19, 2012 at 2:11 am
sqlfriends (11/18/2012)
I have a dedicated SQl server that has 12 gb physical memory.
then MAx memory can go upto 10 gb
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 19, 2012 at 2:04 am
Tanaji Chougale (11/19/2012)
all things are properthis application run properly on other normal PC
it indicates there might be nothing to do with Sql server as if sql server behaves abnormally...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 19, 2012 at 1:32 am
i guess you are looking for this
http://msdn.microsoft.com/en-us/library/ms162810(v=sql.105).aspx
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 19, 2012 at 1:30 am
Scott D. Jacobson (11/16/2012)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 19, 2012 at 1:20 am
durai nagarajan (11/16/2012)
Note: that SP is not giving wrong output every time.
Here do you mean that with same parameters you are getting different results (sometime right sometmes wrong )...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 19, 2012 at 1:17 am
farooq.hbs (11/16/2012)
I worked with the jason post CTE method (Replacing Correlated Queries to CTE) but it is taking much more tym than now..Could anyone help on this
use different...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 16, 2012 at 3:40 am
today i first time heard about EAV. can you post any simple example so that i can have a idea about it , i havent got any good example over...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 16, 2012 at 2:03 am
which is the best way to create this proc, using the if else or my code
Your COde
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 16, 2012 at 12:59 am
there are also other ways to improve the peorformance (miilions of rows case )
partiton the data.
keep the indexes on diiferent drive if possible OR use fast drives.
normalization of...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 16, 2012 at 12:47 am
rajesh.r (11/15/2012)
What are the options to improve the performance of above...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 16, 2012 at 12:42 am
Bhuvnesh (11/15/2012)
Post the execution plan here , so that people can have more clear view to help you
execution plaan need here
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 15, 2012 at 3:41 am
naga.rohitkumar (11/15/2012)
but quite oppositely wintel team saying that of ur sqlserver.exe use more sapce it might be problem in file transfer or in any uploads
?????? need mmore clarification
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 15, 2012 at 3:33 am
Lavanyasri (11/15/2012)
I don't want the error message generated by that job failure . I want only the job name with the failure alert ........
you can use dbo.sysjobhistory ...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 15, 2012 at 3:28 am
Viewing 15 posts - 811 through 825 (of 2,462 total)