|
|
|
|
Latest Blog Posts
-
|
What happens when NUMA affinity meets query parallelism? It gets no respect! SQL Server allows you to affinitize a TPC port to a specific NUMA node or a group of NUMA nodes. Books Online has an article on How to: Map TCP/IP ports to NUMA Nodes . And this...
|
-
|
I know people have been doing all sorts of things with T-SQL, and I have absolutely no issue with people trying to push the limit of what T-SQL can do, or what you can use it to accomplish, especially when it’s for demonstration or pedagogical purposes,...
|
-
|
I see a lot of people suggest while loops instead of cursors in situations where row-based processing is required (or, at least, where folks think that row-based processing is required). Sometimes the justification is that constructing a while loop is...
|
-
|
When you create a PowerPivot workbook or a BISM Tabular model (new in Analysis Services 2012), you store data by using the VertiPaq engine, which is an in-memory columnar database. Instead of considering the row of a table as the main unit of storage,...
|
-
|
Test-Driven Development (TDD) is a software development practise that has been around for a few years. Wikipedia describes it as: Test-driven development (TDD) is a software development process that relies on the repetition of a very short development...
|
-
|
Be careful: unlike most other languages, T-SQL does not limit variables' scope to the block where the variable has been defined. For example, the following snippet compiles and runs: -- @to is not in scope yet -- the line below would not compile --SET...
|
-
|
A new personal blog post: Discerning Between Noisy and Important...
|
-
|
In April 2010 Twitter announced a new feature that they would soon be introducing - Twitter Annotations. Put simply Twitter Annotations can be described as the ability to attach metadata to a tweet; think hashtags on steroids. Lots of people were quite...
|
-
|
We are told that SQL Server 2008 R2 Audit (and SQL Server 2008 Audit) has much less performance overhead than SQL Trace when we try to capture the same information. Knowing how SQL Server R2 Audit is implemented (i.e. on top of the extended events infrastructure),...
|
-
|
I recently joined a software development project that involves not only myself and other internal Microsoft employees, but a partner and a customer as well. We are building a hybrid solution that uses assets on premises as well as Windows Azure for processing....
|
-
|
I see a lot of people getting really excited. There is a "virtual launch event" for SQL Server 2012 being held on March 7, 2012. You can read more about the event at http://sqlserverlaunch.com/ . Let me throw out a dose of reality: if you are not on a...
|
-
|
This one is quite subjective, and I'm sure I will face plenty of opposition - not only because it's a preference thing and many people are married to their preferences, but also because it violates the strict interpretation of the standard. Personally,...
|
-
|
If you have Chinese friends, it's time to say 新年快乐 to them! (Xīnnián kuàilè -> Pronounced like Shin Nien Kwai Ler) They are welcoming in the year of the dragon....
|
-
|
I am honored to present Building Your First SSIS 2012 Package to the Madison Professional Association for SQL Server (MADPass) Wednesday, 25 Jan 2012! If you read this blog and will be in the Madison, Wisconsin area Wednesday, stop by and introduce yourself!...
|
-
|
Recently, I have been looking into the performance impact of enabling hyperthreading on various platforms with various SQL Server workloads. All the results I have shared so far are from a DL580 G7 with four Westmere-EX (E7-4870) processors. Overall,...
|
-
|
Is your SQL Server running slower than you’d like? Is it your SQL Server configuration or your slightly old hardware? We need to use tools to gather information. My subjective impression is that my 2.2 GHz laptop outperforms my 3.0 GHz overclocked desktop...
|
-
|
My favorite blog post Picking favorites is never easy. While I definitely feel like I had some more thought-provoking, controversial and laborious blog posts, my favorite would have to be my summary of 18456 errors: http://sqlblog.com/blogs/aaron_bertrand/archive/2011/01/14/sql-server-v-next-denali-additional-states-for-error-18456.aspx...
|
-
|
I served in the U.S. Military for a while, and as part of my training we had to maintain a “Bug-Out Bag”, which was a large duffle-bag full of certain items that we could live on/fight with in an emergency. I’ve carried the spirit of that idea forward...
|
-
|
On Monday, I completely missed that the SQL Server Release Services team published two cumulative updates for SQL Server 2008. I'd blame jury duty, but that didn't start until Tuesday, and only lasted two days. Well, better late than never. Cumulative...
|
-
|
My ex-colleague Paul Mcmillan pointed me at a thread on Stack Overflow that demonstrated a neat T-SQL trick to get the maximum value from a collection of columns in a row. Paul had never seen it before and neither had I so I figure one or two of you out...
|
|
|
|
|
|