User SQLDevDBA - Database Administrators Stack Exchange

SQLDevDBA

Member for 7 years, 5 months
Last seen more than 2 years ago

Twitter
SQLDevDBA.com
United States

116 Answers

Score Activity Newest

19 votes

Accepted

Execute stored procedure remotely using linked server

answered Jul 22, 2016 at 18:14

9 votes

Simple SQL CTE update

answered Mar 13, 2018 at 22:12

8 votes

Accepted

Using X at the end of a SELECT in SQL Server Script?

answered Aug 7, 2017 at 17:34

8 votes

Accepted

SQL beginner, need help with WHERE syntax error

answered Feb 21, 2018 at 22:18

8 votes

Is there a value that I can use in a SELECT TOP that will return all rows?

answered Aug 17, 2016 at 19:55

7 votes

Accepted

Finding rows with same id but different date

answered Apr 21, 2018 at 12:50

6 votes

Accepted

Upgrading to SQL Server 2017 from SQL Server 2012

answered Apr 13, 2018 at 16:16

5 votes

Accepted

Select the greatest value from each column, even if one of the values is null

answered Jul 20, 2018 at 14:17

5 votes

foreach loop in sql scripts?

answered Feb 11, 2019 at 19:51

4 votes

ERROR: column X specified in USING clause does not exist in left table

answered Nov 10, 2017 at 16:12

4 votes

Avoiding two LEFT JOINs?

answered Aug 24, 2016 at 19:54

4 votes

How Many Times Does a CTE run

answered Sep 20, 2016 at 21:18

3 votes

Accepted

Database design: sharing tables between databases?

answered Jul 24, 2017 at 15:32

3 votes

Accepted

Why is this SSRS Report rounding a BIGINT Value to the nearest Thousandth when exporting to Excel?

answered Aug 18, 2017 at 17:23

3 votes

Accepted

Select only the most recent record

answered Dec 6, 2016 at 14:02

3 votes

Accepted

Matching empty string is not working

answered Jul 19, 2016 at 17:10

3 votes

Accepted

Beginner SQL: Unexpected results from GROUP BY

answered Feb 8, 2018 at 18:07

3 votes

Accepted

SQL Server always running

answered Aug 16, 2020 at 14:07

2 votes

SQL server migration - Server object listing/scripting tool

answered Oct 1, 2018 at 16:22

2 votes

Connect to Oracle from SQL Server

answered Apr 19, 2018 at 14:00

2 votes

Accepted

Adding extra total column that sums all column values on each row

answered Apr 21, 2018 at 10:42

2 votes

Accepted

How to Capitalize letters that are after a special character?

answered Jan 10, 2018 at 1:48

2 votes

Tools to use SQL Server is down

answered Jan 18, 2018 at 15:18

2 votes

How to trouble shoot intermittently slow SQL Server

answered Jan 30, 2018 at 21:44

2 votes

Can one have Temporary Rows?

answered Aug 16, 2017 at 18:51

2 votes

Where's my text highlighting in SSMS 2014?

answered Aug 15, 2016 at 21:15

2 votes

Accepted

History log on Ticket system database

answered Aug 26, 2016 at 13:29

2 votes

SSMS Restore Database wizard slow to respond

answered Aug 22, 2017 at 21:43

2 votes

Permission to create linked server

answered Jul 18, 2017 at 15:09

2 votes

I want to know if SQL Server 2012 protect msdb.dbo.sp_send_dbmail parameters?

answered Jun 21, 2017 at 15:49

1