THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » t-sql » sql server   (RSS)
Showing page 1 of 6 (54 total posts)
  • For the Better Developer: When indexes are not enough

    Another month, another session for the PASS Application Development VG. This time I will be both the host and the guest :), talking about something is very close to my interests and, I think, also a key point for any developer to have success in future of AI. Here’s the session title and abstract: For the Better Developer: When indexes are not ...
    Posted to Davide Mauri (Weblog) by manowar on October 3, 2017
  • PASS SQL Saturday #687 Slovenia 2017

    Here we go for the fifth time! The leading event dedicated to Microsoft SQL Server in Slovenia, PASS SQL Saturday #687, will take place on Saturday, December 9th 2017, at the Faculty of Computer and Information Science of the University of Ljubljana, Večna pot 113, Ljubljana (https://www.fri.uni-lj.si/en/about-faculty/how-to-reach-us). This is ...
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on July 11, 2017
  • How to calculate barcode check-digit using T-SQL language

    Introduction In order to scale, it's imperative that companies stay ahead of competition. So how can they identify, store, manage and deliver goods to customers efficiently? The answer is: Barcode! A barcode is the graphical representation of a sequence of numbers and other symbols. The representation is made by lines (bars) and spaces. A barcode ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on June 23, 2017
  • SQL Server 2016 Developer’s Guide

    I can proudly announce that it is already possible to preorder the SQL Server 2016 Developer’s Guide book (https://www.amazon.com/SQL-Server-2016-Developers-Guide-ebook/dp/B01MS5L01Q/ref=sr_1_20?ie=UTF8&qid=1488533994&sr=8-20&keywords=SQL+Server+2016). This is the 14th book I authored or coauthored This time, my coauthors are Miloš ...
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on March 3, 2017
  • The biggest table in your database

    You may need to know which is the biggest table (in terms of disk space usage) in the database that you are currently connected. Sometimes, this information is very useful to check the indexing strategy of these tables. There are several methods to know which is the biggest table of a database, one of these methods is to use the standard ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on February 11, 2016
  • Snapshot Isolation Level and Concurrent Modification Collisions - On Disk and In Memory OLTP

    This is part 1 of my In Memory OLTP blogs for my upcoming book project. In this blog I want to take a (reasonably) quick look at how concurrent modifications are handled using SNAPSHOT isolation level. There are two different flavors of SNAPSHOT Isolation level you can deal with, and while they are similar, there are some very big differences ...
    Posted to Louis Davidson (Weblog) by drsql on August 13, 2015
  • SQL Formatting Matters…

    … to some folks more than others. We likely all have stories about working with folks who care a lot about the format of their SQL statements. I’ve worked with a lot of database developers and analysts. I cannot say SQL formatting distinguishes the good from the bad (or ugly), but I have noticed the sharpest developers have a preferred SQL ...
    Posted to Andy Leonard (Weblog) by andyleonard on July 20, 2015
  • Off to Richmond for SQL Saturday

    I got the email prodding speakers to blog about our upcoming sessions, so I got myself up and started to write this blog. It has been such a long time since I have done much side SQL work (other than doing quite a bit of tech editing, along with doing some work for PASS leading up to speaker submissions), that my blog didn't even show up in the ...
    Posted to Louis Davidson (Weblog) by drsql on March 13, 2015
  • Capturing query and IO statistics using Extended Events

    The commands SET STATISTICS TIME ON SET STATISTICS IO ON   return information about query executions and are very useful when doing performance tuning work as they inform how long a query took to execute and the amount of IO activity that occurred as a result of that query. These are very effective ...
    Posted to Jamie Thomson (Weblog) by jamiet on March 5, 2014
  • First release of my own personal T-SQL Code Library on github

    Like many (most???) T-SQL developers I keep a stash of useful code that I’ve garnered down the years because I know its all going to come in useful at some point in the future. It includes code I’ve written myself and also code that others have shared on their own blogs. For example my code library includes the following: vwdiskfileLatency – ...
    Posted to Jamie Thomson (Weblog) by jamiet on January 12, 2014
1 2 3 4 5 Next > ... Last »
Privacy Statement