SQL Server: Row Count Of All The Tables In Particular Database

Some times we want to find out the row counts for all the tables in a particular database in SQL Server. We can do it in different ways. I have tried to give two best ways to find out the row counts in below. --Get Row Count Of All The...

Read More

SELECT TOP COUNT dynamically

Scenario: Some times we want to make TOP Count as Dynamically then passing parameter to TOP command will not work. We have to add parameter with parenthesis[ ] IF OBJECT_ID('[dbo].[sample]','U') IS NOT NULL DROP TABLE dbo.sample CREATE...

Read More

How to Identify a SQL Server Express Instance

Scenario: Some times we want to know the current SQL Server Instance and for this use below simple query to get the result SELECT @@SERVERNAME as Servername, @@VERSION as Version, SERVERPROPERTY('EDITION') as SQLedition Result:...

Read More

How to check if any view has metadata binding errors after DB refresh

Scenario: In my recent project after Source Database refresh we need to push to target server. We have views created in separate database by referring to target database and Views will be used in Cube. Here the problem we have...

Read More

Powershell Script for SSRS Deployment

Scenarios: Deploy SSRS reports using automation #Set variables with configure values $Environment = "DEV" $reportPath ="/" $reportFolder = "DemoReports" $SourceDirectory = "E:\Test"  # local folder path where actual files...

Read More