Andrew P | SQLServerCentral

Andrew P

Forum Topics Started

Viewing 15 topics - 1 through 15 (of 23 total)

Topics

Posts

Last post
Data Warehouse automation tool suggestions?

11 replies

1 year, 2 months ago

By: cyrusbaratt
Why do some DBAs avoid DATETIME2?

24 replies

3 years, 2 months ago

By: Jeff Moden
Need help resisting falling back to dimensional/snowflake schemas

5 replies

4 years, 3 months ago

By: Andrew P
Data modelling: how do you handle child records when doing a soft-delete?

10 replies

6 years, 1 month ago

By: Sergiy
Rolling back SELECT query took hours, used high CPU and very low disk. I couldn't see why.

2 replies

7 years, 1 month ago

By: Eirikur Eiriksson
Is my avoidance of UPDATE/DELETE CASCADE on foreign key relationships valid?

3 replies

7 years, 6 months ago

By: Andrew P
Should I listen to this recommendation to change data lengths for consistency during ETL?

6 replies

7 years, 8 months ago

By: Jeff Moden
Request for sanity check of basic ETL process and database placement

5 replies

7 years, 9 months ago

By: Chris Harshman
Any situations where a ROLLBACK won't rollback changes against a linked server

2 replies

7 years, 11 months ago

By: Andrew P
Request for review of Star schema design

5 replies

8 years ago

By: Chris Harshman
Advice on how to repair significant database corruption without a recent good backup

7 replies

8 years ago

By: Andrew P
How do you pseudo-code/flow-chart/map existing SQL code?

10 replies

8 years, 10 months ago

By: Orlando Colamatteo
Preference of LEFT JOIN <table> WHERE ... IS NULL vs. NOT EXISTS ( ... )

4 replies

9 years, 2 months ago

By: Gail Shaw
All permutations of a single string

2 replies

9 years, 3 months ago

By: Phil Parkin
Beginner - Star schema - Date dimension lookup from Customer dimension

5 replies

9 years, 4 months ago

By: Alvin Ramard

Viewing 15 topics - 1 through 15 (of 23 total)