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




Administering Microsoft SQL Server 2012 Databases (70-462) – Exam Preparation Questions – Part 1

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

Click Here...

Read More

How to retrieve Linked Server CPU utilisation details?

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

  If you are suffering from poorly performing linked server queries, you may wants to investigate the Linked Server CPU utilisation statistics. Following T-SQL script retrieves information such as SQL Process utilisation, System Idle time and Other Process utilization for a preconfigured MS SQL...

Read More

Script to find failed SQL Server Agent Jobs

On 28 May, 2015
MS SQL DBA
By : Charith Silva
No Comments

  It’s handy to have a script to find failed SQL Server Agent Jobs. Most of the organizations execute resource intensive SQL process such as backup, heavy ETL process at night and it is essential to validate those import process daily...

Read More

Script to retrieve latest database backup details from preconfigured Linked Server

On 28 May, 2015
Code Snippets, MS SQL DBA
By : Charith Silva
No Comments

Below script can be used to retrieve latest backup file datetime and physical location for all the Databases in preconfigured Linked...

Read More

How to retrieve Linked Server configuration details?

On 27 May, 2015
MS SQL DBA
By : Charith Silva
No Comments

  Sometimes you may wants to retrieve a linked server configuration details. Following T-SQL statement retrieves information such as Hostname, SQL Instance name, Server Edition (32 bit or 64 bit), IP address, Port , ServicePack and cluster configuration for a preconfigured...

Read More

Beginning SSRS – Part 3 Datasources and Datasets

On 25 May, 2015
SSRS
By : Dave Jenkins
No Comments

The third part of our Beginning SSRS series. An important lesson covering the embedded and shared datasources and datasets, as these are the bedrock for all...

Read More

Beginning SSRS – Part 2 Basic expressions / Conditional Formatting

On 24 May, 2015
SSRS
By : Dave Jenkins
No Comments

This is the second video in our Beginning SSRS Series. In this video we show you how to carry out basic expressions to change font colours, font weights, alternating row...

Read More

T-SQL Exam questions and answers – Part 10

On 21 May, 2015
T-SQL
By : Charith Silva
No Comments

 

Questions

  Q1. Which of the following function would you consider using to get the day (day of the month) of the specified date?

A. DAY()

B. DATE()

C. YEAR()

D. GETDATE()

    Q2. Which of the following function would...

Read More

T-SQL Exam questions and answers – Part 9

On 21 May, 2015
T-SQL
By : Charith Silva
No Comments

 

Questions

  What will be the correct output of following T-SQL statements?   Q1. [crayon-62f28a1f516a0204484163/]

A. 199.0099

B. 199

C. 199.01

D. 199.0009

  Q2. [crayon-62f28a1f516a6561410074/]

A. 10

B. 20

C. 40

D. 8

    Q3. [crayon-62f28a1f516a9778126387/]

A. 0

B. -1

Read More

Beginning SSRS PT 1 – Our first report

On 19 May, 2015
SSRS
By : Dave Jenkins
No Comments

This is the first video in a series entitled "Beginning SSRS" - we are going to show you how to start with the basics of SSRS and work our way through to more advanced SSRS topics. If you want to...

Read More

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

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

    10623 views
  • Script to Check TempDB Speed

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

    5317 views
  • Log shipping Alerts failing to send emails

    5046 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:

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

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