SQL Interview Questions and Answers Archives - Page 66 of 67

SQL SERVER – Data Warehousing Interview Questions and Answers – Introduction

July 25, 2007

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

Data Warehousing, Database, DBA, SQL Download, SQL Scripts

Click here to get free chapters (PDF) in the mailbox This series is in response to many of my reader’s continuous request to start Data Warehousing Interview Questions and Answers series. This series is written in the same spirit as previous two series which has received good response. Samples Question…

SQL SERVER – Convert Text to Numbers (Integer) – CAST and CONVERT

July 7, 2007

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

Best Practices, SQL Function, SQL Scripts

Few of the questions I receive very frequently. I have collect them in spreadsheet and try to answer them frequently. How to convert text to integer in SQL? If table column is VARCHAR and has all the numeric values in it, it can be retrieved as Integer using CAST or…

SQL SERVER – Definition, Comparison and Difference between HAVING and WHERE Clause

July 4, 2007

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

Best Practices, SQL Scripts

In recent interview sessions in hiring process I asked this question to every prospect who said they know basic SQL. Surprisingly, none answered me correct. They knew lots of things in details but not this simple one. One prospect said he does not know cause it is not on this…

SQL SERVER – Database Coding Standards and Guidelines – Part 2

June 5, 2007

Pinal Dave

SQL Interview Questions and Answers

Database, DBA, Software Development, SQL Coding Standards, SQL Download, SQL Scripts, SQL Server

SQL Server Database Coding Standards and Guidelines – Part 2

SQL SERVER – Good, Better and Best Programming Techniques

April 28, 2007

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Constraint and Keys, SQL Cursor, SQL Download, SQL Function, SQL Index, SQL Joins, SQL Scripts, SQL Server DBCC, SQL Server Security, SQL Stored Procedure, SQL Trigger

A week ago, I was invited to meeting of programmers. Subject of meeting was “Good, Better and Best Programming Techniques”. I had made small note before I went to meeting, so if I have to talk about or discuss SQL Server it can come handy. Well, I did not get…