Skip to main content
Share Your Experience: Take the 2024 Developer Survey
Jonathan Fite's user avatar
Jonathan Fite's user avatar
Jonathan Fite's user avatar
Jonathan Fite
  • Member for 9 years, 8 months
  • Last seen this week
  • St. Charles, MO
26 votes

Using Replace in SQL

22 votes
Accepted

Memory Requirements for SQL Server

15 votes
Accepted

Why can't the transaction log shrink during a backup?

14 votes
Accepted

How to pivot on multiple columns in SQL Server?

13 votes
Accepted

Is there any way to have Unique Constraint and NOT have Unique Index?

12 votes
Accepted

How to create a Hash Computed Column for Many Columns?

10 votes
Accepted

Tempdb Add files require Restart

9 votes
Accepted

Performance Concerns with UniqueIdentifiers (GUIDs)

8 votes

Why is there automatic failover for HA and manual failover for DR?

8 votes
Accepted

Re-Usable Query

7 votes
Accepted

Get Job step run for all jobs and job steps using TSQL

7 votes
Accepted

Number of full table scans

7 votes

How do I limit a SQL stored procedure to be run by one person at a time?

7 votes
Accepted

Generate wide table from lookup values

7 votes
Accepted

Database Size Increased after DELETE query

6 votes

Performance problems in SQL Server. Parameter Sniffing or not in my scenario?

6 votes

SQL Server - Snapshot is useful in production environments?

6 votes

During a log backup is the data backed up to the start or end of the operation?

6 votes
Accepted

Generate CREATE DATABASE FOR ATTACH for all existing user databases

6 votes
Accepted

Selecting only columns where sum(column) > 0

5 votes

How can I tell what database/procedure is using a linked server?

5 votes
Accepted

For loop in query - how can i use Union?

5 votes

Where do Linked Server Queries get executed?

5 votes

Simple logging of table access

5 votes
Accepted

Alias Column Name

5 votes
Accepted

Permission Denied for a User that is part of AD

5 votes

Why would shrinking TEMPDB log lead to slowness?

5 votes
Accepted

MS SQL "migration" to older version - problem with Attach

5 votes
Accepted

How can I limit SQL Server Agent's simultaneous jobs number?

5 votes

How can I determine which permissions needs to be assigned to the newly created login?

1
2 3 4 5
12