Oh really, there ARE guys with deep insight into Microsoft SQL server. This notes absolutely look like a willing professional who did learn something new: http://blogs.technet.com/b/josebda/archive/2009/03/20/sql-server-2008-fragmentation.aspx But what about me? I am still looking for a course or material giving me the SQL Server architecture and logic in a way I can understand. At least […]
How to find out the (biggest) table size in MS SQL Server?
How to find out the (biggest) table size in MS SQL Server? To find the answer in your preferred search engine is difficult – not because there are no hits, but there is that lot of crap to see, it’s just unbelievable. If you don’t want to enjoy this experience, maybe have a look into […]
CREATE TABLE AS SELECT (CTAS) in MS SQL Server
In Oracle often we are using CREATE TABLE TABLE_B AS SELECT * FROM TABLE_A; But in SQL Server, this syntax does not work. Use SELECT * INTO TABLE_B FROM TABLE_A; COMMIT; instead. Hope this helps Martin […]
Oracle Performance Firefighting with Craig Shallahamer (Frankfurt, April 2011)
In early April, I had the honour to attend Craig Shallahamer’s Oracle Performance Firefighting and Advanced Performance Analysis courses. It was a great opportunity, since he came to Frankfurt which is just a three hours drive away. It was the second time meeting him – and it was great, again. The last two days have […]
Terrifying Execution Plan with cost of 18E (exa)
The newest piece of my bloomer collection is a query with an execution plan that has 18E of cost. I am no believer in absolute cost numbers, but this one is just nice. This exa-executionplan is the new definition of Exadata…. Keep your fingers off 😉 Usn […]
Glancing into MS SQL Server
I have not been able to blog for a while. My family has grown, and so there have been different priorities. In the meantime, I was told to become responsible for a few MS SQL Server databases as well. I took it for a challenge, and started digging into a different world. Well, sometimes different, […]
DOAG Konferenz 2010 – Look at’s
For the last three days, I have been in Nuremberg, attending the DOAG Konferenz 2010 (annual conference of the german Oracle user group). This year, my list of “Look at’s” is way shorter than last years list was. It’s not the fault of the event, I just did not write down that many facts. My […]
Oracle Database patch set 11.2.0.2 is out
For all who may concern 😉 Oracle 11.2.0.2 is out for Linux x86 and Linux x86_64 It’s patch set 10098816! Packaging: Starting with the first patch set for Oracle Database 11g Release 2 (11.2.0.2), Oracle Database patch sets are full installations of the Oracle Database software. In past releases, Oracle Database patch sets consisted of […]
Oracle ASM quote of the week
Please, do yourself a favour and NEVER EVER use ASM on Windows! “Dear Sir, obviously I forgot to put a file system on drives E:, F: and G: of the DB machine. I did this now, and hope you excuse the delay. Best regards John Doe Windows Server Administrator” /* no comment */ Martin […]
Oracle: Example schema for my DB lectures
This is my example schema, basis for the DB tuning lectures. Please use your “save as” function or copy the URI to use wget. expdp_klm1.dmp.bz2 expdp_klm2.dmp.bz2 Regards Martin Klier […]