Skip to main content
OverflowAI is here! AI power for your Stack Overflow for Teams knowledge community. Learn more
swasheck's user avatar
swasheck's user avatar
swasheck's user avatar
swasheck
  • Member for 12 years, 6 months
  • Last seen more than a week ago
66 votes
8 answers
46k views

What is the difference between a "record" and a "row" in SQL Server?

35 votes
2 answers
5k views

In SQL Server, what is the purpose of grouping stored procedures?

25 votes
1 answer
26k views

How to preserve the original order of elements in an unnested array?

22 votes
2 answers
900 views

Is it possible to force the optimizer to eliminate irrelevant tables in this partitioned view?

21 votes
1 answer
7k views

Should I be alarmed by this NO JOIN PREDICATE warning?

18 votes
3 answers
6k views

Should I migrate data using detach/copy/attach or through backup-restore-replay?

17 votes
1 answer
6k views

Switching Data In Fails with "allows values that are not allowed by check constraints or partition function on target table"

15 votes
2 answers
790 views

stats_column_id and index_column_id do not update with physical order of clustered index is changed

13 votes
2 answers
1k views

Does there exist a way to determine the exact file that contains an allocation unit in a filegroup of multiple files?

13 votes
1 answer
6k views

DBCC CHECKDB firing every 20 - 60 seconds

12 votes
1 answer
311 views

How can I interpret the results of these DMVs to help me evaluate our partitioning strategy?

9 votes
2 answers
13k views

What is the difference between ALTER INDEX and DBCC DBREINDEX?

8 votes
4 answers
2k views

Potential risks of users connecting to SQL Server, through Excel, as sysadmin?

8 votes
1 answer
2k views

Equality query on NVARCHAR column yields multiple results in SQL Server 2012

8 votes
1 answer
618 views

Why are these two HADR DMVs reporting different states?

7 votes
1 answer
6k views

How does OPTION (FAST 1) actually interact with a client?

7 votes
3 answers
1k views

Why is there a difference between these transaction DMVs in SQL Server 2008 R2?

7 votes
1 answer
1k views

What is the migration/deployment path from a LocalDB solution to Enterprise instance?

7 votes
3 answers
336 views

How can I verify that a full database restore reflects the exact source database in SQL Server?

7 votes
1 answer
10k views

Temporarily Disable Sql Replication

7 votes
1 answer
772 views

Is there a way to DENY CRUD operations on connections from linked server?

6 votes
1 answer
533 views

Is there a quickish, straighforward way to measure Transactions Per Second on SQL Server 2000?

6 votes
1 answer
256 views

Practical application of EXISTS vs. LEFT JOIN to find addresses for delivery

6 votes
1 answer
6k views

How do these snapshot isolation level configurations interact on a SQL Server 2005 instance?

5 votes
2 answers
588 views

Transactional replication creating a fixup index that's sleeping, but blocking other processes

5 votes
2 answers
2k views

Log Reader replication agents are constantly restarting

5 votes
1 answer
895 views

How unsafe is it to change the data source of repl_distributor on a publisher

5 votes
1 answer
3k views

Migrating Sql Cluster Installation To New Drive

5 votes
1 answer
866 views

Sql Server Full Text Search one table for text values in another table

4 votes
1 answer
1k views

Sql Server Index Data File Drive Location