User BeginnerDBA

1 vote

1 answer

1k views

File growth and location change for system health extended events

asked Feb 28, 2019 at 17:44

1 vote

1 answer

124 views

Changing the "default database" opton in login

asked Sep 14, 2018 at 13:29

1 vote

0 answers

51 views

Restricting users to execute queries that bloat up tempdb

asked Jul 12, 2018 at 22:17

1 vote

0 answers

209 views

Download SSIS packages used in SQL jobs for migration

asked Jul 6, 2018 at 17:22

1 vote

3 answers

530 views

Migrate logins tagged to specific databases users

asked Nov 16, 2017 at 15:36

1 vote

1 answer

380 views

Post Migration error in sql server error log

asked Mar 8, 2018 at 20:15

1 vote

1 answer

3k views

Service broker not getting messages when enabled

asked May 30, 2018 at 19:26

1 vote

1 answer

703 views

SQL queries to find tempdb bloating

asked Mar 26, 2018 at 18:20

1 vote

1 answer

83 views

Best approach to find missing logins and missing jobs between principal and mirror server

asked Aug 17, 2017 at 22:20

1 vote

2 answers

3k views

Pulling data on SSL expiration from SQL server

asked Oct 11, 2017 at 14:10

1 vote

1 answer

1k views

Adding a data file to existing sql server database taking too long

asked Oct 12, 2017 at 18:49

1 vote

1 answer

749 views

Will transactional replication break if there is a heavy update/delete query run on the publisher DB

asked Jan 13, 2016 at 15:36

1 vote

2 answers

146 views

Improving Backup Performance using SQL native methodology

asked Apr 28, 2017 at 15:08

1 vote

1 answer

299 views

Querying mirrored database

asked Jun 23, 2017 at 20:52

1 vote

0 answers

617 views

Unable to start the Integration services for SQL server 2012

asked Jul 13, 2017 at 19:51

1 vote

2 answers

68 views

How can one identify if FK's needed to be indexed apart from the NC indexes already residing

asked Jun 30, 2016 at 19:08

1 vote

1 answer

42 views

Move a database (from decomisioned server) to an existing server with heavy ongoing loads

asked Jul 5, 2016 at 14:55

1 vote

1 answer

134 views

Improving the performance of procedures showing warnings for implicit conversions

asked Feb 29, 2016 at 14:45

1 vote

0 answers

310 views

Best Strategy to remove the unused or duplicate indexes

asked Mar 3, 2016 at 15:31

1 vote

1 answer

59 views

Checks to be done, before/after changing the windows login password? [duplicate]

asked Mar 23, 2016 at 12:35

1 vote

2 answers

296 views

Querying system health data becomes slow as event volume increases

asked Oct 15, 2019 at 0:30

1 vote

1 answer

2k views

Using NUMA Nodes with SQL Server

asked Mar 11, 2020 at 21:07

1 vote

2 answers

116 views

Measuring the need of Capacity or scaling SQL server

asked Mar 30, 2020 at 18:07

1 vote

1 answer

183 views

Setting MAX memory for SQL servers depending upon the model of CPU

asked Apr 17, 2020 at 17:17

1 vote

1 answer

558 views

Upgrade SQL Server 2014 Failover Cluster to SQL Server 2016 Availability Group on Windows Server 2016

asked Apr 26, 2019 at 17:48

1 vote

0 answers

251 views

Stuck Oldest unsent transaction in db mirroring [closed]

asked Apr 1, 2019 at 18:26

1 vote

1 answer

299 views

Understanding the TempDB growth

asked Mar 4, 2019 at 18:33

1 vote

2 answers

129 views

How can I optimize and speed up a query [closed]

asked May 22, 2020 at 2:24

1 vote

1 answer

342 views

Need advice on how to migrate from existing database mirroring to availability groups

asked May 25, 2020 at 16:57

1 vote

0 answers

36 views

How statistics play a major role in legacy CE vs new CE

asked Jun 21, 2020 at 19:11

Stack Exchange Network

129 Questions

File growth and location change for system health extended events

Changing the "default database" opton in login

Restricting users to execute queries that bloat up tempdb

Download SSIS packages used in SQL jobs for migration

Migrate logins tagged to specific databases users

Post Migration error in sql server error log

Service broker not getting messages when enabled

SQL queries to find tempdb bloating

Best approach to find missing logins and missing jobs between principal and mirror server

Pulling data on SSL expiration from SQL server

Adding a data file to existing sql server database taking too long

Will transactional replication break if there is a heavy update/delete query run on the publisher DB

Improving Backup Performance using SQL native methodology

Querying mirrored database

Unable to start the Integration services for SQL server 2012

How can one identify if FK's needed to be indexed apart from the NC indexes already residing

Move a database (from decomisioned server) to an existing server with heavy ongoing loads

Improving the performance of procedures showing warnings for implicit conversions

Best Strategy to remove the unused or duplicate indexes

Checks to be done, before/after changing the windows login password? [duplicate]

Querying system health data becomes slow as event volume increases

Using NUMA Nodes with SQL Server

Measuring the need of Capacity or scaling SQL server

Setting MAX memory for SQL servers depending upon the model of CPU

Upgrade SQL Server 2014 Failover Cluster to SQL Server 2016 Availability Group on Windows Server 2016

Stuck Oldest unsent transaction in db mirroring [closed]

Understanding the TempDB growth

How can I optimize and speed up a query [closed]

Need advice on how to migrate from existing database mirroring to availability groups

How statistics play a major role in legacy CE vs new CE