Viewing 15 posts - 841 through 855 (of 2,463 total)
naga.rohitkumar (11/11/2012)
if u can suggest technical advices rather than genral things its will be nice, and Its happens in everyonces life
see these links
http://support.microsoft.com/kb/298475
http://weblogs.sqlteam.com/tarad/archive/2008/05/23/60609.aspx
November 11, 2012 at 11:12 pm
SQLSACT (11/9/2012)
Bhuvnesh (11/9/2012)
SQLSACT (11/9/2012)
I'm trying to understand the behaviour of clean pages in the buffer pool
see this
"Dirty" pages are pages where data has been changed but has not...
November 9, 2012 at 4:43 am
naga.rohitkumar (11/7/2012)
and another thing
1.what can as a DBA we can look care for performance improvement of a server which is running sqlserver...
November 9, 2012 at 4:18 am
amarendra.sahoo (11/5/2012)
One of my query execution plan shows 'Clustered Index Update' @ a cost of 152%.
are you using any third party tool like sql sentry ?
November 9, 2012 at 4:15 am
Have you tried to repeat same test in new server? see and paste the result here
November 9, 2012 at 3:49 am
worth reading 🙂
November 9, 2012 at 3:45 am
sanket kokane (10/31/2012)
you have scheduled transactional log backup then why there is job for truncate log file :blink:
+1
November 9, 2012 at 3:33 am
SQLSACT (11/9/2012)
I'm trying to understand the behaviour of clean pages in the buffer pool
see this
"Dirty" pages are pages where data has been changed but has not yet been...
November 9, 2012 at 3:17 am
see these links
http://www.sqlservercentral.com/blogs/sql_server_dba/2011/11/28/sql-dirty-pages-/
http://msdn.microsoft.com/en-us/library/aa337560(v=sql.105).aspx
November 9, 2012 at 2:33 am
AndrewSQLDBA (11/8/2012)
1 would need to become 100.00
HOw can this be possible or yuor are trying to say 1.00
November 9, 2012 at 2:26 am
apatel62 (11/7/2012)
Two suggestions 1) log(ldf) and data(mdf) files on physically separate disks.
2) Partition the table so that records to be deleted are distributed among several spindles
if...
November 8, 2012 at 11:44 pm
sanket kokane (11/7/2012)
Bhuvnesh (11/7/2012)
DesmoShane (11/6/2012)
will the resulting non-clustered indexes will they be rebuilt automaticaly and be an online operation
YEs. any change to the cluster keys forces all the non-clustered...
November 7, 2012 at 4:44 am
i had impression that there are two options
I have a daily full db backup via SQL maintenance plan to file system at 10pm.
AND
I also have a daily direct...
November 7, 2012 at 4:02 am
DesmoShane (11/6/2012)
will the resulting non-clustered indexes will they be rebuilt automaticaly and be an online operation
YEs. any change to the cluster keys forces all the non-clustered indexes to be...
November 7, 2012 at 3:52 am
you can also opt SORT_IN_TEMPDB = ON to divert the IO load to tempdb too
November 7, 2012 at 3:46 am
Viewing 15 posts - 841 through 855 (of 2,463 total)