SQLSERVERBASE.COM Run with SQL Server DBA and BI
Nav view search
Navigation
Search
Ranjeet Kumar
Login Form
Most Read Posts
- WIN CLUSTER: Quorum configuration Pictorial representation of possible failure and failover in Node and fileshare majority scenario
- SSRS: Grant sufficient permissions have to Windows User Account Control (UAC) in SSRS
- SSRS: How to create a duplicate copy of a report in SSRS
- SSRS: Expression to subtract 7 days from today() in SSRS
- T-SQL: Convert milliseconds into Hour Minutes and Seconds in SQL Server
Additional information
Older Posts
-
2017
-
2016
-
TEMPDB: Troubleshooting tempdb space usage in SQL Server
-
DMV: Different types of system objects in SQL Server
-
DMV: What is Dynamic Management View DMV and Dynamic Management Functions DMF in SQL Server
-
WIN CLUSTER: Add third node named Node C and remove node A from cluster and setup active SQL instance between Node B and Node C
-
ALWAYS ON: Timeout or delay from secondary subnet after failover within the subnet of primary subnet in SQL Server
-
DBMAIL: sp_send_dbmail failed with At least one of the following parameters must be specified in SQL
-
T-SQL: Script to find a varchar value in a database in SQL Server 2000
-
SSRS: The report execution has expired or cannot be found. (rsExecutionNotFound) in SSRS
-
DBCC: DBCC TRACEON and other trace related DBCC commands in SQL Server
-
DBCC: DBCC LOGINFO SQL Server DBCC commands in SQL Server
-
DBCC: DBCC OPENTRAN SQL Server DBCC commands in SQL Server
-
DBCC: Log file related informatics and troubleshooting DBCC commands in SQL Server
-
DBCC: DBCC SHOWCONTIG and other SHOW related commands in SQL Server
-
DBCC: DBCC CHECKDB and other CHECK related commands in SQL Server
-
DBCC: Check when last time DBCC CHECDB was run in SQL Server using DBCC DBINFO
-
DBCC: DBCC SQLPERF in SQL Server
-
DBCC: DBCC FREESHESSIONCACHE and DBCC FREESYSTEMCACHE in SQL Server
-
TEMPDB: tempdb related useful DMVs in SQL Server
-
TEMPDB: tempdb database is not shrinking in SQL Server
-
PERFMON: SQL Server memory related Performance counters
-
PERFMON: Performance counters PERFMON needs to be traced to troubleshoot slowness in SQL Server
-
PERFMON: How to open performance monitor PERFMON
-
PERFMON: What are different type of performance counter group in PERFMON in SQL Server 2012
-
MEMORY: How to reset max server memory settings in SQL Server 2012
-
SECURITY: how to enable Window authentication to mixed mode in SQL Server
-
MDW: How to open Management Data Warehouse MDW Overview reports in SQL Server
-
MDW: What is Management Data Warehouse report in SQL Server
-
MDW: What is Data Collection in MDW in SQL Server
-
MDW: What is Management Data Warehouse database in SQL Server
-
MDW: What is MDW Management Data Warehouse in SQL Server
-
MDW: Step by step description of how to Set up data collection in SQL Server
-
MDW: Step by step description of how to setup Management Data Warehouse in SQL Server
-
MDW: The data collector cannot connect to the management data warehouse Login failed for user DomainName ServerName in SQL Server
-
SQL Server: SQL Server blocked access to STATEMENT OpenRowset OpenDatasource of component Ad Hoc Distributed Queries because this component is turned off as part of the security configuration for this server in SQL SERVER
-
SSRS: Query execution failed for dataset dstReportSummary. rsErrorExecutingCommand in SSRS
-
SSRS: Report Data items in new Report pan in SSRS
-
SQL Server: The EXECUTE permission was denied on the object sp_notify_operator, database msdb, schema dbo in SQL SERVER
-
SECURITY: How to grant shared location access to sa account in SQL SERVER
-
ALWAYS ON: Command to get Always On network setup configuration details in SQL Server
-
SSRS: How to rename column header in table report item in SSRS
-
SSRS: How to add report item table level filter features SSRS
-
SSRS: How to provide column level interactive features in table report item in SSRS
-
SSRS The definition of the report report name is invalid. The FilterExpression expression for the dataset dtsMatchUnmatch refers to the field FieldName. Report item
-
SSRS: How to do table header formatting in SSRS
-
SSRS: How to set table level shorting order in SSRS
-
SSRS: How to insert new columns or merge two cells in table report item in SSRS
-
SSRS: How to assign datasets field into table columns in SSRS
-
SSRS: How to add table report item to report design pan in SSRS
-
SSRS: What are the basic frequently used SSRS report item table features in SSRS
-
SSRS: Cannot create a connection to data source dsFirstEmbededDataSource. rsErrorOpeningConnection in SSRS
-
SSRS: What is TargetServerURL and its syntax in SSRS
-
SSRS: How to create embedded datasets in SSRS
-
SSRS: How to create embedded data source in SSRS
-
SSRS: A log on error occurred when attempting to access the file share. The user account or password is not valid in SSRS Report
-
SSRS: How to create a duplicate copy of a report in SSRS
-
SSRS: How to create your first report in SSRS
-
SSRS: How to create shared data set in SSRS
-
SSRS: How to create shared data source in SSRS
-
SSRS: What is Cache Shared Datasets in SSRS
-
SSRS: What is Data Set in SSRS
-
SSRS: What is Data Source in SSRS
-
SSRS: One Vs Other interview questions in SSRS
-
SSRS: How to create your first blank report in SSRS
-
SSRS: How to open Solution Explorer in SSRS
-
SSRS: What is Project Solution in SSRS
-
SSRS: How to open or create new report project in SSRS
-
SSRS: How to open SSRS reporting development tool in SSRS
-
SSRS: How to display a message when no row or data found in SSRS
-
SSRS: Microsoft reporting services Interview questions in SSRS- PART-II
-
DBA: The EXECUTE permission was denied on the object xp_cmdshell
-
DBA: How to get SQL Server Expiry Date in SQL Server
-
DBA: How to get SQL Server Installation Date in SQL Server
-
SSRS: What are different role assignment are there to manage permission in SSRS
-
SSRS: Different way of deploying report definition file in SSRS
-
BI: Different Microsoft Business Intelligence Tool
-
SSRS: Microsoft reporting services Interview questions in SSRS- PART-I
-
SSRS: The data source DataSource1 cannot be found in SSRS
-
SSRS: how to add report description in SSRS 2012 report server display
-
SSRS: Cannot deploy data source DataSource1 to the server because it already exists
-
SSRS: Expression to subtract 7 days from today() in SSRS
-
SSRS The execution failed for the shared data set DataSet01 (rsDataSetExecutionError) in SSRS
-
SSRS: Rownumber cannot be used in sort expressions while creating group in SSRS
-
SSRS: How to keep row header visible while scrolling report down in SSRS
-
SSRS: How to display row header on each page of report in SSRS
-
SSRS: Grant sufficient permissions have to Windows User Account Control (UAC) in SSRS
-
-
2015
-
TABLE: Query to find minimum maximum and average row size in each table in SQL server
-
TABLE: Query to get no of rows and space used by table in sql server
-
WIN CLUSTER: Unable to save property changes for File Share Witness in sql server
-
SQL: query to check and create backup folder structure in sql server
-
SQL: How to create directory in file system using SQL query in SQL server
-
SQL SERVER: How to enable xp_cmdshell in SQL server
-
WIN CLUSTER: Quorum configuration Pictorial representation of possible failure and failover in Node and fileshare majority scenario
-
WIN CLUSTER: Quorum configuration Pictorial representation of possible failure and failover in Node majority scenario
-
WIN CLUSTER: Quorum configuration solution for 3 nodes multi-site HA and DR in SQL server
-
WIN CLUSTER: Quorum configuration model type in window cluster WSFC
-
WIN CLUSTER: What is quorum in context of window cluster in SQL server
-
RDBMS: List of keys in RDBMS in SQL server
-
ALWAYS ON: automatic failover risk vs benefit in disaster recovery in SQL server
-
ALWAYS ON: 3 nodes multi-site HA and DR architectural solution in SQL server
-
TABLE: how to get space from deleted rows in sql server
-
SQL SERVER: SQL Server post-installation Configuration settings best practice checklist
-
SQL SERVER: SQL Server installation Configuration settings best practice checklist
-
SQL SERVER: SQL Server pre-installation Configuration best practice checklist
-
SQL SERVER: how to change the default location of datafile logfile and backup file in SQL SERVER
-
JOB: how to schedule the SQL job for every last Sunday of month
-
SQL SERVER: Database maintenance items checklist in SQL Server
-
SQL SERVER: Database monitoring items checklists in SQL Server
-
SSMS: Creating an instance of the COM component with the following error: c001f011
-
SQL SERVER: Report Server Windows Service (MSSQLSERVER) cannot connect to the report server database
-
T-SQL: How to create and test deadlock in SQL server
-
T-SQL: How to create and test blocking in SQL server
-
T-SQL: Convert milliseconds into Hour Minutes and Seconds in SQL Server
-
POWERSHELL: How to get the parameters details of any cmdlet in PowerShell
-
POWERSHELL: More Vs –Paging in PowerShell
-
POWERSHELL: Write-Output Vs Write-Host in PowerShell
-
Database: Can we update resource database in sql server
-
In-Memory: DMVs related to In-Memory OLTP in sql server 2014
-
SQL Server: What are the new features introduced in sql server 2014
-
SQL Server: What are the new features introduced in sql server 2012
-
POWERSHELL: How to count number of words in text file using PowerShell
-
POWERSHELL: Interview questions in windows PowerShell
-
POWERSHELL: How to display output per page wise in cmdlet shell in PowerShell
-
POWERSHELL: One Vs Other interview questions in PowerShell
-
T-SQL: Truncate table Vs Delete table queries in sql server
-
INTERVIEW: One Vs Other interview questions in sql server
-
MIRRORING: how to manage heavy transaction or high volume log generation process in mirroring
-
BI: What is star and snowflake schema in Dataware house
-
BI: What is SSAS service in SQL SERVER
-
SQL Server: The request failed or the service did not respond in timely fashion
-
DBCC: stored procedure related DBCC command and its usage in sql server
-
PT: How to troubleshoot poor performing stored procedures in sql server
-
T-SQL: How to update random data in a table in sql server
-
T-SQL: UPPER Built-In string Function in sql server
-
T-SQL: LOWER Built-In string Function in sql server
-
T-SQL: RTRIM Built-In Function
-
T-SQL: LTRIM Built-In Function in sql server
-
T-SQL: REVERSE Built-In string Function
-
T-SQL: Interview questions on T-SQL programming
-
T-SQL: What is syntax to write GOTO statement
-
T-SQL: Interview questions on SQL query language
-
SECURITY: Interview questions on database security
-
T-SQL: what operator is used in sql server to get Quotient and Remainder
-
T-SQL: Query to get percentage backup completion of database
-
T-SQL: Query to get percentage restore status of database
-
ALWAYS ON: What is the best practice to mange users in AG which supports automatic failover
-
ARCHITECTURE: Interview questions on transaction log architecture
-
ARCHITECTURE: Interview questions on memory architecture
-
ARCHITECTURE: Interview questions on query architecture and tuning
-
INDEX: Interview questions on index
-
ALWAYS ON: Interview questions on always on availability group (AG)
-
T-SQL: REPLICATE Built-In string Function
-
ALWAYS ON: Interview questions on always on failover clustering(FCI)
-
WIN CLUSTER: Interview questions on window server failover clustering (WSFC)
-
T-SQL: What is SET NOCOUNT and SET ROWCOUNT
-
MIRRORING: Interview questions on database mirroring
-
MEMORY: What is Torn Page Protection and Checksum Protection
-
TABLE: Get Table and Index Used Space Used
-
INDEX: Get Index metadata from SQL Server
-
POWER BI: we couldn't get data from the data model invalid pointer array
-
SSMS: SQL Server template default Location
-
-
2014
-
T-SQL: How to get Date and time part separately from datetime column in sql server 2008
-
T-SQL: RIGHT Built-In String Function
-
T-SQL: LEFT Built-In string Function
-
T-SQL: CONCAT Built-In Function
-
T-SQL: FILEGROUPPROPERTY Built-In Function
-
T-SQL: FILEPROPERTY Built-In Function
-
T-SQL: How to get Only Hour Minute and Second from datetime column
-
T-SQL: How to get Only Hour and Minute from datetime column
-
T-SQL: How to get Only Year Month and Day from datetime column
-
T-SQL: How to get Only Month and Day from datetime column
-
T-SQL: How to get Only Year and Month from datetime column
-
T-SQL: DATABASEPROPERTYEX Built-In Function
-
T-SQL: What is SQL Server Built-In-Functions
-
T-SQL: SERVERPROPERTY built-in functon
-
T-SQL: How to execute same query multiple times in SQL Server
-
DATAFILE: How to get datafile logfile size
-
MEMORY: What is memory warm up in SQL server
-
ARCHITECTURE: What is Index Allocation Map IAM page type
-
ARCHITECTURE: What is DCM and BCM page type
-
ARCHITECTURE: What is Page Free Space PFS page type
-
ARCHITECTURE: What is relation between a table a partition and allocation unit
-
TABLE: How to check table is clustered or a Heap
-
TABLE: Interview question on table partition and allocation unit
-
FCI: Cannot use file X:\XXXX\xxxxx.mdf for clustered server
-
SCOM installation Setup is unable to create DB on SQL server instance SCOM 2012
-
ARCHITECTURE: How to get total number of pages, used page and data_pages of a table
-
TABLE: How to get number of rows in a table without querying main table
-
ARCHITECTURE: How to Prepare for SQL Server DBA Interview-Part-III
-
ARCHITECTURE: What is GAM and SGAM
-
ARCHITECTURE: is Datafile, Page and Extent
-
SECURITY: What is "Error: 18456, Severity: 14, State: 38."
-
T-SQL: How to get SQL server re-start time
-
DIRECTION: How to Prepare for SQL Server DBA Interview-Part-II
-
T-SQL: How to run a query on all the databases
-
PT: How to tune Query and poor SQL server performance and timeout
-
T-SQL: How to reset query timeout setting in sql server
-
PT: What is sql_handle and what is Plan_handle
-
PT: How to get query exact plan
-
PT: How to get query exact text
-
DIRECTION: How to Prepare for SQL Server DBA Interview-Part-I
-