Things DBA's get asked during a day on Job

By
Things people ask to DBA's during a day on his\her Job:
  • Why this query is running slow?
  • Why this query is running slow from app but not from ssms?
  • Why this query is not picking up \using the right indexes?
  • Why this query is using right indexes when running from ssms and not when executed from app?
  • Why this query is running fast as SQL statement but running slow when same query is wrapped as a stored procedure?
  • Why query is timing out and in result application is throwing 50* errors?
  • Do we have proper indexes?
  • Can we create index on this column of that table?
  • How much time will it take to defragment the index?
  • Are index fragmented?
  • Can we rebuild the index now without downtime ?
  • Can we reorganize indexes without downtime ? How much time will it take ?
  • Why server is slow ?(When Backup and Update stats are running)
  • Can you make query use right index but not make use of option(recompile) or any other query hint at the same time?
  • Why people are unable to login ?
  • Why people are not able to change passwords?
  • Is there any latency in replication ?
  • Why there is latency in replication?
  • Why changes made are not reflecting in application ?
  • Why I am not able to connect to database?
  • Why I am not able to update or see any objects in the database?
  • I lost\forgot my sql login password how do I login into sql server ?
  • Why I am not able to restore a backup on my local sql server (express edition 10 GB limit backup size 1.4 tb,backup taken on 2014 trying to restore on 2008 ,2012 etc)
  • Why is transaction log getting full (millions of inserts etc being performed with recovery mode full and not simple or bulklogged)?
  • Will changing the compatibility level make any difference?(It does in version 2014 as it effects cardinality estimator that will be used to make query plans before they are executed)?
  • Do you think it will be safe to change the values of parameters like MAXDOP, CTOP ? How sure you are about it ? What testing are required for making these changes ?
  • What are the names of all indexes that have a particular column in them?
  • Is database refresh completed?
  • What is the size of this table size of that database etc?
  • How much time will it take to create a new index on this table ?
  • Can you please give me access to his database ?
  • Can you please set up a method to capture who made those changes (when someone breaks something)?
  • Can we know what changes were made ?
  • Can you revert back those changes ?
  • Triggers on this table?
  • Stored procedures having dependencies on this table?
  • Views using this table?
  • How much space will dropping this column release ?
  • Can we reorder the columns without any downtime or does it recreates the whole table ? How much time will it take ?
  • Sometimes I am able to login and sometimes not what is going on ?
And that's not all of it ...I will add more to the list when I remember more of it !

Comments

Post a Comment

Popular posts from this blog

Enabling fixed Sidebar for blogger Contempo template for screen sizes smaller than 1440px

By
Image
Here is how to do it :

Add this code in your blogger template(where to add this code is mentioned before 2nd code snippet of this post) ,now the value 1300px is the screen size for which I want the sidebar to be always visible for, you can reduce this value as you like, but be aware that reducing this value to much smaller digit will result in showing the overlapped sidebar instead of content body for your blog readers who are using much smaller screen devices such as mobiles which you might not want to happen so be wise :

@media screen and (max-width: 1300px) {   .sidebar-container {     bottom: 0;     position: fixed;     top: 0;   }   .sidebar-container {     left: 0;     right: auto;   }   .sidebar-container.sidebar-invisible {     -webkit-transition-timing-function: cubic-bezier(0.4,0.0,0.6,1);             transition-timing-function: cubic-bezier(0.4,0.0,0.6,1);   }   .sidebar-container.sidebar-invisible {     -webkit-transform: translateX($(sidebar.width * -1));         -ms-tran…
Keep reading

Adding copy to clipboard button to every google code prettify pre blocks in blogger

By
Image
It's a 2 part process:
The script part to find all the pre blocks having code in it and append a copy button to it dynamically.The style part to place our copy button at the specified location(on top right of every code block in this case) The script part:
<script> var pre = document.getElementsByTagName('pre'); for (var i = 0; i < pre.length; i++) {             var button = document.createElement('button');                     button.className = 'copy-button';                     button.textContent = 'Copy';                     var s = pre[i].innerText;                     button.setAttribute("data-clipboard-text",s);                     pre[i].appendChild(button);        } var clipboard = new Clipboard('.copy-button'); clipboard.on('success', function(e) {     console.info('Action:', e.action);     console.info('Text:', e.text);     console.info('Trigger:', e.trigger);     e.trigger…
Keep reading

Query to Expand and List All logins within a SQL Server Group

By
Image
This query will get the details of user logins with in Active directory security group in expanded format which is not available by default in SSMS, this will iterate over all the user logins under Security section and expand and list the users within the group if there are any along with all other logins:
For example DBA team has 10 members who are part of Group Name DBA_GROUP and this Group is added in SQL Server logins so it will list the members with in DBA_GROUP as well (like DOMAIN\DBA1 DOMAIN\DBA2 and so on )instead of just listing DBA_GROUP.

SET NOCOUNT ON CREATE TABLE ##TEMPHOLDUSERS       (        AccountName NVARCHAR(MAX),        AccoutnType NVARCHAR(MAX),        Privilege NVARCHAR(MAX),        MappedLoginName NVARCHAR(MAX),        PermissionPath NVARCHAR(MAX)       ) DECLARE @id NVARCHAR(MAX) DECLARE @getcoinid  CURSOR SET @getcoinid   = CURSOR FOR SELECT name FROM sys.server_principals WHERE TYPE = 'G' AND name NOT LIKE '%$%' and name NOT LIKE 'NT%…
Keep reading