Stack Exchange

db2

United States

Professional database/SQL Server nerd

top accounts reputation activity bookmarks subscriptions
Top Questions
21 votes

What are these tiny TSRs doing?

ms-dos assembly 8086 asked Jun 4 '18 at 20:23
retrocomputing.stackexchange.com

18 votes

What are my options for multitasking in MS-DOS 5.0 on an 80186 with EMS?

ms-dos software-recommendation multitasking asked Jun 8 '18 at 13:35
retrocomputing.stackexchange.com

15 votes

Using a modern PC or other digital audio recording device as a cassette recorder replacement

cassette-tape storage asked Sep 13 '18 at 17:43
retrocomputing.stackexchange.com

13 votes

Atrocious performance joining INSERTED and DELETED tables in a trigger

sql-server sql-server-2008 trigger asked Mar 28 '12 at 17:49
dba.stackexchange.com

9 votes

Best way to defrag/compact a database for archival purposes

sql-server sql-server-2012 asked Feb 5 '13 at 15:54
dba.stackexchange.com

9 votes

ORDER BY and comparison of mixed strings of letters and numbers

sql-server sql-server-2012 collation sorting natural-sort asked Jan 20 '16 at 14:28
dba.stackexchange.com

8 votes

Source code control on an MS-DOS system

source-control asked Jun 1 '18 at 13:11
retrocomputing.stackexchange.com

8 votes

Strange “snow” artifacts when dragging a window in 256-color mode

hardware video windows-3.x vga asked Sep 17 '18 at 12:22
retrocomputing.stackexchange.com

7 votes

Testing RAM on a 386

hardware hardware-testing asked May 29 '18 at 23:35
retrocomputing.stackexchange.com

7 votes

Best block/stripe size for log volume?

sql-server sql-server-2008 asked Dec 2 '11 at 17:29
dba.stackexchange.com

1 2

Top Answers
41
Write differences between varchar and nvarchar
dba.stackexchange.com

37
Why do people recommend not using the name “Id” for an identity column?
dba.stackexchange.com

37
Find the Foreign Keys Associated with a Given Primary Key
dba.stackexchange.com

30
Is it OK to keep a value which updates in a table?
dba.stackexchange.com

24
Should I add SET NOCOUNT ON to all my triggers?
dba.stackexchange.com

22
Is there a way to determine the version of SQL Server that was used to create an MDF or BAK file?
serverfault.com

21
mdf file cannot be overwritten when restoring a database in SQL Server
serverfault.com

21
Sort by match of LIKE
dba.stackexchange.com

20
Should developers be able to query production databases?
dba.stackexchange.com

16
Easy way to check connectivity to SQL Server from client
dba.stackexchange.com

15
Automatically restart SQL Server 2008
dba.stackexchange.com

14
How do NES/famicon games produce additional sound channels?
retrocomputing.stackexchange.com

13
With SQL Server (2008), can you grant create table permission within a schema?
serverfault.com

11
SQL Server AFTER INSERT trigger
dba.stackexchange.com

11
MAXDOP setting algorithm for SQL Server
dba.stackexchange.com

9
How can I get Transaction Logs to auto-truncate after Backup
serverfault.com

9
SQL Server - Transaction Slowness
dba.stackexchange.com

9
How to block user access to perform database application update?
dba.stackexchange.com

9
Best way to get last identity inserted in a table
dba.stackexchange.com

9
Can I recover a TDE certificate by restoring the MASTER database?
dba.stackexchange.com

8
SQL Server: dbo vs db_owner role member?
serverfault.com

8
SQL Server Express with 20000 databases won't start
dba.stackexchange.com

8
Invert LCD screen in DOS 5.0
retrocomputing.stackexchange.com

8
Best Data Type to Store Result of HASHBYTES('MD5', …)
dba.stackexchange.com

8
Cannot remove unused filegroups
dba.stackexchange.com

7
Enforce Schema-bound views
dba.stackexchange.com

7
Saving a SQL Server database to a file and opening it on another server under any database name
dba.stackexchange.com

7
considerations when using triggers on a replicated (target) database
dba.stackexchange.com

7
securely exposing sql server 2008 for windows authentication
dba.stackexchange.com

7
Is backing a website by a SQL Server 2012 OLAP cube considered reasonable?
dba.stackexchange.com

1 2 3