Kevin Feasel's user avatar
Kevin Feasel's user avatar
Kevin Feasel's user avatar
Kevin Feasel
  • Member for 11 years, 5 months
  • Last seen more than 3 years ago
24 votes

How To Profile Stored Procedures

21 votes
Accepted

How can I get the correct offset between UTC and local times for a date that is before or after DST?

13 votes
Accepted

Download SQL Server Profiler for SQL Server Management Studio

11 votes
Accepted

MERGE with OUTPUT doesn't seem to be doing the right thing

9 votes
Accepted

Database Design - One table for different types of transactions

9 votes
Accepted

Introducing an 'age' category in a patients database

8 votes
Accepted

Large set of execution plans hangs up SSMS

8 votes
Accepted

Finding exact statement causing error 3930

7 votes
Accepted

Many-to-one Subselection in single query

7 votes
Accepted

Do I risk losing the benefits of indexing if I have an index on every column?

7 votes

Know when a database has been restored

6 votes

Bitwise operations in TSQL

6 votes
Accepted

Performance of Polybase

6 votes
Accepted

TempDB size issue after applying Indexes

6 votes

250 billion rows - computing interconnectedness on a really huge scale

5 votes
Accepted

One Complex Stored Procedure Causes Estimated Cost Exception

5 votes
Accepted

Options for setting NOLOCK hint in dataset queries

5 votes
Accepted

I get the error "You are attempting to execute a query in which the selected expression is no part of a statistical function." in MS Access 2010?

5 votes
Accepted

How should I model a worflow of status/activities ? (rules like "if is 3 go to 4, if is 4 go to 5" etc)

5 votes
Accepted

SQL Server update and database transfer

4 votes
Accepted

Rollback group of DDL statements

4 votes

Sanitizing a form's database input while retaining basic HTML markup

4 votes
Accepted

Storing terabytes of data in SQL Server

4 votes

Debugging a SSIS OleDbCommand

3 votes

How define select, if bridge pair may have 3 players?

3 votes
Accepted

Query to compare 2 table results and filter extra records found in a table

3 votes
Accepted

How do I analyse a set of SQL Profiler-generated rolling trace files?

3 votes

How do I create a user for SQL Server whose queries (any/all) are time limited?

3 votes
Accepted

Determining whether column in view can only contain unique values

3 votes

Dynamic database reference in T-SQL scripts