Login or Sign Up to become a member!
LessThanDot Site Logo

LessThanDot

A Technical Community for IT Professionals

Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.

Browsing "performance"

0

A Custom Jasmine Runner to find my slowest Specs

I’ve been playing around lately with a pure command-line Jasmine runner that doesn’t rely on a SpecRunner file to run tests. I work daily with a largish application that is well over 100K lines of front-end code and greater than 7000 front-end tests. Over time as the codebase and test count has grown, our Continuous […]

Read More...
11

Solving a slow running query issue with UNION

That’s right! I will solve a performance issue by adding a UNION into the query. Interested? Read on! I recently encountered a curious issue with a query. The query itself wasn’t exactly rocket science: it read data from a few tables and calculated the start and the end dates of a contract in the SELECT […]

Read More...
2

SSIS Performance Testing

I had to do some performance testing for an upcoming MSSQLTips article and I thought I’d share the framework I used in a blog post. First of all we have to log start and end dates of the package to a table so we can easily calculate the duration a package took to finish. This […]

Read More...
0

T-SQL Tuesday #46: Rube Goldberg Machine

 

 
It’s the second Tuesday of the month, and you know what time it is! That’s right, another installment of T-SQL Tuesday which is hosted this month by Rick Krueger (blog | twitter). The topic is about that one time we did a hack to get something s…

Read More...
2

Wrap inserts in a transaction for faster performance

Sometimes you have to insert a bunch of data and you can’t use BCP or another bulk load method. When you do single row inserts, SQL Server wraps these inserts inside an implicit transaction. Did you know that if you use an explicit transaction that the…

Read More...
0

SQL Advent 2012 Day 21: With VLDBs it matters what you do and how you do it

This is day twenty-one of the SQL Advent 2012 series of blog posts. Today we are going to look at Very Large Databases

Read More...
0

SQL Advent 2012 Day 15: Benefits of Indexes

This is day fifteen of the SQL Advent 2012 series of blog posts. Today we are going to look at indexes

Read More...
1

SQL Advent 2012 Day 2: Data types storage differences

SQL Server has two data types to store character data, both of them come in fixed and variable length sizes. The char and varchar data type uses one byte of store to store one character, the nchar and nvarchar data type uses two bytes of store to store one character. The nchar and nvarchar data types are used to store unicode of data

Read More...
0

Latest article by SQL Server MVP Erland Sommarskog is a gem

SQL Server MVP Erland Sommarskog has posted his latest article yesterday and I highly recommend printing it out/transferring it to your ebook reader and reading it.
Of course I think most of you are already familiar with Erland’s article The curse and…

Read More...
3

First glance at the new Red Gate SQL Monitor

My first glance rating of SQL Monitor (1 to 5) is a solid 4. That is extremely high for me as I am hard on tools like this and the footprint they leave on my systems. As such, this monitoring tool as replaced my others and taken the spotlight as my primary tool to use. Cost + functionality + value make this a winner. The post on the footprint SQL Monitor leaves is the winning factor so look for it soon.

Read More...
Next Page »