SQL Repository
  • Home
  • Articles
    • MS SQL DBA
    • SSIS
    • SSRS
    • T-SQL
  • Code Snippets
    • MS SQL DBA
    • SSIS
    • SSRS
    • T-SQL
  • Interview Questions
    • MS SQL DBA
    • SSIS
    • SSRS
    • T-SQL
  • How To
    • MS SQL DBA
    • SSIS
    • SSRS
    • T-SQL
  • Contact

  • Test Title Here




Moving the tempdb database

On 27 Jan, 2016
MS SQL DBA
By : Charith Silva
No Comments

Tempdb is re-created each time the instance of SQL Server is started; it’s not required to physically move the data and log files. The files are created in the new location when the service is restarted. Until the service is restarted, tempdb continues...

Read More

Script to Check TempDB Speed

On 14 Jan, 2016
MS SQL DBA
By : Charith Silva
No Comments

Below script shows TempDB data files and lists out how fast they’re responding to write (and read) requests: [crayon-607b433144b3a529322428/]   We’re looking for two things: Are writes being evenly distributed between data files? Are writes finishing in 20ms or less? If the answer is no to...

Read More

SQL Server buffer pool

On 05 Nov, 2015
Articles, MS SQL DBA
By : Charith Silva
No Comments

SQL Server uses a buffer pool of memory to cache data pages, reducing I/O demand and improving overall performance. SQL Server buffer pool also called as buffer cache is a place in the SQL Server system memory that is used...

Read More

Log shipping Alerts failing to send emails

On 04 Nov, 2015
MS SQL DBA
By : Charith Silva
With 1 Comment

Recently I had to configure Database mail in one of the production SQL Server estate to send Log shipping Alerts. Database email has been configured and it was successfully sending test emails through the SQL Server. However when I try...

Read More

View queries waiting for memory grant

On 21 Oct, 2015
MS SQL DBA
By : Charith Silva
No Comments

One of the smartest ways to identify memory consumption issues in SQL Server is checking details of the queries waiting for memory grant. Below script will show all the queries that have acquired a memory grant or that still require...

Read More

SQL Server Patching

On 09 Oct, 2015
MS SQL DBA
By : Charith Silva
No Comments

It’s important to install SQL Server service packs whenever they are available and keep database servers up-to-date. Service Packs contain important fixes and they are tested rigorously than incremental releases like cumulative updates, so they’re pretty important to install and...

Read More

Poorly performing queries in SQL Server

On 06 Oct, 2015
MS SQL DBA, T-SQL
By : Charith Silva
No Comments

Today junior Application Developer asked me what are the causes of poor performance queries in SQL Server?  This is a very open ended question and there could be a lot if reasons behind the poor performance of a query....

Read More

Leading Zeros

On 04 Oct, 2015
T-SQL
By : Dave Jenkins
No Comments

I was recently asked to append some leading zeros to a column in a data set. I found one solution which was quick and simple....
Read More

SQL Server Memory Dumps

On 02 Oct, 2015
MS SQL DBA
By : Charith Silva
No Comments

Memory dumps are a copy of what contain in the RAM during SQL or system crash or even a manual dump. Memory dumps are useful when working with any SQL server troubleshooting because it helps to identify exactly what was...

Read More

Total Server Memory and Target Server Memory

On 01 Oct, 2015
MS SQL DBA
By : Charith Silva
No Comments

Total server memory specifies the amount of memory the server has committed using the memory manager.  Target Server Memory Indicates the ideal amount of memory the server can consume. Total Server Memory divided by Target Server Memory ratio should be close...

Read More

  • Page 1 of 12
  • 1
  • 2
  • 3
  • 4
  • Next
  • Last
  • Popular
  • Recent
  • Database stuck in “Restoring” state

    18361 views
  • Find the modified date of SQL Server Agents Jobs

    9119 views
  • Script to Check TempDB Speed

    4950 views
  • PING all the Linked Servers and get a status report

    4584 views
  • Log shipping Alerts failing to send emails

    4529 views
  • Moving the tempdb database

    27 Jan, 2016
  • Script to Check TempDB Speed

    14 Jan, 2016
  • SQL Server buffer pool

    05 Nov, 2015
  • Log shipping Alerts failing to send emails

    04 Nov, 2015
  • View queries waiting for memory grant

    21 Oct, 2015

Useful links

  • Books Online for SQL Server 2012
  • Developer Reference for SQL Server 2014
  • Download SQL Server
  • Installation for SQL Server 2012
  • Microsoft Virtual Academy
  • SQL Server Online Training
  • Transact-SQL Reference
  • Tutorials for SQL Server 2012

Tags

.CSV 70-461 AdventureWorks 2012 ALL ANY CAST Chinook Database Code Snippet CONVERT CTE dataset datasource Dates DATETIME divide by zero Duplicates Exam EXCEPT expressions FORMAT IF Import Indexes INTERSECT Jobs NULLIF REBUILD Recursive CTE REORGANIZE ROW_NUMBER() Schedules Sequence SOME sp_stop_job SQL Server 2012 SQL Server Agent SSIS SSRS T-SQL Tally Table T_SQL UAC Permissions Error UNION UNION ALL

Recent Comments

  • Rudnei Silva on Log shipping Alerts failing to send emails
  • johnson Welch on Database stuck in “Restoring” state
  • Neil on Database stuck in “Restoring” state
  • Mark Gribler on MS SQL Database Administrator Interview Questions – Part 4

Google Analytics Stats

Latest Tweets:

  • 6 years ago Attended @SQLSatMcr yesterday - it was amazing! Roll on @sqlsatcambs! Won some Beats Headphones courtesy of @SQLDBApros - thanks guys! :)
  • 6 years ago Looking forward to attending @SQLSatMcr - its too far off though!!!
  • 6 years ago Simple Post: WhoIsActive SPROC: http://t.co/LZvQUaeapK
  • 6 years ago POST: Index REBUILD or Index REORGANIZE: http://t.co/h3L0N37vw4
  • 6 years ago How to Ping all Linked Servers: http://t.co/Q2QxusrKjO
  • 6 years ago For beginners - T-SQL Divide by Zero Error: http://t.co/BBhgoH5hK9

© Copyright 2015 SQL Repository. All Rights Reserved by SQL Repository