End of March, I had a chance to dig a bit deeper into MS SQL Server analysis. The german chapter of PASS (http://www.sqlpass.org) organized one of their “Essentials”, a condensed training day with a specific topic. This one was named “SQL Server Analysis” and was held by Andreas Wolter (MCSM) in Nuremberg. Here comes my […]
Category: SQL Server
Microsoft SQL server fragmentation and reorganization
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 […]
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, […]