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
2 votes

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

0 votes

Multiple instance in one server

0 votes

Rollback a transaction using single thread/multi thread

0 votes

Tunneling SQL queries through central server

0 votes

Network connect to a local IP address from a static global IP address?

4 votes
Accepted

Safeguard against infinite looping in case of missing FETCH NEXT

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
Accepted

Create a Hangfire job via SQL stored procedure

1 vote

Spinning multiple environments from single backup file

2 votes

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

0 votes
Accepted

How to set a flag in SQL, when there is a change in value

2 votes

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

3 votes

how to run SQL query without permission

1 vote

Providing SQL access to flat file (proprietary) database

1 vote

Temporarily Turn Off Table Type Reference Checking On A Development Database

2 votes
Accepted

Backup database on linked server

1 vote

Except command doesn't work in SQL

1 vote
Accepted

Does temp table in sql-server support where clause?

0 votes
Accepted

Displaying only 1 row for each distinct value

2 votes
Accepted

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

3 votes
Accepted

How to unpack a DACPAC?

0 votes
Accepted

Replace " " character derived column SSIS

1 vote
Accepted

Does MSSQL Server need more space than the size of the data itself for importing? How much more?

1 vote

MS SQL 2008 R2 - How to use a production database through dev/test environments or how to copy a SQL schema and all its data to another

1 vote
Accepted

Pattern for copying hierarchical data from one table to another?

6 votes
Accepted

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

27 votes
Accepted

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

1 vote

How do you generate a build script for all views

0 votes

Keeping data in old Database (SQL 2008) identical to new Database (SQL 2016)?

1 vote

How to pass parameter value for ExecuteReader() - powershell