4,079 reputation
11631
bio website
location
age
visits member for 3 years, 4 months
seen 41 mins ago

Huge fan of SQL Server, I've been searching for opportunities to work on more MSSQL projects which is why I'm here.

I have been working in mixed environments with a combination of MySQL, PostgreSQL, LDAP and SQL Server for the past 15 years.


Mar
25
awarded  Notable Question
Mar
13
accepted Efficently Remove 90% of a table's data
Mar
12
comment Efficently Remove 90% of a table's data
@MarkSinkinson, thanks, a leftover from when I was just trying the SELECT
Mar
12
revised Efficently Remove 90% of a table's data
deleted 8 characters in body
Mar
12
comment Efficently Remove 90% of a table's data
Hello @AaronBertrand, updated my answer with my best effort so far. Works in my test environment, but is it what you had in mind?
Mar
12
revised Efficently Remove 90% of a table's data
added 728 characters in body
Mar
12
comment Efficently Remove 90% of a table's data
@AaronBertrand Tunnel vision, what else?
Mar
12
comment Efficently Remove 90% of a table's data
@AaronBertrand, except its 10% of an ordered table, so its not just the 10% I need, but 10% ordered by "column" in descending order
Mar
12
comment Efficently Remove 90% of a table's data
Hello @AaronBertrand, could you show me what you mean by your first suggestion? "calculate the number of rows that make up 10% beforehand, and then compare that in your batch"
Mar
12
asked Efficently Remove 90% of a table's data
Mar
9
awarded  Popular Question
Mar
3
awarded  Popular Question
Feb
12
comment DBCC SHRINKFILE EMPTYFILE not emptying
Looks like increasing the size of the other database files by 1GB solved the problem. I will post the answer in a few days.
Feb
12
awarded  Nice Question
Feb
11
asked DBCC SHRINKFILE EMPTYFILE not emptying
Feb
5
answered DB backups for production to DR without creating jobs in prod
Feb
4
accepted PostgreSQL duplicate key violates unique constraint error
Feb
4
accepted Create temporary tables per session in a DB other than tempdb
Feb
3
asked Update Linked Server Provider
Jan
23
comment Why won't pg_basebackup output go to log?
Hello @Phil, updated my answer