Reputation
2,748
Top tag
Next privilege 3,000 Rep.
Cast close & reopen votes
Badges
5 20
Newest
 Caucus
Impact
~66k people reached

6h
awarded  Caucus
Jul
24
reviewed Approve Custom big key-value database indexing
Jul
7
comment should we keep the log file or the data file on the fastest drive?
@AaronBertrand agreed. Thanks for pointing it out
Jul
7
answered should we keep the log file or the data file on the fastest drive?
Jul
6
revised how to create trigger in SQL server using two tables to find stock quantity
added 341 characters in body
Jul
6
answered how to create trigger in SQL server using two tables to find stock quantity
Jul
3
comment My SQL Server table identity is incrementing way too fast
You could use a MERGE statement to insert your rows or check if the row exists with INSERT SomeTable SELECT FROM Values WHERE NOT EXISTS (SELECT FROM SomeTable WHERE condition)
Jul
3
revised My SQL Server table identity is incrementing way too fast
added 40 characters in body
Jul
3
revised My SQL Server table identity is incrementing way too fast
Added example
Jul
3
answered My SQL Server table identity is incrementing way too fast
Jul
1
comment Rollback Committed transaction in SQL Server
I advise against this solution as the primary way to solve the issue. It's unsupported and won't work if the log has been truncated. Restoring the database up to the point of the unwanted transaction is supported and guaranteed to work, so why bother messing with undocumented stuff?
Jul
1
answered Rollback Committed transaction in SQL Server
Jul
1
comment RAM utilization
@Jmaurier brentozar.com/archive/2011/09/…
Jul
1
comment RAM utilization
Task Manager is the worst way to determine SQL Server's RAM usage. Use the performance counter "Total Server Memory (Kb)" instead.
Jun
26
revised SQL Server : trigger FOR DELETE
Corrected the code to allow working with multiple rows at once
Jun
25
comment Need Review - Index Rebuild and Index Reorganize strategy?
Why re-invent the wheel when there's Ola Hallengren maintenance solution? ola.hallengren.com
Jun
25
answered INSERT [TableName] SELECT * FROM [TableName]
Jun
24
answered Replication with two publishers
Jun
24
comment SQL Server : trigger FOR DELETE
Also, don't forget to add SET NOCOUNT ON at the top of the trigger body, otherwise many providers will complain about @@ROWCOUNT being altered by the trigger code.
Jun
24
comment SQL Server : trigger FOR DELETE
This syntax will work only when you delete a single customer, it will fail when you try to delete multiple rows at once. Change customer.ID = to customer.ID IN