Reputation
2,628
Top tag
Next privilege 3,000 Rep.
Cast close & reopen votes
Badges
5 19
Impact
~61k people reached

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
Jun
24
awarded  Citizen Patrol
Jun
24
answered SQL: Find row number with column entry of a specific string
Jun
24
answered SQL Server : trigger FOR DELETE
Jun
22
answered SQL Server 2012 - How to Remove Partition on Publisher but not Subscriber?
Jun
22
comment SQL Server 2012 - How to Remove Partition on Publisher but not Subscriber?
Which type of publication? Merge? Transactional?
Jun
22
answered Performing Backup in 2 different ways in parallel?
Jun
18
comment Should I use ReFS for a new SQL Server
ReFS appears to be slower than NTFS at the moment swasheck.wordpress.com/2014/12/18/…
Jun
18
comment Passing DataTable using SqlBulkCopy
It depends on the type of source and destination columns. Please expand your question with relevant information.
Jun
17
comment Error creating database on new storage in SQL Server 2008 R2 Failover Cluster
Have you tried tracing sqlservr.exe with ProcMon? Maybe some more info is available there.
Jun
17
comment Post installation of SSIS for existing SQL Server instance with different build versions
The issues with SP1 were just affecting the SP installer itself and not the fixes shipped with it. The rumors you're referring to just rumors. SP1 CU1 is already in the works and will be realeased shortly.
Jun
17
comment Post installation of SSIS for existing SQL Server instance with different build versions
Does any of the fixes in CU7 not in SP1 really affect SSIS in your project? If not, there's no point in installing CU7.
Jun
15
reviewed Approve Pivot in SQL Server 2000
Jun
15
comment Computed Columns Or Views - Database Table Design
@devSuper I added a view + trigger example
Jun
15
revised Computed Columns Or Views - Database Table Design
Improved with example