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




Memory Grants Pending Counter

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

Memory Grants Pending Counter indicates the total number of processes waiting for a workspace memory grant. The recommended Memory Grants Pending value is zero, meaning no processes are waiting for the memory. Anything above 0 indicates that there are processes...

Read More

Page Life Expectancy Counter

On 30 Sep, 2015
MS SQL DBA
By : Charith Silva
No Comments

Checking the Page Life Expectancy (PLE) counter in SQL Server is one of the greatest ways to identify  memory consumption issues. Page Life Expectancy is the number of seconds a page will stay in the buffer pool without references. If...

Read More

Buffer Cache Hit Ratio

On 30 Sep, 2015
MS SQL DBA
By : Charith Silva
No Comments

Buffer Cache Hit Ratio is the percentage of SQL server pages requested and retrieved from the buffer cache without reading from disk. Reading data from disk is  slower than reading from memory. High Buffer Cache Hit Ratio indicates a large amount...

Read More

Find SQL Server logins that have blank passwords

On 29 Sep, 2015
MS SQL DBA
By : Charith Silva
No Comments

Today our  data security officer asked me to get list all SQL Server logins that have blank passwords and SQL Server logins that have password exactly same as username. Below script can be used to retrieve those weak SQL Logins.

 

Blank...

Read More

Compressing Backups

On 18 Sep, 2015
MS SQL DBA
By : Charith Silva
No Comments

SQL backup files can quickly become very large and it might take a lot of space, which can cost quite a lot of money, so SQL Server enables you to compress them. You can set the default backup compression behaviour and...

Read More

Moving user Database files within the same instance

On 17 Sep, 2015
MS SQL DBA
By : Charith Silva
No Comments

Assume you have database called SalesCommission _DB in your SQL Server. You want to change the database files location from C: drive to S: drive due to disk capacity issue. You can use the ALTER DATABASE statement to move database files...

Read More

Monitoring Tools for SQL Server

On 17 Sep, 2015
MS SQL DBA
By : Charith Silva
No Comments

SQL Server provides a number of tools you can use to carry out performance monitoring and tuning. Each tool is useful in certain scenarios and you will often need to combine several of them to achieve the optimal results.  

Read More

Restoring Database Files to a Different Location

On 17 Sep, 2015
MS SQL DBA
By : Charith Silva
No Comments

Assume you have database called Sales_DB in your SQL Server. You planning to migrate this databases to another SQL Server and you want to place the database files (.mdf and .ldf) in different locations to those recorded in the backup...

Read More

Database stuck in “Restoring” state

On 15 Sep, 2015
MS SQL DBA
By : Charith Silva
With 2 Comments

Earlier today I was experiencing an issue with one of our databases called SALES_DB is in Restoring state. I tried to run below ALTER DATABASE commands on the database to set it in online state but it throws the following error. [crayon-607b3d1ae7900524668343/] Read More

Enabling CLR Integration

On 13 Sep, 2015
MS SQL DBA, T-SQL
By : Charith Silva
No Comments

The common language runtime (CLR) integration feature in SQL Server is off by default, Below SQL Script will help you to enabled CLR in order to use objects that are implemented using CLR integration. When CLR feature enabled in SQL...

Read More

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

    18360 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