User HLGEM

3 votes

How to dive into an ugly database?

answered Nov 10, 2008 at 18:28

3 votes

SQL Server 2005 maximizing performance

answered May 15, 2012 at 17:21

3 votes

Is possible to optimize this query or it's already optimized?

answered Aug 13, 2012 at 22:20

3 votes

Performance of Inline-TVF vs. Views

answered Aug 14, 2012 at 21:26

3 votes

Is this database fine for calculation?

answered Aug 15, 2012 at 22:37

3 votes

MySQL table design / architecture, table is too big

answered Jul 12, 2012 at 14:07

3 votes

How do I tell what is filling up the transaction log?

answered Oct 10, 2012 at 13:54

3 votes

What are performance benefits when using number type instead of using char/varchar?

answered Sep 14, 2012 at 17:44

3 votes

Accepted

Database Design question, calculate or save financial positions

answered Mar 15, 2013 at 15:08

3 votes

Find procedures that haven't been called in <n> days

answered Jun 5, 2013 at 21:12

2 votes

Left Join not giving desired result

answered May 14, 2013 at 19:03

2 votes

SSIS keeps force changing excel source string to float

answered Apr 4, 2013 at 21:51

2 votes

PRIMARY KEY CONSTRAINT fundamentals

answered Mar 15, 2013 at 13:55

2 votes

Best practices for history/temporal tables?

answered Feb 27, 2013 at 23:05

2 votes

Accepted

New Database vs New Table for User Registrations

answered Mar 22, 2013 at 13:55

2 votes

Long JOINS Returns No result all tables have one to many relationship with a particular table

answered Aug 27, 2012 at 14:34

2 votes

How to have a one-to-many relationship with a privileged child?

answered Feb 5, 2013 at 15:44

2 votes

which option is better for not slow down the performance of queries?

answered Jul 2, 2012 at 14:13

2 votes

How do I handle importing high amounts of transaction data into application DB?

answered Jun 7, 2012 at 20:47

2 votes

Which are the most often used SQL queries?

answered Jun 13, 2012 at 17:28

2 votes

Which DBMS are fast enough for an online game (few thousand players)?

answered May 22, 2012 at 18:27

2 votes

Atrocious performance joining INSERTED and DELETED tables in a trigger

answered Mar 28, 2012 at 18:45

2 votes

Accepted

Big size of database logs SQL Server 2008

answered Mar 18, 2012 at 18:29

2 votes

What are the trade offs for incrementing ids vs. fulltext keys for foreign key designs?

answered Nov 21, 2011 at 14:28

1 vote

Granting SA privileges for Developers on the development box

answered Oct 23, 2009 at 20:27

1 vote

SQL Server 2005/8 Query Optimisation Hints

answered May 7, 2009 at 13:59

1 vote

Views - Indexes/Keys/Execution Plans

answered Mar 13, 2012 at 17:56

1 vote

SQL Server 2000 DTS package, filter rows using stored procedure returned date

answered Mar 26, 2012 at 19:13

1 vote

Where to learn advanced SQL coding

answered Mar 16, 2012 at 14:56

1 vote

Inputs on handling large volumes of data for specific tables in SQL Server standard

answered Jan 31, 2012 at 23:08

Stack Exchange Network

93 Answers

How to dive into an ugly database?

SQL Server 2005 maximizing performance

Is possible to optimize this query or it's already optimized?

Performance of Inline-TVF vs. Views

Is this database fine for calculation?

MySQL table design / architecture, table is too big

How do I tell what is filling up the transaction log?

What are performance benefits when using number type instead of using char/varchar?

Database Design question, calculate or save financial positions

Find procedures that haven't been called in <n> days

Left Join not giving desired result

SSIS keeps force changing excel source string to float

PRIMARY KEY CONSTRAINT fundamentals

Best practices for history/temporal tables?

New Database vs New Table for User Registrations

Long JOINS Returns No result all tables have one to many relationship with a particular table

How to have a one-to-many relationship with a privileged child?

which option is better for not slow down the performance of queries?

How do I handle importing high amounts of transaction data into application DB?

Which are the most often used SQL queries?

Which DBMS are fast enough for an online game (few thousand players)?

Atrocious performance joining INSERTED and DELETED tables in a trigger

Big size of database logs SQL Server 2008

What are the trade offs for incrementing ids vs. fulltext keys for foreign key designs?

Granting SA privileges for Developers on the development box

SQL Server 2005/8 Query Optimisation Hints

Views - Indexes/Keys/Execution Plans

SQL Server 2000 DTS package, filter rows using stored procedure returned date

Where to learn advanced SQL coding

Inputs on handling large volumes of data for specific tables in SQL Server standard