Skip to main content
Kahn's user avatar
Kahn's user avatar
Kahn's user avatar
Kahn
  • Member for 11 years, 7 months
  • Last seen more than 2 years ago
  • Finland
13 votes
3 answers
66k views

Automatic decimal rounding issue

11 votes
2 answers
9k views

SQL Server 2016: Temporal table performance vs. Triggers and CDC

10 votes
2 answers
2k views

What is the effect of replacing indexes with filtered (non-null value) indexes?

6 votes
2 answers
10k views

CDC with AlwaysOn Availability Groups

5 votes
1 answer
3k views

Dropping large clustered primary key fills up tempdb

4 votes
2 answers
3k views

Executing a table type parameter stored procedure or function within a select clause

4 votes
1 answer
1k views

SQL Server 2008 query planner failing after index drop & recreate

3 votes
1 answer
531 views

SQL Server 2008 - Adding a column and a filtered index within a single transaction?

3 votes
1 answer
818 views

AlwaysOn Secondary Replica DB-size

3 votes
0 answers
100 views

Mysterious alwaysOn breakage on SQL Server 2012

2 votes
3 answers
9k views

SQL Server Agent: QUOTED_IDENTIFIER

2 votes
1 answer
3k views

Import XML data while creating IDs with relationships

2 votes
1 answer
2k views

Different results from sys.dm_db_file_space_usage with database prefix

2 votes
2 answers
663 views

SQL Server - Recursive "find all FK connections for ID through the entire DB" query

1 vote
1 answer
403 views

SQL Server 2012 Always On, during a massive DB change

1 vote
1 answer
553 views

Procedure permission issues with a SQL state query

1 vote
0 answers
68 views

CDC and datamodel updates, best methodology?

1 vote
1 answer
905 views

SQL Server weird issue with indexes and query planner

1 vote
1 answer
72 views

Getting the name of the column that was used in a join?

0 votes
1 answer
360 views

SQL Server 2008 - Question about index behaviour

0 votes
1 answer
1k views

SQL Server 2008 - How would I create a dynamic query for finding relationships and references to the primary key?

0 votes
2 answers
211 views

SQL Server 2008 - How did I solve the need to check the column definitions quickly?

0 votes
0 answers
436 views

CDC auditing - Unanswered questions

0 votes
0 answers
48 views

Restore DB to older version [duplicate]

0 votes
1 answer
642 views

Creating a dynamic db2 reorg script with in-built delay for concurrency

0 votes
1 answer
624 views

Saving results from db2 FINAL TABLE

0 votes
0 answers
172 views

db2 How to get the application user from delete events

0 votes
1 answer
2k views

How return dynamic SQL value in procedure