368 reputation
1312
bio website members.virtualtourist.com/m/…
location Marbella, Spain
age 37
visits member for 1 year, 11 months
seen 2 hours ago

Developer, SQL addict, trying to get insights of DBA tasks, mountainbiker


Apr
4
comment Using CHECKSUM on where clause
Was reading the SO answer about collisions, and you also mentioned it, so now my bet on why it was used goes for one of the 2 last points.
Apr
4
accepted Using CHECKSUM on where clause
Apr
4
comment Using CHECKSUM on where clause
Thanks @AaronBertrand, this was more or less my guessing. If you added as answer will check it.
Apr
4
revised Using CHECKSUM on where clause
added 184 characters in body
Apr
4
comment Using CHECKSUM on where clause
Person long ago not on the team, code is from 2010, I already asked around, no one has a clue.
Apr
4
asked Using CHECKSUM on where clause
Mar
21
asked Permissions required for running extended events
Mar
14
comment Update Statement takes forever to complete
Maybe my answer to another question couple days ago can help you.
Mar
12
answered What are the most effective techniques to reduce SQL Server disk space use when updating all rows in a very large table?
Mar
10
asked Timestamp on SSIS update on tsql
Mar
7
answered SQL Script to Drop old AD logins, Inactive SQL Logins and all related Users
Feb
28
comment SSD vs HDD for databases
The article you are linking to is almost 4 years old, prices of SSD compared to that moment in time are more than half less and performance has increased a lot too. Memory the size of the database? What about about 500Gb database? Is not only the quantity of RAM but also the server you need to buy that has so many memory banks available.
Feb
25
revised Optimising an Update statemement with a very large Where clause
code formatting
Feb
25
revised Optimising an Update statemement with a very large Where clause
improved code formatting
Feb
25
suggested suggested edit on Optimising an Update statemement with a very large Where clause
Feb
25
suggested suggested edit on Optimising an Update statemement with a very large Where clause
Feb
23
comment UPDATE table with another table data
+1 just for using Paint on a Sunday morning
Feb
22
comment Capture very expensive queries
My vote to Adam Machanic's solution too, is very effective and tons of people are using it so it's fully tested and approved by the community.
Feb
20
comment Free space from image column after update
Yes, as I commented on the question, when I made a backup from the newly cleanedup database the difference was appreciable. But when I restored back the database, the sp_spaceused didn't changed. I've read a lot about the detriments of shrinkdatabase and shrinkfile on data files. But as this is a dev database, running these commands shouldn't be that harmful, or yes?
Feb
20
awarded  Citizen Patrol