Sherpa of Data

Tag: SQLQuestions

  • Common Table Expressions Can Be A Good Thing

    —

    by

    Kevin
    in ,

    Most of our coding these days has Common Table Expressions, also known as CTEs. If not, you’re either working on an older version of SQL Server or you haven’t been introduced to this piece of goodness. CTEs can make reading SQL queries a lot easier if the logic is convoluted. For example, let’s use the…

  • Scrutinizing the Data in All of our tables

    —

    by

    Kevin
    in

    Today, I was working with SQL Server to get row counts from several tables so I thought I’d be smart and work with some functions in SQL Server to make it smarter / easier. Now, if I am truly only getting “straight” row counts from these tables, I would be able to create a query…

  • Transactions should (never) be distributed

    —

    by

    Kevin
    in

    For the last few blog posts, we’ve been talking about transactions. If you’ve missed any, be sure to click on the links below: Using Save Points with Transactions to Get Better How about we TRY and CATCH some Transactions? Setting up a Friendly TRANSACTION In the version of transactions that we going to discuss today,…

  • Using Save Points with Transactions to Get Better

    —

    by

    Kevin
    in

    When we last conversed, we talked about the TRY/CATCH block and how it works with transactions. If you somehow missed that, you can read about it here – How about we TRY and CATCH some Transactions? We’ll wait for you… All right, now that everyone’s back with us, we’ll talk more about everyone’s favorite –…

  • How about we TRY and CATCH some Transactions?

    —

    by

    Kevin
    in

    In our last post, we started talking about transactions and how they can help your databases have data integrity. Let’s continue that today with our friends TRY and CATCH. TRY is just telling SQL Server that we want to try out something. CATCH tells SQL Server what to do if it completely messes up. We…

  • Setting up a Friendly TRANSACTION

    —

    by

    Kevin
    in

    The last time we were together, I discussed DCL and TCL. That post ended with a quick paragraph on transactions and how they can help with data integrity. Today, I want to go more in-depth on this very important topic. Transactions always – and I do mean always – start with the phrase BEGIN TRAN.…

  • Accessing and Transacting Languages in SQL Server

    —

    by

    Kevin
    in

    Over the last few posts, we’ve discussed DDL and DML. This week I want to actually discuss the other 2 types of languages with SQL Server – DCL and TCL. DCL is the Data Control language. These are the commands that give security permission to a person – or group – to get things done.…

  • How to Define objects

    —

    by

    Kevin
    in

    In my last post, I discussed some of the DML commands in SQL Server. This week I want to discuss another category of commands – Data Definition Language, or DDL. DDL is used to define or redefine the structure of the database. The commands that are used for DDL are as follows: CREATE DROP ALTER…

  • Unique Categories of Commands within SQL

    —

    by

    Kevin
    in

    For a while now, I’ve been talking about specific functions used within SQL Server. For example, I’ve talked about DATALENGTH, REPLICATE, and STUFF, along with many others. And all that is great and should be known if you work with SQL Server on a regular basis. But today, I want to talk about the different…

  • Grouping Items in Such A Way

    —

    by

    Kevin
    in

    Last time, we were able to go over a way to group data that is probably not familiar to many. This time, I want to go over an extra piece to that puzzle that should add even more functionality to your repertoire when it comes to data functionality. First, we have the basic query that…