Optimize Your SQL Server Queries with Column Statistics
Have you ever done something that your mother told you to never ever do? Well, we’re going to do that today, except with SQL Server. We’re going to get rid of SQL Server column statistics with the goal of learning what column statistics are and how they help SQL Server arrive at superior query plans. […]
How Much do SQL Server Data Professionals Make?
You’ve thought about your career, you can’t make up your mind about which direction you want to take it. You want to make an informed decision and work out if the career you chose will provide you with financial security you need. The good people at brentozar.com have been running a salary survey and the […]
How to Use the OPENROWSET Function to Read Text Files
Fayed, a student in Learning Tree’s Introduction to SQL Server, asked how to import text files into SQL Server. Quite a difficult question, actually, because there are many different ways. The hardest part is choosing the method that is best for the task at hand. Today we’re going to take a look at reading text […]
Oracle Vs SQL Server: Are They So Different?
Before Christmas I was asked to compare SQL Server against Oracle. So I thought that would make a good SQL Server versus Oracle post. Although I have thought about this over years as I have worked with clients that have had both SQL Server and Oracle, when you sit down to write down and convey […]
Save Time Writing T-SQL With Templates and Code Snippets
Time-savers are most important when you are busy – that seems obvious. The unfortunate irony is that when you are busy you cannot take the time to create them. The creation of time-savers drops to low priority the minute the rush is over. Well, today I am going to fight my natural laziness and create […]