Search - Articles
DevASP.NET for ASP.NET, VB.NET, XML and C# (C-Sharp) Developers Tuesday, March 03, 2009
Dev Articles
Search Directory
ASP.NET
VB.Net
C-Sharp
SQL Server
 

FREE 12 month online training for ASP.NET & MS Expression Studio and a Free copy of MS Expression Web with Windows Server Purchase

Home >Search > SQL
Search:
What's New - What's Hot
Listings for Applications Applications (161)
Listings for Articles & Samples Articles & Samples (5027)
Listings for Bugs and Fixes Bugs and Fixes (94)
Listings for Developer Sites Developer Sites (13)
Listings for Downloads Downloads (54)
Listings for Introduction Introduction (29)
Listings for Knowledge Base Knowledge Base (289)
Listings for Sample Chapters Sample Chapters (24)
Listings for Training Training (23)
Listings for WebCasts WebCasts (21)


Quick and dirty reporting solution using Excel  Version: 0.00     Price: $0.00  
Total Hits: 89  |  Today: 0Author: Oshtri Deka      Rating:  
Read Reviews | Write Review |  Your Rating: 

If your client has MS Excel installed, you can in few steps provide rather slick ad hoc solution which will do the job until you can provide something with more professional feel. Hey, I've done project where most of the reports are done this way and client prefers it. It's a Trade-off with capital T. Smile | :)...

SQL Server PERFORMANCE with Wait Types and Queues  Version: 0.00     Price: $0.00  
Total Hits: 77  |  Today: 0Author: pinaldave      Rating:  
Read Reviews | Write Review |  Your Rating: 

I have been working a lot on Wait Stats and Wait Types recently. Last Year, I requested blog readers to send me their respective server’s wait stats. I appreciate their kind response as I have received Wait stats from my readers. I took each of the results and carefully analyzed them. I provided necessary feedback to the person who sent me his wait stats and wait types. Based on the feedback I got, many of the readers have tuned their server....

Find paricular word or text from all the stored procedure  Version: 0.00     Price: $0.00  
Total Hits: 78  |  Today: 0Author: Sunasara Imdadhusen      Rating:  
Read Reviews | Write Review |  Your Rating: 

It will find text "GetEmployee" from entire stored procedure in database....

Always use Binding Variables in SQL queries  Version: 0.00     Price: $0.00  
Total Hits: 77  |  Today: 0Author: Amit Kumar Tiwari      Rating:  
Read Reviews | Write Review |  Your Rating: 

While writing queries in SQL always prefer using the Binding Variables. Here's why:

Everytime a query is executed, it is first checked into the Shared Pool to see whether the query was executed before or not. If yes, then its execution plan is used again to execute the new query. If no, Hard Parse is done by the database. The query is parsed, working out the various execution paths and coming up with an optimal access plan before it can be executed. Hard parsing is very CPU intensive, and...

Time remaining of Database Shrink  Version: 0.00     Price: $0.00  
Total Hits: 86  |  Today: 0Author: wizardzz      Rating:  
Read Reviews | Write Review |  Your Rating: 

I found a stored procedure already in my database (via legacy), and modified it to display remaining seconds and lapsed seconds....

Using Entity Framework 4.1 Code First with an existing database  Version: 0.00     Price: $0.00  
Total Hits: 78  |  Today: 0Author: Caprica1      Rating:  
Read Reviews | Write Review |  Your Rating: 

This post focuses on using the Entity Framework 4.1 RC Fluent API with an existing database.

When I say an existing database, what I really mean is that you’re not letting EF Code First auto generate the database for you. So it could be that you like to create your entities and then manually craft the database. Or you may have a separate team of developers who like to control and manage the database....

How to get an empty GUID in SQL Server  Version: 0.00     Price: $0.00  
Total Hits: 75  |  Today: 0Author: nit_singh      Rating:  
Read Reviews | Write Review |  Your Rating: 

Sometimes we need to compare a value with an empty GUID in SQL Server, and used to do something like...

Microsoft SQL Name capitalize function  Version: 0.00     Price: $0.00  
Total Hits: 73  |  Today: 0Author: cluengas2k      Rating:  
Read Reviews | Write Review |  Your Rating: 

This is a basic function for Microsoft SQL to generate a proper case name and remove some of the spaces....

nth Highest Salary in SQL Server 2005  Version: 0.00     Price: $0.00  
Total Hits: 83  |  Today: 0Author: Mohd_Ahmad      Rating:  
Read Reviews | Write Review |  Your Rating: 

nth Highest Salary in SQL Server 2005...

