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
 


Home >Search > Articles & Samples > SQL Server > Tips & Tricks


Search:
What's New - What's Hot
How to insert new and update existing records using SSIS  Version: 0.00     Price: $0.00  
Total Hits: 10  |  Today: 0Author: Rajeev Kumar      Rating:  
Read Reviews | Write Review |  Your Rating: 

We often need in the incremental load of various tables (from source to destination) that old record must be updated and new records to be inserted.

Step 1: Finding the columns of the source tables from which we can know that a particular records is a new record or it is the old one....

How to Schedule and Run a SSIS package ( DTS ) Job in SQL Server 2005  Version: 0.00     Price: $0.00  
Total Hits: 10  |  Today: 0Author: hong_wei_li@yahoo.com      Rating:  
Read Reviews | Write Review |  Your Rating: 

In the SQL Server 2005, after you create a SSIS package ( DTS), you want to create a job and schedule to run it. You will get the error to prevent you to run the job. What is the problem?



Here is why: SQL Server 2005 is quite different from SQL Server 2000. In SQL Server 2000, you can create the job and run it without problem. In SQL Server 2005, you need to go through the security layer in order to run the job....

How to remove duplicate rows in SQL Server 2005 when no key is present  Version: 0.00     Price: $0.00  
Total Hits: 15  |  Today: 0Author: Mika Wendelius      Rating:  
Read Reviews | Write Review |  Your Rating: 

An easy way to remove duplicate rows from a table in SQL Server 2005 is to use undocumented feature called %%lockres%%. This pseudo column shows the physical location of a row....

Get Work Days Count  Version: 0.00     Price: $0.00  
Total Hits: 7  |  Today: 0Author: Tarek Najem      Rating:  
Read Reviews | Write Review |  Your Rating: 

The following function calculates the number of days in a given month with the decrease of days that we have selected.

I will let the code speak for itself....

How To Store Any File into SQL Database  Version: 0.00     Price: $0.00  
Total Hits: 12  |  Today: 0Author: Md. Marufuzzaman      Rating:  
Read Reviews | Write Review |  Your Rating: 

Recently I completed a project where I need to store various files, i.e. Microsoft Office file formats, PDF, Images, etc.). When I started writing code, I wrote a function to store binary, after that I thought why not use direct bulk insert from a StoredProcedure....

Tip: Fetching Random Rows From SQL Server  Version: 0.00     Price: $0.00  
Total Hits: 6  |  Today: 0Author: Bipin Joshi      Rating:  
Read Reviews | Write Review |  Your Rating: 

Recently I needed to fetch random rows from a SQL server table. If you have an integer column then using RAND() function goes well. However in my case there was no number column. In such cases you can use the following query:...

How to use the XML Features in SQL server 2005  Version: 0.00     Price: $0.00  
Total Hits: 8  |  Today: 0Author: RRaveen      Rating:  
Read Reviews | Write Review |  Your Rating: 

The purpose of this article is to explain how to use XML in SQL Server 2005 and generate different kind of XML files to database. SQL Server is such a popular database. Since Microsoft has added many other features to SQL Server 2005, it is worth to learning XML features in SQL server....

How to create Cursor, Temporary Table and Insert Data in to Temporary Table  Version: 0.00     Price: $0.00  
Total Hits: 5  |  Today: 0Author: Jayendrasinh Gohil      Rating:  
Read Reviews | Write Review |  Your Rating: 

How to create Cursor, Temporary Table and Insert Data in to Temporary Table...

How to get the details of Open Transaction in SQL Server  Version: 0.00     Price: $0.00  
Total Hits: 9  |  Today: 0Author: tarun_j200181      Rating:  
Read Reviews | Write Review |  Your Rating: 

The below query can be used to get the details of OPEN TRANSACTION:...

How to unit test SQL Server 2008 database using Visual Studio 2010 – Part 3  Version: 0.00     Price: $0.00  
Total Hits: 8  |  Today: 0Author: atverma      Rating:  
Read Reviews | Write Review |  Your Rating: 

This is the last article of the series “How to unit test SQL Server 2008 database using Visual Studio 2010”. The previous articles are

Unit test SQL Server 2008 - Part 1 – Focused on setting up environment, creating database project and executing simple unit tests

Unit test SQL Server 2008 - Part 2 – Focused on internals of database unit testing i.e. assemblies...

Converting / Parsing Delimited string column in SQL to Rows  Version: 0.00     Price: $0.00  
Total Hits: 4  |  Today: 0Author: Raymund Macaalay      Rating:  
Read Reviews | Write Review |  Your Rating: 

Have you ever wondered how would you convert that SQL column which is comma delimited into Rows so that you can effectively join it with other tables or use that infomration better. This might happen for those of you who have saved the keywords lets say of a blog application in a single column delimited with comma, or you might be using an old DotNetNuke version where the RoleIDs are in a ; delimited string saved in one column and you want to use that information in a better and easier way, or ...

