User Ian_H

8 votes

Are these tools still valid?

answered Feb 14, 2017 at 11:31

7 votes

Accepted

Calculated Field Updating Every Row

answered Jan 26, 2017 at 14:45

7 votes

Accepted

Allocate space for object 'dbo.SORT temporary run storage

answered Jan 18, 2017 at 14:54

6 votes

Accepted

Why wont SSMS remember my tables when I connect to the server

answered Dec 4, 2018 at 14:25

6 votes

Accepted

Long running SELECT query fails as deadlock victim to a DELETE on SQL SERVER - Why, and how to avoid this?

answered Mar 16, 2016 at 16:28

5 votes

Is there really no way in SQL to update all fields in a table without explicitly typing field names

answered Aug 23, 2016 at 10:36

5 votes

What is the correct term to describe a single "data point" in a database?

answered Aug 24, 2016 at 10:56

5 votes

Finding the application behind ".net sqlclient data provider"

answered Jan 17, 2017 at 10:17

4 votes

Can we enable alwayson feature of sql 2012 in windows 8.1?

answered Aug 23, 2016 at 10:03

3 votes

SQL linked server returning error suddenly upon query

answered Oct 19, 2017 at 11:30

3 votes

Error in table 'sys.sysbinobjs' on master database

answered Jan 20, 2017 at 10:48

3 votes

Replication between two different SQL Server versions

answered Jan 9, 2017 at 15:23

3 votes

Error from Program Compatibility Assistant when installing SQL Server 2008

answered Mar 16, 2016 at 16:57

2 votes

Single table with more columns vs multiple tables with fewer columns

answered Feb 22, 2016 at 14:49

2 votes

Accepted

MSSQL Server - Mirror Between Different Versions

answered Sep 1, 2016 at 13:23

2 votes

SQL Server - drop user triggered silent revoke of privileges

answered Dec 4, 2018 at 11:32

1 vote

Accepted

Drive with ldf files failed and some databases left in recovery pending status

answered Jan 24, 2017 at 12:13

1 vote

Accepted

ODBC Curtime() after migration from 2000 to 2012 omits datepart

answered Jan 20, 2017 at 9:41

1 vote

Accepted

SQL server calculated field value

answered Feb 22, 2017 at 12:32

1 vote

What could be causing this rogue CPU spike on MS SQL Server running on EC2?

answered Mar 16, 2017 at 14:41

1 vote

Regarding My career path

answered Jan 11, 2017 at 11:40

1 vote

Dropping columns from a table, truncating it and then re-inserting data as before into the table doesn't reduce space occupied

answered Jan 13, 2017 at 10:14

1 vote

Log Shipping Backup Successful Restore Errors

answered Jan 13, 2017 at 10:37

1 vote

Why isn't transaction log free space always reused?

answered Mar 2, 2016 at 18:06

1 vote

Linked Server Error on SQL Agent Job

answered Mar 16, 2016 at 10:29

1 vote

Start failed for Job in SQL Server Agent

answered Mar 22, 2016 at 12:26

1 vote

Update an entry in table when time expires

answered Aug 25, 2016 at 10:55

1 vote

Does there exist a user with this role?

answered Aug 24, 2016 at 8:59

0 votes

Update Missing Data In Table

answered Aug 31, 2016 at 13:31

0 votes

how to Protect certificate in sql server

answered Oct 18, 2016 at 8:28

Stack Exchange Network

33 Answers

Are these tools still valid?

Calculated Field Updating Every Row

Allocate space for object 'dbo.SORT temporary run storage

Why wont SSMS remember my tables when I connect to the server

Long running SELECT query fails as deadlock victim to a DELETE on SQL SERVER - Why, and how to avoid this?

Is there really no way in SQL to update all fields in a table without explicitly typing field names

What is the correct term to describe a single "data point" in a database?

Finding the application behind ".net sqlclient data provider"

Can we enable alwayson feature of sql 2012 in windows 8.1?

SQL linked server returning error suddenly upon query

Error in table 'sys.sysbinobjs' on master database

Replication between two different SQL Server versions

Error from Program Compatibility Assistant when installing SQL Server 2008

Single table with more columns vs multiple tables with fewer columns

MSSQL Server - Mirror Between Different Versions

SQL Server - drop user triggered silent revoke of privileges

Drive with ldf files failed and some databases left in recovery pending status

ODBC Curtime() after migration from 2000 to 2012 omits datepart

SQL server calculated field value

What could be causing this rogue CPU spike on MS SQL Server running on EC2?

Regarding My career path

Dropping columns from a table, truncating it and then re-inserting data as before into the table doesn't reduce space occupied

Log Shipping Backup Successful Restore Errors

Why isn't transaction log free space always reused?

Linked Server Error on SQL Agent Job

Start failed for Job in SQL Server Agent

Update an entry in table when time expires

Does there exist a user with this role?

Update Missing Data In Table

how to Protect certificate in sql server