I have been working with SQL Server for quite a few years now, and it still happens quite often that I discover new cool things to do in t-sql. My latest discovery is not a new feature at all, because it was introduced back in SQL Server 2005 – but for some reason I haven’t come across it before. So...
The purpose of the article is to list my top 10 DBA tips to concentrate on in developing the competitive edge. There are of course many more DBA and related technolgies skills. 1) Read everything, across all platforms. Download SQL Server 2008 Books Online and read it all 2) Develop some extreme db apps...
Posted to
Jack Vamvas's Blog
by
Jack Vamvas
on
05-23-2011
Filed under:
Filed under: DB2, DBA, junior sql dba, edge, Oracle, 10, Tips, Top, Mysql, dba jobs, PostgreSQL, develop, MS sql server, competitive
We confused sometimes during write the code logic for SQL queries when we required some of top records from tables to implement in logic. This is very basic thing for the development and here i am going to demonstrate some of the options to get top records using TOP clause from table in various ways...
Posted to
sqlideas
by
Paresh Prajapati
on
04-08-2011
Filed under:
Filed under: sql, sql server 2008, sql server 2005, tsql, sql server, ms sql, ms sql server, t-sql, sqllserver, top, mssql