Category: Performance Tuning
SQL DBA Cheatcode Part 5 : Playing with indexes

SQL DBA Cheatcode Part 5 : Playing with indexes

Hello Readers, Today, I am trying to put down few but very useful index related scripts. I have used these scripts many times with different versions of SQL Server. 1. ...

READ MORE +
0
March towards SQL Server : Day 30 – SQL DBA Interview Questions Answers – About Traces & System Stored procedures

March towards SQL Server : Day 30 – SQL DBA Interview Questions Answers – About Traces & System Stored procedures

Lets talk about Traces and System procedures that are very useful for a DBA Routine. Interview Questions on Trace Flags What are trace flags? Trace flags are used ...

READ MORE +
0
March towards SQL Server : Day 29 – SQL DBA Interview Questions Answers – All About DBCC & DMVs

March towards SQL Server : Day 29 – SQL DBA Interview Questions Answers – All About DBCC & DMVs

Dear readers,   Now its time to cover one of the most important topic for any Database Administrator out there. We owe our career as DBA to these small yet most ...

READ MORE +
0
March towards SQL Server : Day 28 – SQL DBA Interview Questions Answers – All About Indexes – Part 2

March towards SQL Server : Day 28 – SQL DBA Interview Questions Answers – All About Indexes – Part 2

Here goes another post on Indexes. I hope you read my previous post on Indexes. If not, you may quickly go through. SQL DBA interview questions and answers on Indexes Part 1 ...

READ MORE +
0
March towards SQL Server : Day 27 – SQL DBA Interview Questions Answers – All About Indexes

March towards SQL Server : Day 27 – SQL DBA Interview Questions Answers – All About Indexes

Lets not forget to talk about our 'best friend' for performance - Indexes. I know this is redundent information but the whole idea is to collect everything at one place. 1. ...

READ MORE +
0