Viewing 15 posts - 226 through 240 (of 337 total)
Oops..I wanted to post the reply for the below thread
http://www.sqlservercentral.com/Forums/Topic1074846-1550-1.aspx
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
March 8, 2011 at 10:48 pm
Is this the same to what I had replied here ?
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=157892#617864
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
March 8, 2011 at 9:45 pm
No I am not speaking about indexes.
I am saying that if you try to change the data type of a primary key (as you mentioned earlier) then it will fail...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
March 8, 2011 at 10:51 am
Also have you considered the fact that changing of data type on a primary key wont be allowed unless the corresponding foreign key data type also is not of the...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
March 8, 2011 at 10:20 am
Do Not use Mirroring as a substitution for replication.As in your case your boss suggested to use mirroring for reporting purpose.
Mirroring should only be used for High availability only.Keep it...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
March 2, 2011 at 4:26 am
Is it a 32 bit or a 64 bit ?
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
March 1, 2011 at 7:21 am
Have you set Min and Max Memory settings for each instances ?Is your box a 64 bit or a 32 bit ?
First thing I would monitor would be PLE,Buffer Cache...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
March 1, 2011 at 6:13 am
A simple answer would be "Restore the Backup".
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
March 1, 2011 at 4:37 am
Thanks for the feedback.
Just one confusion here. Are only those query plans cached whose data pages are present in the buffer pool ?Because if query plans whose data pages...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
March 1, 2011 at 2:32 am
My best guess would be lot of sort and spool operations happening which maybe creating lot of worktables in the tempdb.
Try monitoring "Workfiles Created/sec" and "Worktables Created/sec" in performance monitor.Ideally...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
February 28, 2011 at 10:32 am
GilaMonster (2/21/2011)
What's an MCQ?
I think it is "Most Common Questions" or "Multiple Choice Questions" 🙂
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
February 21, 2011 at 1:22 am
Did you delete the files manually before? If yes then this might help
http://support.microsoft.com/?scid=kb%3Ben-us%3B173180&x=8&y=15
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
February 4, 2011 at 1:25 am
You are welcome.
Yes you need to trace Memory\ Page Reads /sec.If those value are also high along with Memory\Page Faults/sec then it will indicate a hard page fault.
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
February 1, 2011 at 11:15 pm
All counters look fine for me except Memory\Page Faults/sec which are way over the limit.
But before that you need to figure out how many of them are hard page...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
February 1, 2011 at 10:34 pm
Please abstain from using Isdate function.It wont be of any help.For ex
select Isdate(201101) Returns 1
My best bet would be that first you check the length of the column and then...
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
February 1, 2011 at 10:40 am
Viewing 15 posts - 226 through 240 (of 337 total)