SQL Smart Solutions

Search This Blog

What is RBAR?

on September 23, 2024

Get link
Facebook
X
Pinterest
Email
Other Apps

Row By Agonising Row.

Loops, cursors, complex correlated subqueries, inline functions with data access, functions in the where clause... all are examples of RBAR.

Short discription

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

Script: How to get SQL Server messages from Windows Event Viewer?

$startDate = '2024-08-10' $endDate = '2024-08-11' Get-EventLog -LogName "application" ` | Where-Object {$_.source -like "*SQL*" -and $_.TimeGenerated -ge $startDate -and $_.TimeGenerated -lt $endDate } ` | Select-Object source, EntryType, TimeGenerated, Message

SCRIPT: Check implicit transactions

SELECT trans . session_id AS [SESSION ID] , ESes . host_name AS [HOST NAME] , login_name AS [Login NAME] , trans . transaction_id AS [TRANSACTION ID] , tas . name AS [TRANSACTION NAME] , tas . transaction_begin_time AS [TRANSACTION BEGIN TIME] , tds . database_id AS [DATABASE ID] , DBs . name AS [DATABASE NAME] FROM sys . dm_tran_active_transactions tas JOIN sys . dm_tran_session_transactions trans ON ( trans . transaction_id = tas . transaction_id ) LEFT OUTER JOIN sys . dm_tran_database_transactions tds ON ( tas . transaction_id = tds . transaction_id ) LEFT OUTER JOIN sys . databases AS DBs ON tds . database_id = DBs . database_id LEFT OUTER JOIN sys . dm_exec_sessions AS ESes ON trans . session_id = ESes . session_id WHERE ESes . session_id IS NOT NULL

SCRIPT: How to check SSRS and SSIS usage?

SSIS: --SQL jobs which executes SSIS packages SELECT j . name , js . last_run_date , js . last_run_time , js . command FROM msdb . dbo . sysjobsteps js INNER JOIN msdb . dbo . sysjobs j ON js . job_id = j . job_id WHERE subsystem = 'SSIS' AND j . category_id <> 3 ORDER BY js . last_run_date DESC , js . last_run_time DESC -- All SSRS packages SELECT PCK . name AS PackageName , PCK . [description] AS [Description] , FLD . foldername AS FolderName , CASE PCK . paackagetype WHEN 0 THEN 'Default client' WHEN 1 THEN 'I/O Wizard' WHEN 2 THEN 'DTS Designer' ...

Powered by Blogger

What is RBAR?

Comments

Post a Comment