Covering Index vs. Indexed View A covering index and an Indexed View are two different techniques for solving the same problem; performance needed when retrieving data from an table or view that has too much overhead for retrieving a subset of the possible data. Both techniques operate as a virtual table if they contain the necessary data required by queries. […]
Author: Ben Taylor
War Story Rewind
2012 Topics Survey Here is your opportunity to help determine SSWUG courses for 2012. Click Here to take an online survey. It’s quick, easy, and you will be eligible for some pretty cool free stuff. War Story Our War Story newsletter didn’t distribute well yesterday. If this is a duplicate for some of you, my apologies. I’m not sure how […]
War Story Rewind
2012 Topics Survey Here is your opportunity to help determine SSWUG courses for 2012. Click Here to take an online survey. It’s quick, easy, and you will be eligible for some pretty cool free stuff. War Story Our War Story newsletter didn’t distribute well yesterday. If this is a duplicate for some of you, my apologies. I’m not sure how […]
War Story
War Story I’m not sure how universal the term “War Story” may be, but this term is used to describe a painful event experienced in the life of an IT professional. It may be related to infrastructure, processes, software development, product management, software development lifecycles, etc. The value of a "war story" is that it provides real life experiences substantiating […]
War Story
War Story I’m not sure how universal the term “War Story” may be, but this term is used to describe a painful event experienced in the life of an IT professional. It may be related to infrastructure, processes, software development, product management, software development lifecycles, etc. The value of a "war story" is that it provides real life experiences substantiating […]
Optional Parameters
Optional Parameters Unlike many programming languages, SQL does not lend itself to optional parameters, especially when using stored procedures. I’m going to share a SQL tip today regarding different methods to implementing optional parameters. All code is written in TSQL for MS SQL Server, but may be modified to work in other SQL engines. For this demonstration I’m going to […]
Optional Parameters
Optional Parameters Unlike many programming languages, SQL does not lend itself to optional parameters, especially when using stored procedures. I’m going to share a SQL tip today regarding different methods to implementing optional parameters. All code is written in TSQL for MS SQL Server, but may be modified to work in other SQL engines. For this demonstration I’m going to […]
Jeopardy on SSWUG.org
Jeopardy on SSWUG.org Today’s Jeopardy question pretty clearly demonstrates why it is difficult to create a Computer that can think like the Human Mind. I was amazed by the number of responses regarding yesterdays SSWUG Jeopardy question…and they were all nearly identical. What is dropping/mixing a stack of unnumbered programming cards? In the 60s programmers didn’t have direct access to […]
Jeopardy on SSWUG.org
Jeopardy on SSWUG.org Today’s Jeopardy question pretty clearly demonstrates why it is difficult to create a Computer that can think like the Human Mind. I was amazed by the number of responses regarding yesterdays SSWUG Jeopardy question…and they were all nearly identical. What is dropping/mixing a stack of unnumbered programming cards? In the 60s programmers didn’t have direct access to […]
Implications of IBM Watson
$$SWYNK$$ Featured Article(s) Tips for designing SQL Server 2008 tables (Part 2) In this article, you can find some useful tips to design SQL Server 2008 tables. Featured White Paper(s) Structuring the Unstructured: How to Dimensionalize Semi-Structured Business Data Written by Interactive Edge The Business Intelligence industry … (read more) Implications of IBM Watson If you heard the presentation of […]