Piotr Palka's user avatar
Piotr Palka's user avatar
Piotr Palka's user avatar
Piotr Palka
  • Member for 4 years, 10 months
  • Last seen more than a week ago
27 votes
Accepted

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

14 votes
Accepted

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

6 votes
Accepted

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

4 votes
Accepted

Safeguard against infinite looping in case of missing FETCH NEXT

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?

3 votes

Truncate Table locking sys views

3 votes

Find jobs that succeeded, but had steps that failed

3 votes
Accepted

How to unpack a DACPAC?

3 votes

how to run SQL query without permission

2 votes

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

2 votes
Accepted

Backup database on linked server

2 votes
Accepted

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

2 votes
Accepted

Where can SSISDB actually reside?

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?

2 votes

SQL Server Always On Availability Group

2 votes

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

2 votes
Accepted

Create a Hangfire job via SQL stored procedure

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?

2 votes

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

2 votes

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

2 votes

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

1 vote

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

1 vote
Accepted

Get single records when duplicate records exist in 2 table

1 vote
Accepted

SqlPackage.exe unnecessarily drops and recreates indexed view with schemabinding

1 vote

How do you generate a build script for all views

1 vote

Temporarily Turn Off Table Type Reference Checking On A Development Database

1 vote

When possible, are clustered indexes that are declared as unique more performant than clustered indexes that aren't declared as unique?

1 vote

Spinning multiple environments from single backup file

1 vote

Do I still need to disable or drop column store index before insert and/or update on big tables?

1 vote

Invoke-SQLCmd Date output format