How to Do SQL Server Performance Trend Analysis Part 3: Storing Performance Data in SQL Server  Version: 0.00     Price: $0.00  
Total Hits: 16  |  Today: 0Author: Brad McGehee      Rating:  
Read Reviews | Write Review |  Your Rating: 

This is part three of a four-part tutorial. This part discusses how to use Microsoft Excel to create analysis charts and how to perform trend analysis using Performance Monitor data. Part four will show you how to interpret your results. Read part one. Read part two....

How to Identify Non-Active SQL Server Indexes  Version: 0.00     Price: $0.00  
Total Hits: 11  |  Today: 0Author: Luis Martin      Rating:  
Read Reviews | Write Review |  Your Rating: 

As a DBA, it is our regular task to review our databases and see if there is any way we can boost their performance. While adding new or better indexes to a database is one of the primary ways we can boost performance, an often forgotten way to help boost database performance is to remove indexes that are no longer being used, or to identify overly large indexes that take a lot of SQL Server's resources. Unused indexes hurt INSERT, UPDATE, and DELETE performance, and add unnecessary disk I/O. So...

How to: Create and Execute an SQL Statement that Returns a Single Value  Version: 0.00     Price: $0.00  
Total Hits: 44  |  Today: 0Author: Microsoft Corporation      Rating:  
Read Reviews | Write Review |  Your Rating: 

To execute an SQL statement that returns a single value, you can run a TableAdapter query that is configured to run an SQL statement (for example, CustomersTableAdapter.CustomerCount()). If your application does not use TableAdapters, call the ExecuteScalar method on a command object, setting its CommandType property to Text. ("Command object" refers to the specific command for the .NET Framework Data Provider your application is using. For example, if your application is using the .NET Framewor...

How to connect / access remote SQL Server 2005 database via CC Proxy  Version: 0.00     Price: $0.00  
Total Hits: 45  |  Today: 0Author: kiran dangar      Rating:  
Read Reviews | Write Review |  Your Rating: 

Most of organizations use proxy server shared internet connection for their internal network. Browsing websites via proxy server requires few settings in browser itself where we set proxy server IP and port to 8080 which is default port, doing so is enough for any 1 to surf internet. But as an SQL server database programmers/developers uses SQL server management studio to connect to remote database from their client computers. Problem arises when a developer tries to connect a remote database se...

Powershell How-To - Part 1  Version: 0.00     Price: $0.00  
Total Hits: 54  |  Today: 0Author: Rajib Bahar      Rating:  
Read Reviews | Write Review |  Your Rating: 

I was excited hear about powershell feature in SQL server 2008. Initially, it was not clear to me what it was, yet, I was enthused about learning something new. I imagined power shell would involve something in the command line. What happens after that was a complete mystery to me. Anyways, I managed to spend some extra time to learn about the powershell technology. I am going to split this article into multiple series. In the 1st part, I will cover how to work with variables and various helpful...

LINQ to SQL (Part 6 - Retrieving Data Using Stored Procedures)     
Total Hits: 53  |  Today: 0Author: ScottGu      Rating:  
Read Reviews | Write Review |  Your Rating: 

Over the last few weeks I've been writing a series of blog posts that cover LINQ to SQL. LINQ to SQL is a built-in O/RM (object relational mapper) that ships in the .NET Framework 3.5 release, and which enables you to model relational databases using .NET classes. You can use LINQ expressions to query the database with them, as well as update/insert/delete data....

Using the EventData() Function with DDL triggers in SQL Server 2005     
Total Hits: 229  |  Today: 0Author: Edwin Sarmiento      Rating:  
Read Reviews | Write Review |  Your Rating: 

In SQL Server 2005, you can get data regarding the event that initiated the DDL trigger by accessing the EventData() function. This function returns information about server or database events and is stored in a variable that uses the XML data type. What we need to do is capture the data returned by the EventData() function and store it in a database table for reporting purposes. You can store that data directly in an XML column or process it first before storing it as ordinary columns in a tabl...

Deliver User-Friendly Reports from Your Application with SQL Server Reporting Services     
Total Hits: 135  |  Today: 0Author: John C. Hancock      Rating:  
Read Reviews | Write Review |  Your Rating: 

Flexible reporting capabilities are a requirement for most business applications and their integration into Web apps makes them more versatile than ever. With the recent release of SQL Server™ 2000 Reporting Services, you can easily add reporting from diverse data sources. In this article I will introduce report authoring using Visual Studio® and Reporting Services and demonstrate how to integrate reports into your Web applications....

Data Access Tracing in SQL Server 2005     
Total Hits: 113  |  Today: 0Author: Microsoft Corporation      Rating:  
Read Reviews | Write Review |  Your Rating: 

Learn how to apply the new tracing functionality in Microsoft data access technologies such as ADO.NET 2.0, MDAC 2.82, SQL Server Native Client, and the JDBC driver; and in the SQL Server network protocols and the Microsoft SQL Server 2005 database engine....


1  2  3  4  5  6  7  8  9  10  Next >> 


Disclaimer - Privacy
© 2002-2017 DevASP.net