Kill User Session in Sleep State  Version: 0.00     Price: $0.00  
Total Hits: 78  |  Today: 0Author: nial      Rating:  
Read Reviews | Write Review |  Your Rating: 

Kill User Session in Sleep State...

Sqlserver Trigger a quick look  Version: 0.00     Price: $0.00  
Total Hits: 81  |  Today: 0Author: Prasanta_Prince      Rating:  
Read Reviews | Write Review |  Your Rating: 

A database trigger is procedural code that is automatically executed in response to certain events on a particular table or view in a database.

Triggers that run after an update, insert, or delete. .Triggers are used to enforce data integrity and business rules such as automatically updating summary data. It allows to perform cascading delete or update operations....

SQL Server Integration Services (SSIS) - Conditional Split Task in SSIS  Version: 0.00     Price: $0.00  
Total Hits: 76  |  Today: 0Author: Karthikeyan Anbarasan      Rating:  
Read Reviews | Write Review |  Your Rating: 

In this article we are going to see on how to use a Conditional Split task based on the decision. Conditional tasks transformation will be used to split the data based on some condition and save the result set in different destinations. This task will be very useful in cases such as for inserting some passed test cases data to a database and the failed test cases data to a text file or sending a mail to the administrator....

How to use LINQ in .NET  Version: 0.00     Price: $0.00  
Total Hits: 71  |  Today: 0Author: Ashish Shukla      Rating:  
Read Reviews | Write Review |  Your Rating: 

LINQ Stands for Language Integrated Query, so named since it is part of the programming language like C#. It is used to provide consistent access to various data sources like databases and XML. Before LINQ we used various languages and technologies to access different data sources. Now with LINQ we can use the same syntax to access the different data sources from within the language itself....

Installation of SQL Server 2005  Version: 0.00     Price: $0.00  
Total Hits: 77  |  Today: 0Author: vilas gite      Rating:  
Read Reviews | Write Review |  Your Rating: 

Using Windows 7 Ultimate, after installation of SQL Server 2005, an error occurrs regarding Connection. (Settings for Database Engine)
Login failed for user 'Admin\vilas'. (Microsoft SQL Server, Error : 18456)...

Using SQL Server Profiler  Version: 0.00     Price: $0.00  
Total Hits: 79  |  Today: 0Author: Manikavelu Velayutham      Rating:  
Read Reviews | Write Review |  Your Rating: 

The SQL Server Profiler is a performance tool which included with any version of SQL Server. It generally shows how SQL Server accesses the database internally. This tool is used by developers as well as a performance engineering team to analyze which SQL statements take more time to execute. It shows information like, how many reads and writes happened in a transaction, the duration it takes to complete the transaction and information such as that is displayed to show complete information of ev...

Crystal Report Between Two Dates using a Stored Procedure  Version: 0.00     Price: $0.00  
Total Hits: 77  |  Today: 0Author: Kiran Karele      Rating:  
Read Reviews | Write Review |  Your Rating: 

Here you will see how to use Crystal Report between two dates using a Stored Procedure....

SQL Server Integration Services (SSIS) - Copy Column Transformations in SSIS  Version: 0.00     Price: $0.00  
Total Hits: 77  |  Today: 0Author: Karthikeyan Anbarasan      Rating:  
Read Reviews | Write Review |  Your Rating: 

In this article we are going to see how to use the Copy Column transformation inside a package. The Copy Column task helps to copy a column to a destination as and when required to have sync across the environments. Let's jump start to the section on how to do that using a sample package....

Selection Based Crystal Report using Stored Procedure  Version: 0.00     Price: $0.00  
Total Hits: 90  |  Today: 0Author: Kiran Karele      Rating:  
Read Reviews | Write Review |  Your Rating: 

Here you will see how to do a selection based CrystalReport using a Stored Procedure....

LINQ to SQL  Version: 0.00     Price: $0.00  
Total Hits: 69  |  Today: 0Author: Ahmed EL Bohoty      Rating:  
Read Reviews | Write Review |  Your Rating: 

The targetof this this project is to know the How to make update, select, delete, select using LINQ to SQL and How to navigate between records using BindingSource Control....

SQL Server Integration Services (SSIS) - Character Map (Lower to Upper) Transformations in SSIS  Version: 0.00     Price: $0.00  
Total Hits: 73  |  Today: 0Author: Karthikeyan Anbarasan      Rating:  
Read Reviews | Write Review |  Your Rating: 

In this article we are going to see how to use the Character Map transformation control in SSIS Packaging. We are going to see an example of how to do a transformation of lower to upper case of a column using the character map transformation control. Let's jump start to the section on how to do that using a sample package....



Disclaimer - Privacy
© 2002-2014 DevASP.net