Click here to Skip to main content
Search within:



The SQL Zone

 

The database server is the big iron in a server environment, and keeping them running smoothly is a full-time job. If you’re looking to improve your skills as a DBA or a database developer, this is the place to start.

The articles gathered in our SQL Server Zone cover everything from basic SQL syntax to advanced tuning techniques for stored procedures.

Alongside white papers and sample code, you can read articles for all levels of proficiency, and get answers for specific questions from the authors themselves. Your ongoing SQL Server learning begins here.

Red Gate Whitepapers


Featured Article

Featured
Introducing the Boomerang Framework
by psined
Introduction to Boomerang Framework

Articles

New
SQLoogle - Part 1 of 2
by dale.newman
Google your SQL.
New
A mobile salon services solution.
by Randall Smith II
A simple solution trying out the Azure platform for development and deployment.
New
SQL Server Functions that helps to convert date and time values to and from string literals and other date and time formats.
by Shemeer NS
CAST(), CONVERT(), PARSE(), TRY_PARSE(), TRY_CONVERT(), FORMAT(), SQL Server Functions, SQL...
New
Comics Subscription Tracker
by mf81
This will be a lightweight site that helps the user track their weekly comics subscriptions.
New
String Data Types and Functions - SQL Server (2000, 2005, 2008, 2008 R2, 2012)
by Shemeer NS
SQL Server 2000, 2005, 2008, 2008 R2, 2012 Character String Data Types and Functions with Sample...
New
Simple CRUD Using Backbone.js in ASP.NET MVC Razor
by Baliah Senthilkumar
Here is a simple CRUD on the MVC music store using backbone.
New
A conversion of the popular DotNetNuke web application to C#
by andrewcates
In an attempt to open DotNetNuke to a wider audience, I have converted the original VB code into C#
New
Inheritance mapping strategies in Fluent Nhibernate
by Igor Ignatov
This article explains and illustrates on a practical example, how the support of different...
New
Creating Time Dimension in Microsoft Analysis Services
by Igor Krupitsky
Unlike Date Dimension (with Year, Month, Date), Time Dimension (with Hour, Minutes, and Seconds)...

Discussions

 
Hint: For improved responsiveness ensure Javascript is enabled and choose 'Normal' from the Layout dropdown and hit 'Update'.
You must Sign In to use this message board.
Search this forum  
    Spacing  Noise  Layout  Per page  Show 
First PrevNext
QuestionHOW TO ANSWER A QUESTIONadminChris Maunder16 Jul '09 - 3:10 
QuestionHow to get an answer to your questionadminChris Maunder10 Nov '05 - 16:30 
Questionstored procedure or views?memberJassim Rahma17 May '13 - 9:43 
AnswerRe: stored procedure or views?professionalPIEBALDconsult17 May '13 - 10:00 
SuggestionRe: stored procedure or views?professionalRichard Deeming17 May '13 - 10:10 
GeneralRe: stored procedure or views?memberjschell17 May '13 - 10:46 
Questionin mysql database i implemented simple query on 1 like select * from dbo.company limit 2 .it taking tomuch time.except that table remaning all tables are working well. in that table records also very less.i try to editing,droping,deleting any thing imemberMember 967148216 May '13 - 20:15 
AnswerRe: in mysql database i implemented simple query on 1 like select * from dbo.company limit 2 .it taking tomuch time.except that table remaning all tables are working well. in that table records also very less.i try to editing,droping,deleting any thimvpEddy Vluggen17 May '13 - 5:00 
QuestionCreate an sql script that compares two dbase and updates dbase and insert date of update in a column in oracle 11gmemberMiguel Quintanilla16 May '13 - 3:45 
QuestionRe: Create an sql script that compares two dbase and updates dbase and insert date of update in a column in oracle 11gmvpEddy Vluggen16 May '13 - 3:49 
AnswerRe: Create an sql script that compares two dbase and updates dbase and insert date of update in a column in oracle 11gmemberMiguel Quintanilla16 May '13 - 4:32 
GeneralRe: Create an sql script that compares two dbase and updates dbase and insert date of update in a column in oracle 11gmvpEddy Vluggen16 May '13 - 4:53 
AnswerRe: Create an sql script that compares two dbase and updates dbase and insert date of update in a column in oracle 11gprofessionalMycroft Holmes16 May '13 - 21:24 
QuestionCreate a procedure to change date value of a column in a table ? (SQL)membertaibc15 May '13 - 21:09 
AnswerRe: Create a procedure to change date value of a column in a table ? (SQL)memberdjj5516 May '13 - 1:18 
GeneralRe: Create a procedure to change date value of a column in a table ? (SQL)membertaibc16 May '13 - 3:41 
GeneralRe: Create a procedure to change date value of a column in a table ? (SQL)memberdjj5516 May '13 - 3:49 
AnswerRe: Create a procedure to change date value of a column in a table ? (SQL)mvpEddy Vluggen16 May '13 - 3:16 
GeneralRe: Create a procedure to change date value of a column in a table ? (SQL)membertaibc16 May '13 - 3:34 
GeneralRe: Create a procedure to change date value of a column in a table ? (SQL)mvpEddy Vluggen16 May '13 - 3:48 
GeneralLooking for the best solutionmemberMacAriel15 May '13 - 8:40 
QuestionDeploying SSIS Package and calling it from Console applicationmemberindian14315 May '13 - 7:28 
AnswerRe: Deploying SSIS Package and calling it from Console applicationmemberunclepaul15 May '13 - 8:47 
AnswerRe: Deploying SSIS Package and calling it from Console applicationprofessionalMycroft Holmes15 May '13 - 18:00 
QuestionCreate trigger that executes on datememberdamokk15 May '13 - 3:54 
Last Visit: 31 Dec '99 - 18:00     Last Update: 18 May '13 - 16:21Refresh1234567891011 Next »

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   



Red Gate Resources

Free eBooks

Product Announcements



Advertise | Privacy | Mobile
Web04 | 2.6.130516.1 | Last Updated 1 Aug 2007
Copyright © CodeProject, 1999-2013
All Rights Reserved. Terms of Use
Layout: fixed | fluid