Skip to main content

Stack Exchange

Dan Guzman

United States

https://www.dbdelta.com

I've been using Microsoft SQL Server since version 4.21 was introduced on the Windows 3.1 Advanced Server platform and have over 30 years of experience in Database Administrator/Developer/Architect roles. I've been an active member of the SQL Server community for 20+ years.

top accounts reputation activity subscriptions
Top Questions
Top Answers
76
Syntax error at: OPTIMIZE_FOR_SEQUENTIAL_KEY
stackoverflow.com

54
Does Microsoft OLE DB Provider for SQL Server support TLS 1.2
stackoverflow.com

41
INSERT failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'
stackoverflow.com

36
Alter Non Clustered Index in SQL Server to Add more included columns
stackoverflow.com

35
datetime2(0) vs datetime2(2)
dba.stackexchange.com

35
DISTINCT NULL return single NULL in SQL Server
stackoverflow.com

34
How to add custom attributes to SQL connection string?
stackoverflow.com

32
Is this an error in SQL Server's documentation for ROLLBACK?
dba.stackexchange.com

29
Why these characters are all equal in SQL Server?
dba.stackexchange.com

28
Please explain what does "for xml path(''), TYPE) .value('.', 'NVARCHAR(MAX)')" do in this code
dba.stackexchange.com

26
Disconnect from network without stopping the query
dba.stackexchange.com

25
How to check Port 1433 is working for Sql Server or not?
stackoverflow.com

24
Best situation to use READ UNCOMMITTED isolation level
dba.stackexchange.com

23
Why is query NOT using my index?
stackoverflow.com

21
ALTER VIEW drops Index from View
dba.stackexchange.com

21
Do I need "transactionScope.Complete();"?
stackoverflow.com

20
SQL server DB status runnable, sleeping, suspended, running and background meanings
dba.stackexchange.com

20
Is OPTION (RECOMPILE) used in production environments?
dba.stackexchange.com

19
In SQL Server, why can a backward scan of clustered index cannot not use parallelism?
dba.stackexchange.com

17
SqlDependency doesn't fire OnChange event when dataset is changed
stackoverflow.com

17
how to insert data parellel in three different tables
stackoverflow.com

17
Why does conversion from DATETIME to DATETIME2 appear to change value?
stackoverflow.com

17
Convert select query results into Json
stackoverflow.com

16
SQL Server: Record size larger than expected
stackoverflow.com

16
Permission Issue on Bulk Insert in Azure SQL Server
stackoverflow.com

16
datetimeoffset vs datetime2 for UTC on SQL Server
stackoverflow.com

16
Moving SQL Server database to a new disk while online
dba.stackexchange.com

16
What Happens to dirty pages if the system fails before the next checkpoint?
dba.stackexchange.com

15
SQL Server in Docker CREATE INDEX failed because the following SET options have incorrect settings: ‘QUOTED_IDENTIFIER’
stackoverflow.com

15
How do I create a composite candidate key for a table in SQL Server?
stackoverflow.com

1 2 3 4 5 … 10