Reputation
5,121
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
2 18 43
Impact
~584k people reached

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
Jan
7
comment Stored procedure not running on the same database when using different login
Check the default database assigned to each login and/or make sure you are specifying the correct database when connecting. Do you have this stored procedure in more than one place? Did you by chance accidentally create a copy of it in Master?
Jan
5
revised Float datatype with 2 digits after decimal point
changed "leading" to "trailing" zeros
Dec
20
reviewed Approve Help with query to find intersection between arbitary rows of a table under conditions
Dec
8
reviewed Approve anemometer tag wiki excerpt