How many DB professionals have never had to deal with bitwise operations in SQL Server? Who has never had a single value in the database represent more than one data value? Have you ever had […]
Tag: SQL
T-SQL Tuesday #016: Aggregates and Statistics
For my data analysis and trending, I wanted to find a simple distribution across quartiles.
March SSSOLV Reminder
This is just a quick reminder about the meeting coming up on March 10, 2011 at 6:30 PST. You can find more information about the event from here. I am looking forward to this presentation. […]
Re-purpose my TableSize Script
Last Year I introduced a couple of scripts that I worked on. Those scripts developed into a series covering the comparison of some methods and MS provided stored procs that could help you in the […]
S3OLV March 2011
The Ides of March are upon us and that means that we have another opportunity to learn some stuff about SQL Server. We have that opportunity because it is time for the monthly S3OLV User […]
Delimiting Results
Recently, I came across the need to delimit some data in order to be able to test some procedures that I was writing. The procedures need to be able to take a delimited string and […]
Memory Consumed By SQLServer
Have you wondered how much memory was being consumed by SQL Server? Have you wondered if there was a way to find out that information from a tSQL command? On occasion it would be nice […]
Finding Compressed Tables
Have you been working with compression? Have you inherited a database that may or may not have some tables compressed? On occasion you may want to know what the compression type being used on a […]
SQLServerPedia Blogger Awards
Several moons ago I learned that I had won one of the categories for the 2010 SQLServerpedia Blogger Awards. You can read about that here. Of all of the promises made in that post, I […]
Immersion in Internals
Paul Randal (Blog | Twitter) and Kimberly Tripp (Blog | Twitter) of SQLSkills are hosting an Immersions training event in Dallas. This is not run of the mill training, but it is top tier training targeted to […]