Last night, I was sitting at home with my husband, when I got an ominous message from Aaron Bertrand (blog|twitter): You up? I’m about to blog about you. You’ve been warned. ~ Aaron Bertrand Uhhh…. OK? It was 10:30 on a Friday night. I was … [Read More]
Question I just executed a query that went pretty fast and the SQL Profiler said it used 30.000 reads. Now I’m looking at this page: https://cloud.google.com/compute/docs/disks/performance and see that a standard persistent disk has 3000 reads IOPS. Does that mean that my query would take … [Read More]
It’s T-SQL Tuesday, the blog party that SQL Server expert Adam Machanic (blog|twitter) started. This month’s episode is hosted by Kenneth Fisher (blog| twitter). The topic: Backup & Recovery Your backups are my bread & butter Backup & recovery are a DBA’s bread & butter. I always tell people that … [Read More]
Question I need 1100 columns in a single table.I already have 928 columns in same table, now I need to add new 150 columns. I know SQL Server allow maximum 1024 columns. Now I will not create new table. If I create new table and … [Read More]
Copyright © 2024 | Andy Mallon | am2.co