Reputation
5,181
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
2 20 44
Impact
~636k people reached

2d
awarded  Popular Question
Apr
24
awarded  Yearling
Apr
11
awarded  Notable Question
Mar
21
comment Query All Databases Listed In Table
I might be getting a big jaded in my old age, but we scream not to build databases this way but people still do. Then they asks us to help them with querying these badly designed databases.
Feb
5
comment Unable to create restore plan due to break in LSN chain
can you explain what exactly this problem with the Microsoft products? In my experience the problem is always that there was a mysterious backup being taken, usually by a scheduled process in a VM environment.
Feb
4
comment What is the correct way to rename/swap a table in production
The three step approach you are using is one I have used successfully in the past. Make sure you do this when there are no other processes using the tables, and you should have no problem.
Feb
4
comment What is the correct way to rename/swap a table in production
What errors are being generated? Can you post the DDL of both tables? Seems to me that there is either a column name difference or a datatype difference.
Feb
3
comment How to split a wide table in Production?
This is the problem encountered when tables are not normalized to begin with. I don't envy your position.
Feb
3
reviewed Approve Connect MySQL workbench with MySQL container
Jan
14
comment Is it possible to backup and restore part of a database in sql-server?
I suggest changing this newly restored database to simple recovery model. msdn.microsoft.com/en-CA/library/ms189272.aspx
Jan
12
reviewed Approve clojure tag wiki
Jan
12
reviewed Approve clojure tag wiki excerpt
Jan
12
reviewed Approve sqlnet tag wiki
Jan
12
reviewed Approve sqlnet tag wiki excerpt
Jan
8
reviewed Approve db2-10.5 tag wiki excerpt
Jan
8
reviewed Approve microsoft-mds tag wiki excerpt
Jan
8
reviewed Approve wiredtiger tag wiki
Jan
8
reviewed Approve microsoft-mds tag wiki
Jan
8
reviewed Approve db2-10.5 tag wiki
Jan
8
reviewed Approve wiredtiger tag wiki excerpt