BeginnerDBA's user avatar
BeginnerDBA's user avatar
BeginnerDBA's user avatar
BeginnerDBA
  • Member for 7 years
  • Last seen more than 1 year ago
1 vote
1 answer
1k views

File growth and location change for system health extended events

1 vote
1 answer
124 views

Changing the "default database" opton in login

1 vote
0 answers
51 views

Restricting users to execute queries that bloat up tempdb

1 vote
0 answers
209 views

Download SSIS packages used in SQL jobs for migration

1 vote
3 answers
530 views

Migrate logins tagged to specific databases users

1 vote
1 answer
380 views

Post Migration error in sql server error log

1 vote
1 answer
3k views

Service broker not getting messages when enabled

1 vote
1 answer
703 views

SQL queries to find tempdb bloating

1 vote
1 answer
83 views

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

1 vote
2 answers
3k views

Pulling data on SSL expiration from SQL server

1 vote
1 answer
1k views

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

1 vote
1 answer
749 views

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

1 vote
2 answers
146 views

Improving Backup Performance using SQL native methodology

1 vote
1 answer
299 views

Querying mirrored database

1 vote
0 answers
617 views

Unable to start the Integration services for SQL server 2012

1 vote
2 answers
68 views

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

1 vote
1 answer
42 views

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

1 vote
1 answer
134 views

Improving the performance of procedures showing warnings for implicit conversions

1 vote
0 answers
310 views

Best Strategy to remove the unused or duplicate indexes

1 vote
1 answer
59 views

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

1 vote
2 answers
296 views

Querying system health data becomes slow as event volume increases

1 vote
1 answer
2k views

Using NUMA Nodes with SQL Server

1 vote
2 answers
116 views

Measuring the need of Capacity or scaling SQL server

1 vote
1 answer
183 views

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

1 vote
1 answer
558 views

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

1 vote
0 answers
251 views

Stuck Oldest unsent transaction in db mirroring [closed]

1 vote
1 answer
299 views

Understanding the TempDB growth

1 vote
2 answers
129 views

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

1 vote
1 answer
342 views

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

1 vote
0 answers
36 views

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