Reputation
215
Top tag
Next privilege 250 Rep.
View close votes
Badges
1 4 10
Impact
~23k people reached

  • 0 posts edited
  • 0 helpful flags
  • 13 votes cast
Jul
27
awarded  Notable Question
May
24
awarded  Famous Question
Jan
28
comment Fencing a failed application node to isolate it from SQL Server
@JohnM That's a possibility for preventing new connections from the failed application node to SQL Server, but I don't think it would prevent the failed application node from writing to the database over any existing open connections.
Jan
28
comment Fencing a failed application node to isolate it from SQL Server
@JohnM I just edited the question to clarify that I am referring to the health of the application nodes only, not any of the node(s) that may be hosting SQL Server. I am not aware of any features of AG/FCI that would allow me to isolate specific application nodes.
Jan
28
revised Fencing a failed application node to isolate it from SQL Server
added 54 characters in body
Jan
28
asked Fencing a failed application node to isolate it from SQL Server
Sep
3
awarded  Popular Question
Sep
1
awarded  Yearling
Jul
21
awarded  Nice Question
Jun
30
awarded  Notable Question
Dec
17
awarded  Notable Question
Nov
14
comment Speed of one big insert vs multiple small inserts on SQL Server
I tried some of Aaron's suggestions and the difference in performance between inserting one large record into a single table and inserting four smaller records into four different tables fell to 10-20%.
Nov
14
comment Speed of one big insert vs multiple small inserts on SQL Server
@AaronBertrand Thanks, very helpful. I'll see if it runs any faster with the tables allocated to filegroups on different disks.
Nov
14
comment Speed of one big insert vs multiple small inserts on SQL Server
@AaronBertrand, I edited my question to add more detail about the way I did my testing. While I did consider transactions, I did not collect wait stats or check log growth events.
Nov
14
revised Speed of one big insert vs multiple small inserts on SQL Server
added 1236 characters in body
Nov
14
asked Speed of one big insert vs multiple small inserts on SQL Server
Oct
17
awarded  Popular Question
Jul
27
comment How can I “shift” certain column values to different rows in an existing table?
Ah, that makes sense now. As an aside, my actual CTE query was working, but it was because I had aliased the SlotId column in the subquery so it was no longer ambiguous. I just failed to include that detail in the simplified version of the query that I posted here. And thanks for the more efficient version of the query.
Jul
27
accepted How can I “shift” certain column values to different rows in an existing table?
Jul
27
revised How can I “shift” certain column values to different rows in an existing table?
deleted 675 characters in body