To CTE or not to CTE, that is the Question So my post really has nothing to do with the title. This is not a post to help you determine whether a CTE is appropriate […]
Category: TSQL Tuesday
T-SQL Tuesday #17 – APPLY Knowledge
We have another opportunity to write as a part of TSQL Tuesday today. This month Matt Velic (Blog | Twitter). Matt has proposed a challenge that was derived from a comment on twitter. The challenge […]
T-SQL Tuesday #016: Aggregates and Statistics
For my data analysis and trending, I wanted to find a simple distribution across quartiles.
T-SQL Tuesday #15 DBA Automaton
Often, we hear about DBA’s automating everything under the sun. Why? It simplifies the job and creates time to work on other projects.
TSQL Tuesday 14: Committed
For this TSQL Tuesday post, I will just add a short list of my professional goals for this next year. Otherwise, this post would be mostly about my non-professional goals.
T-SQL Tuesday #13 – Business Requirements
I think a common area that is easily overlooked when it comes to requirements and interpretation of requirements is report creation. A common problem is that there are no defined or written requirements for the creation of a report.
T-SQL Tuesday #012 – Skills
November is upon us and in some areas this also means that the leaves have changed color. With the change in leaves we also have a change in TSQL Ones…err Tuesday this month. The change […]
A Haunting TSQL Tuesday Tale
If you truncate a table, you cannot undo the action like you can with a delete. What is the difference between the two methods to remove data from a table?
October 2010 TSQL Tuesday Reminder
Holy Cow, another month has flown by without much of a hint. We now have upon us another TSQL Tuesday. If you hadn’t heard or haven’t seen the twitter announcement, you can find it […]
TSQL Tuesday Indexes and Blobs
How does one find what columns were LOB columns in the database. I knew I had some past blog posts about various aspects of LOBs, but I had never broken it down to find the columns in the LOB. Even better was that I wanted to know what columns were in what index that were also a BLOB.