6,630,289 members and growing! (20,025 online)
Email
Password
Remember me?
Lost your password?
Home
Articles
Search
Latest Articles
Top Articles
Beginner Articles
Technical Blogs
Post an Article
Post Tip/Trick
Post your Blog
Posting/Update Guidelines
Article Competition
Topic List
Quick Answers
Ask a Question
Search for an Answer
Latest Questions
Unanswered Questions
Top Questions
Help! (our FAQ)
Message Boards
ASP.NET
ATL / WTL / STL
C / C++ / MFC
Managed C++/CLI
C#
COM
Hardware & Devices
LINQ
.NET Framework
System Admin
Silverlight
General Database
Sharepoint
Visual Basic
Web Development
WPF / WCF / WF
XML / XSL
General IT Issues
Site Bugs / Suggestions
The Soapbox 2.0
All Message Boards...
Job Board
Latest
Search
Post a Job
FAQ and Pricing
Catalog
Latest
Search
Post a Catalog Item
FAQ and Pricing
Help!
What is 'The Code Project'?
General FAQ
Post a Question
Site Directory
About Us
Lounge
Soapbox
Announcements
Windows 7 Comp
Win a laptop!
Monthly Competition
Articles
Desktop Development
Button Controls
Clipboard
Combo & List Boxes
Dialogs and Windows
Desktop Gadgets
Document / View
Edit Controls
Files and Folders
Grid & Data Controls
List Controls
Menus
Miscellaneous
Printing
Progress Controls
Selection Controls
Shell and IE programming
Smart Client
Splitter Windows
Static & Panel Controls
Status Bar
Tabs & Property Pages
Toolbars & Docking windows
Tree Controls
Web Development
Ajax and Atlas
Applications & Tools
ASP
ASP.NET
ASP.NET Controls
ATL Server
Caching
Charts, Graphs and Images
Client side scripting
Custom Controls
HTML / CSS
ISAPI
Site & Server Management
Session State
Silverlight
Trace and Logs
User Controls
Validation
View State
WAP / WML
Web Security
Web Services
Enterprise Systems
Content Management Server
Microsoft BizTalk Server
Microsoft Exchange
Office Development
SharePoint Server
Multimedia
Audio and Video
DirectX
GDI
GDI+
General Graphics
OpenGL
Database
Database
SQL Reporting Services
Platforms, Frameworks & Libraries
ATL
MFC
STL
WTL
COM / COM+
.NET Framework
Win32/64 SDK & OS
Vista API
Vista Security
Cross Platform
Game Development
Mobile Development
Windows CardSpace
Windows Communication Foundation
Windows Presentation Foundation
Windows Workflow Foundation
Libraries
Windows Powershell
LINQ
Languages
C / C++ Language
C++ / CLI
C#
MSIL
VBScript
VB.NET
VB6 Interop
Other .NET Languages
XML
Java
General Programming
Algorithms & Recipes
Bugs & Workarounds
Collections
Cryptography & Security
Date and Time
DLLs & Assemblies
Exception Handling
Localisation
Macros and Add-ins
Programming Tips
String handling
Internet / Network
Threads, Processes & IPC
WinHelp / HTMLHelp
Uncategorised Quick Answers
Graphics / Design
Expression
Usability
Development Lifecycle
Debug Tips
Design and Architecture
Installation
Work Issues
Testing and QA
Code Generation
General Reading
Book Chapters
Book Reviews
Hardware Reviews
Interviews
Scrapbook
Hardware & System
Uncategorised Technical Blogs
Author Resources
Third Party Products
Product Showcase
Solution Center
Mentor Resources
Services
Product Catalog
Code-signing Certificates
Job Board
CodeProject VS2008 Addin
Feature Zones
Product Showcase
Code Signing Resources
WhitePapers / Webcasts
ASP.NET Web Hosting
News & Community
Site Map
Who's Who @ CodeProject
CodeProject MVPs
Competitions
Company Listings
Latest Articles
News
Newsletter Archive
Press Releases
Surveys
Submit an Article
Stuff from CodeProject
The Code Project
About Us
Our Awards
Media kit & Advertising info
Legal Stuff
License Info
Search
Articles / Quick Answers
Messages
Jobs
Product Catalog
Add to IE Search
Articles by pinaldave (12 articles found)
Average article rating: 3.46
Articles
Technical Blogs
Tips
ASP.NET
General
SQL SERVER - 2005 Best Practices Analyzer Tutorial - Sample Example
Last Updated: 10 Jul 2007 Page Views: 22,043 Rating: 3.70/5 Votes: 11 Popularity: 3.85
Bookmark Count: 33
SQL SERVER - 2005 Best Practices Analyzer Tutorial - Sample Example
Database
General
SQL SERVER - 2005 - Create Script to Copy Database Schema and All The Objects - Stored Procedure, Functions, Triggers, Tables, Views, Constraints and All Other Database Objects
Last Updated: 21 Aug 2007 Page Views: 26,651 Rating: 2.07/5 Votes: 13 Popularity: 2.30
Bookmark Count: 15
SQL SERVER - 2005 - Create Script to Copy Database Schema and All The Objects - Stored Procedure, Functions, Triggers, Tables, Views, Constraints and All Other Database Objects
SQL SERVER - 2005 - Introduction and Explanation to sqlcmd
Last Updated: 6 Sep 2007 Page Views: 14,925 Rating: 3.57/5 Votes: 6 Popularity: 2.78
Bookmark Count: 16
SQL SERVER - 2005 - Introduction and Explanation to sqlcmd
SQL SERVER - 2005 - Generate Script with Data from Database - Database Publishing Wizard
Last Updated: 17 Nov 2007 Page Views: 21,905 Rating: 4.42/5 Votes: 10 Popularity: 4.42
Bookmark Count: 23
SQL SERVER - 2005 - Generate Script with Data from Database - Database Publishing Wizard
SQL Server
SQL SERVER - 2008 - Configure Database Mail - Send Email From SQL Database
Last Updated: 3 Sep 2008 Page Views: 13,966 Rating: 4.38/5 Votes: 7 Popularity: 3.70
Bookmark Count: 26
Licence: The Code Project Open License (CPOL)
SQL SERVER - 2008 - Configure Database Mail - Send Email From SQL Database
SQL SERVER - 2008 - Creating Full Text Catalog and Full Text Search
Last Updated: 10 Sep 2008 Page Views: 12,109 Rating: 3.82/5 Votes: 5 Popularity: 2.67
Bookmark Count: 16
Licence: The Code Project Open License (CPOL)
First article on topic - SQL SERVER - 2008 - Creating Full Text Catalog and Full Text Search
SQL Server 2008 Interview Questions and Answers
Last Updated: 19 Sep 2008 Page Views: 8,213 Rating: 2.67/5 Votes: 6 Popularity: 2.08
Bookmark Count: 16
Licence: The Code Project Open License (CPOL)
A Big Downloadable List of SQL Server 2008 Questions and Answers
Reseed Identity of Table - Table Missing Identity Values - Gap in Identity Column
Last Updated: 8 Apr 2009 Page Views: 3,116 Rating: 4.44/5 Votes: 5 Popularity: 3.11
Bookmark Count: 13
Licence: The Code Project Open License (CPOL)
Reseed Identity of Table - Table Missing Identity Values - Gap in Identity Column
Query Optimization – Remove Bookmark Lookup – Remove RID Lookup – Remove Key Lookup
Last Updated: 13 Oct 2009 Page Views: 1,617 Rating: 4.00/5 Votes: 3 Popularity: 1.91
Bookmark Count: 3
Licence: The Code Project Open License (CPOL)
Query Optimization – Remove Bookmark Lookup – Remove RID Lookup – Remove Key Lookup
Design and Architecture
General
SQL SERVER - 2005 T-SQL Paging Query Technique Comparison (OVER and ROW_NUMBER()) - CTE vs. Derived Table
Last Updated: 17 Jun 2007 Page Views: 13,002 Rating: 1.80/5 Votes: 6 Popularity: 1.40
Bookmark Count: 15
SQL SERVER - 2005 T-SQL Paging Query Technique Comparison (OVER and ROW_NUMBER()) - CTE vs. Derived Table
Interviews
General
SQL Server Interview Questions and Answers Complete List Download
Last Updated: 17 Jun 2007 Page Views: 37,669 Rating: 3.29/5 Votes: 7 Popularity: 2.78
Bookmark Count: 26
Licence: The Code Project Open License (CPOL)
SQL Server Interview Questions and Answers Complete List Download
SQL SERVER - Data Warehousing Interview Questions and Answers Complete List Download
Last Updated: 29 Jul 2007 Page Views: 17,189 Rating: 3.40/5 Votes: 10 Popularity: 3.40
Bookmark Count: 20
I have tried to accommodate all of them in last post in the series. I hope this series is helpful to all candidates who are seeking job as well interviewers. I have combined all the questions and answers in the one PDF which is available to download and refer at convenience.
pinaldave
Member
Pinalkumar Dave is a Microsoft SQL Server MVP and a prominent expert on SQL servers. He has written over 1100 articles on the subject on his blog at
http://blog.sqlauthority.com
. He is a dynamic and proficient Principal Database Architect, Corporate Trainer and Project Manager, who specializes in SQL Server Programming and has 7 years of hands-on experience. He holds a Masters of Science degree and a number of certifications, including MCDBA and MCAD (.NET). He was awarded Regional Mentor for PASS Asia and is also Mentor for Solid Quality India.
Occupation:
Founder
Company:
http://blog.SQLAuthority.com
Location:
India
Last Updated 21 Nov 2009
Web09 | 2.2.0175 |
Advertise
|
Privacy
Copyright ©
CodeProject
, 1999-2009
All Rights Reserved.
Terms of Use
