User Piotr Palka

27 votes

Accepted

Why is casting a DATE field to VARCHAR datatype non-deterministic and is there a way to make it deterministic?

answered Dec 11, 2019 at 16:01

14 votes

Accepted

What is the idiomatic solution in SQL Server for reserving a block of ids for use in a bulk insert?

answered Sep 25, 2019 at 21:44

6 votes

Accepted

how to list all features installed in a sql server instance?

answered Jan 10, 2020 at 20:23

4 votes

Accepted

Do table locks get released after a query finishes when WAITFOR is used after that query within the same batch and transaction?

answered Nov 14, 2019 at 22:46

4 votes

Accepted

Safeguard against infinite looping in case of missing FETCH NEXT

answered Nov 5, 2019 at 21:09

3 votes

Truncate Table locking sys views

answered Aug 21, 2019 at 21:21

3 votes

Accepted

How to unpack a DACPAC?

answered Feb 21, 2020 at 23:42

3 votes

Find jobs that succeeded, but had steps that failed

answered Nov 21, 2019 at 16:27

3 votes

how to run SQL query without permission

answered Sep 24, 2020 at 14:49

2 votes

Which server actually runs the SSIS package when SQL Agent and SSISDB are on 2 different servers

answered Oct 6, 2020 at 22:29

2 votes

How to "normalize" external data before insertion into "Data Warehouse" like database?

answered Apr 29, 2021 at 21:55

2 votes

Accepted

Create a Hangfire job via SQL stored procedure

answered May 21, 2021 at 4:26

2 votes

Should the T and L phase of a well tuned ETL report process take the same amount of time regardless of the time bucket width and data size?

answered May 29, 2021 at 3:47

2 votes

How can I Switch-In or Switch-Out Partition where table has non storage aligned indexes on it?

answered Feb 7 at 4:37

2 votes

Accepted

SQL Server MCSA Database Administration Certification retires on June 30, 2020 - is there going to be a replacement?

answered Mar 2, 2020 at 15:47

2 votes

Accepted

Backup database on linked server

answered Jun 15, 2020 at 20:02

2 votes

Asked to Not Use Transactions and to Use A Workaround to Simulate One

answered Sep 20, 2019 at 18:40

2 votes

Accepted

Where can SSISDB actually reside?

answered Jun 19, 2019 at 15:04

2 votes

Accepted

Why does setting my column as Always Encrypted change its collation from SQL_Latin1_General_CP1_CI_AS to Latin1_General_BIN2?

answered Jun 25, 2019 at 15:22

2 votes

SQL Server Always On Availability Group

answered Aug 16, 2019 at 23:02

2 votes

How to determine CHECK or NO CHECK for foreign Key using SQL Server System Tables

answered Aug 19, 2019 at 14:54

1 vote

Execute SSIS procedure from stored procedure using non-privileged SQL login

answered Jul 23, 2019 at 19:02

1 vote

Accepted

How to structure T-SQL query with many left joined "attributes"

answered Jun 19, 2019 at 22:33

1 vote

Accepted

SqlPackage.exe unnecessarily drops and recreates indexed view with schemabinding

answered Jun 6, 2019 at 14:26

1 vote

Why does this query, missing a FROM clause, not error out?

answered Jun 7, 2019 at 16:19

1 vote

Accepted

Get single records when duplicate records exist in 2 table

answered Jun 14, 2019 at 14:45

1 vote

Return rows that meet a condition in two different columns

answered Aug 16, 2019 at 18:54

1 vote

How to Exclude Foreign Keys during Publish action in sqlpackage

answered Sep 18, 2019 at 17:45

1 vote

Invoke-SQLCmd Date output format

answered Nov 10, 2019 at 19:41

1 vote

Temporarily Turn Off Table Type Reference Checking On A Development Database

answered Jun 23, 2020 at 14:26

Stack Exchange Network

53 Answers

Why is casting a DATE field to VARCHAR datatype non-deterministic and is there a way to make it deterministic?

What is the idiomatic solution in SQL Server for reserving a block of ids for use in a bulk insert?

how to list all features installed in a sql server instance?

Do table locks get released after a query finishes when WAITFOR is used after that query within the same batch and transaction?

Safeguard against infinite looping in case of missing FETCH NEXT

Truncate Table locking sys views

How to unpack a DACPAC?

Find jobs that succeeded, but had steps that failed

how to run SQL query without permission

Which server actually runs the SSIS package when SQL Agent and SSISDB are on 2 different servers

How to "normalize" external data before insertion into "Data Warehouse" like database?

Create a Hangfire job via SQL stored procedure

Should the T and L phase of a well tuned ETL report process take the same amount of time regardless of the time bucket width and data size?

How can I Switch-In or Switch-Out Partition where table has non storage aligned indexes on it?

SQL Server MCSA Database Administration Certification retires on June 30, 2020 - is there going to be a replacement?

Backup database on linked server

Asked to Not Use Transactions and to Use A Workaround to Simulate One

Where can SSISDB actually reside?

Why does setting my column as Always Encrypted change its collation from SQL_Latin1_General_CP1_CI_AS to Latin1_General_BIN2?

SQL Server Always On Availability Group

How to determine CHECK or NO CHECK for foreign Key using SQL Server System Tables

Execute SSIS procedure from stored procedure using non-privileged SQL login

How to structure T-SQL query with many left joined "attributes"

SqlPackage.exe unnecessarily drops and recreates indexed view with schemabinding

Why does this query, missing a FROM clause, not error out?

Get single records when duplicate records exist in 2 table

Return rows that meet a condition in two different columns

How to Exclude Foreign Keys during Publish action in sqlpackage

Invoke-SQLCmd Date output format

Temporarily Turn Off Table Type Reference Checking On A Development Database