Stack Exchange

db2

United States

Professional database/SQL Server nerd

top accounts reputation activity favorites subscriptions
Top Questions
16 votes

What are these tiny TSRs doing?

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

14 votes

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

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

12 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

11 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

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

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

8 votes

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

hardware windows31 vga asked Sep 17 '18 at 12:22
retrocomputing.stackexchange.com

8 votes

Source code control on an MS-DOS system

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

7 votes

Prevent Data Sources from being deployed outside designated folder

sql-server sql-server-2008 ssrs asked Apr 11 '12 at 13:16
dba.stackexchange.com

7 votes

Partitioning / indexing an extremely large table

sql-server sql-server-2008-r2 asked Jul 2 '13 at 20:00
dba.stackexchange.com

1 2

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

35
Write differences between varchar and nvarchar
dba.stackexchange.com

33
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

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

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

18
Sort by match of LIKE
dba.stackexchange.com

15
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

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

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

11
SQL Server AFTER INSERT trigger
dba.stackexchange.com

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

9
Can I recover a TDE certificate by restoring the MASTER database?
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

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

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

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

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

7
What does 'sp_configure allow updates' do?
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
Is there a reason to update statistics manually?
dba.stackexchange.com

7
Advantage of using a database snapshot for reporting purposes
dba.stackexchange.com

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

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

1 2