Reputation
22,575
Next tag badge:
346/400 score
139/80 answers
Badges
2 26 71
Newest
 Necromancer
Impact
~1.2m people reached

2h
answered Searching SSIS packages for the use of specific tables
3h
comment Sending an automated email through a nightly job
how about when you use use db_name; select substring(PostOfficeBox,1,4)… or you can use db_name.schema_name.object_name ? Also, refer to avoiding the schema prefix - is not a good practice
10h
answered How to change location of SQL Server 2012 database which is already configured with a merge replication
15h
comment Transaction log bloat when writing to table on replicated database with parameterized filter
How are you updating the table .. one shot or in batches ?
1d
awarded  Necromancer
1d
comment No significant performance increase after migrating from SQL Server 2005 32bit 4 Cores 4 GB RAM to SQL Server 2012 64bit 4 Cores 32 GB RAM
This may be a duplicate of difference in execution plans on UAT and PROD server once the OP confirms.
1d
comment No significant performance increase after migrating from SQL Server 2005 32bit 4 Cores 4 GB RAM to SQL Server 2012 64bit 4 Cores 32 GB RAM
Look into trace flag 2335 . I faced similar problem due to more memory.
1d
comment Changes to the database schema are called migrations, what are data changes called?
Data manipulation operations ?
Jun
27
awarded  backup
Jun
26
revised Can I use a script to restore multiple SQL databases from .bak files?
edited tags
Jun
26
revised Create TRIGGER to insert after the insertion of specific value
edited tags
Jun
26
comment Can I use a script to restore multiple SQL databases from .bak files?
Agreed, I like the powershell version - especially sqlmigration is awesome when migrating 100's of databases from one server to another + it has other features like migrating logins, jobs, etc
Jun
26
answered Can I use a script to restore multiple SQL databases from .bak files?
Jun
26
comment Why my database mirror break down after changing file group settings from RESTRICTED_USER to MULTI_USER?
We do both type of backups that might be a problem. VM snapshots should not be used as an alternative to native sql server backups.
Jun
26
revised Reorganize Index Task
added 323 characters in body
Jun
26
answered Reorganize Index Task
Jun
26
comment Why my database mirror break down after changing file group settings from RESTRICTED_USER to MULTI_USER?
Error 823 with sev 24 is a hardware problem. Are you doing file level backups instead of native sql server backups or is any antivirus software running on the server ? You should put sql agent alerts to alert you when 823 error occurs - this script will help you. Also, 823 is a nasty error to get – it says that an I/O operation failed at the OS level and the I/O subsystem is causing corruption - sql server did not do page checsum
Jun
26
comment Why my database mirror break down after changing file group settings from RESTRICTED_USER to MULTI_USER?
Error: 823, Severity: 24 seems hardware problem. Check your DISKS to see if they have gone bad. Run checkdb on the databases to make sure they come clean.
Jun
26
awarded  Enlightened
Jun
26
awarded  Nice Answer