User Biju jose

17 votes

Why use master to create a database?

answered Oct 28, 2018 at 11:29

7 votes

Accepted

Optimize extraction of json data via OPENJSON

answered Jul 17, 2021 at 7:19

6 votes

Accepted

How to determine which one is my default instance in MS SQL Server?

answered Aug 6, 2018 at 8:10

5 votes

Accepted

Monitoring SQL Server Encryption With Extended Events

answered Jan 12, 2022 at 0:43

4 votes

Accepted

Having the backup file, how to work out the total disk space required to do the restore?

answered Mar 27, 2019 at 7:29

4 votes

There is no copy database wizard

answered Aug 6, 2018 at 9:17

4 votes

How to have more than 100 entries in case statement as a variable

answered May 16, 2018 at 11:29

4 votes

Find max content length of column of particular table from entire SQL server

answered Oct 25, 2018 at 7:07

3 votes

Combine the same column from multiple rows into one row

answered Aug 16, 2018 at 10:27

3 votes

Accepted

how to run once a bunch of generated scripts with exception handling?

answered Aug 20, 2018 at 16:46

3 votes

Accepted

split one column into two columns based on it's value using t/sql

answered Jul 7, 2019 at 12:57

3 votes

Accepted

Why SP_Naming policy still blocked my correct creating?

answered Mar 24, 2019 at 17:36

3 votes

Accepted

INSERT or UPDATE the values from a table A into the columns of table B based on table A's value in its row?

answered Jul 7, 2021 at 18:35

3 votes

Change referenced index for a Foreign Key

answered Aug 28, 2019 at 13:18

2 votes

"Network-related or instance-specific error" while attempting connect to a SQL Server on remote computer on home network

answered Dec 5, 2019 at 7:45

2 votes

Attempting to backup to remote NAS but access is denied

answered Apr 5, 2019 at 5:10

2 votes

is it possible to ignore the error and continue execute update in PostgreSQL

answered Jul 22, 2021 at 17:24

2 votes

How to select sys.views of another database from master databse?

answered Nov 5, 2021 at 10:23

2 votes

Using cursor to update if exists and insert if not

answered Oct 2, 2018 at 5:54

2 votes

Adding a ROW_NUMBER() with no column to ORDER BY?

answered Nov 1, 2018 at 10:23

2 votes

Accepted

How to chop off X number of characters across multiple records?

answered Dec 23, 2018 at 10:05

2 votes

DDL changes Tracking

answered Jun 24, 2018 at 8:58

2 votes

Accepted

SELECT on column value = X but if no rows available then any column value

answered Jul 24, 2018 at 12:57

2 votes

Accepted

Generate Data Only Script without Identity SQL 2017

answered Aug 9, 2018 at 5:06

2 votes

admin: prefix before the servername while connecting to DB Engine Query in MS SQL Server

answered Aug 9, 2018 at 8:16

1 vote

Accepted

Access is denied for SQLDumper.exe in MS SQL Server

answered Aug 9, 2018 at 6:46

1 vote

What does it mean that sp_who2 is not documented?

answered Aug 8, 2018 at 12:50

1 vote

Accepted

Query Plan - Estimated Row Count Very High

answered Jul 3, 2018 at 12:18

1 vote

Create trigger base on time and insert to another table

answered Nov 26, 2016 at 19:54

1 vote

Display a row for each month in a range defined by two columns

answered Jan 25, 2017 at 18:51

Stack Exchange Network

64 Answers

Why use master to create a database?

Optimize extraction of json data via OPENJSON

How to determine which one is my default instance in MS SQL Server?

Monitoring SQL Server Encryption With Extended Events

Having the backup file, how to work out the total disk space required to do the restore?

There is no copy database wizard

How to have more than 100 entries in case statement as a variable

Find max content length of column of particular table from entire SQL server

Combine the same column from multiple rows into one row

how to run once a bunch of generated scripts with exception handling?

split one column into two columns based on it's value using t/sql

Why SP_Naming policy still blocked my correct creating?

INSERT or UPDATE the values from a table A into the columns of table B based on table A's value in its row?

Change referenced index for a Foreign Key

"Network-related or instance-specific error" while attempting connect to a SQL Server on remote computer on home network

Attempting to backup to remote NAS but access is denied

is it possible to ignore the error and continue execute update in PostgreSQL

How to select sys.views of another database from master databse?

Using cursor to update if exists and insert if not

Adding a ROW_NUMBER() with no column to ORDER BY?

How to chop off X number of characters across multiple records?

DDL changes Tracking

SELECT on column value = X but if no rows available then any column value

Generate Data Only Script without Identity SQL 2017

admin: prefix before the servername while connecting to DB Engine Query in MS SQL Server

Access is denied for SQLDumper.exe in MS SQL Server

What does it mean that sp_who2 is not documented?

Query Plan - Estimated Row Count Very High

Create trigger base on time and insert to another table

Display a row for each month in a range defined by two columns