1 day ago by pinaldave

Yesterday was indeed fun day. I asked simple Brain Teaser and we had excellent conversation on SQLAuthority Page as well SQL SERVER – A Quick Puzzle on JOIN and NULL – SQL Brain Teaser. This was easy puzzle for those who have attended SQL Server Questions and Answers online course. Here is the quick ...

1 day ago by ssvaidya

If you looking for an easy way to slipstream Service Packs and Cumulative Updates into SQL Server 2008, you can find a very convenient tool to accomplish this on CodePlex called SQL 2008 Slipstream Assist. The tool can be downloaded from here: http://sqlslipstreamer.codeplex.com/ If you want to know ...

2 days ago by Centriq Training

Paraphrasing E.F. Codd’s First Normal Form, it states that there should be, “No repeating groups”. The language column is the group in this example, below you will find the proposed design implements this rule, while the original design does not. Original design (Products table) ProductID Name Engli ...

2 days ago by Elkin Siabato

Bueno... Realmente no utilizo como tal el alias en la columna WHERE, sino lo que hacemos es emular una tabla apartir de una consulta SELECT. Entonces ahi si podremos utilizar el "alias", que no es alias en realidad, je je.... Pero mejor con el ejemplo: SELECT * FROM ( SELECT AUX1.idcliente, AUX1.val ...

2 days ago by Elkin Siabato

Bueno... seré breve, esta una consulta que utilice para un proyecto: SELECT CLI1.id, CLI1.idcliente, SUM(CLI1.primas), ROW_NUMBER() OVER( ORDER BY SUM(CLI1.primas)ASC ) as 'posicion' FROM sb_clipro CLI1 WHERE CLI1.idproducto IN ( SELECT sb_producto.id FROM sb_producto WHERE sb_producto.nombre IN ('A ...

4 days ago by Raju Sachin

This article will explain the differences between the system views syslogins and sysxlogins. And also explains the purpose of the both views. syslogin contains the sql server logins and sysxlogins includes the link server & sql server logins. Related posts: Oracle Interview Questions | What is a vie ...

4 days ago by Tim Tow

As we continue to work on Dodeca, we continue to stretch the limit. Today was certainly evidence of that. Dodeca already has the most powerful relational/spreadsheet technology available in the world, but our development team is not yet satisfied. Instead, they are working on making it even better. ...

4 days ago by Tech Guy

Stored Procedure Name : sp_depends Purpose:- This stored procedure is useful in finding the dependency relationship for a given table, which would help in finding the impact of a change on its dependants. Syntax:- sp_depends < Name of the Object> Other SQL Server Stored Procedures sp_help sp_helptex ...

5 days ago by Hoon Lee

"CURSOR" stands for CURrent Set Of Records. An interesting way of creating a name. I think I like the name, Cursor.

5 days ago by Jonathan

SQL Saturday is coming back to Houston on April 21st. Last year we had a great event and are looking forward to making this one even better. To that end we are pleased to be able to offer a pre-conference session on SQL Server Query Plans: Tuning and Management. The session will be lead by Kalen Del ...