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 > Miscellaneous


Search:
What's New - What's Hot
Managing SQL Server Database Fragmentation     
Total Hits: 171  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

There are several things that should be done on a regular basis and one of these things is to manage database fragmentation. Depending on the tables, queries and indexes that are being used fragmentation can cause performance issues as well as using unnecessary space in the database. Database fragmentation is similar to disk fragmentation in that the data is stored in various places in the database file instead of sequentially or next to like data within the database....

Resizable control using jquery  Version: 0.00     Price: $0.00  
Total Hits: 18  |  Today: 0Author: Purushottam Rathore      Rating:  
Read Reviews | Write Review |  Your Rating: 

In this article I am going to discuss how to resize a control using jquery....

Create Linq to SQL connection with select, insert, delete, update  Version: 0.00     Price: $0.00  
Total Hits: 10  |  Today: 0Author: suhaslive      Rating:  
Read Reviews | Write Review |  Your Rating: 

* Create new website
* Add new item
? Select LINQ TO SQL classes
Then, create one dataclasses.dbml file.
Tool?connect to database? change data source
? Select datasource (Microsoft sqlserver)...

HTTP Push from SQL Server — Comet SQL  Version: 0.00     Price: $0.00  
Total Hits: 16  |  Today: 0Author: CoperNick      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article presents how to implement the functionality for presenting the so-called real-time data using ASP.NET and SQL Server. This functionality is realized by implementing Comet functionality in ASP.NET and connecting this with Query Notification from SQL Server....

SQL Server Integration Services (SSIS) -Send File using FTP Task in SSIS Package  Version: 0.00     Price: $0.00  
Total Hits: 11  |  Today: 0Author: Karthikeyan Anbarasan      Rating:  
Read Reviews | Write Review |  Your Rating: 

In this article we are going to see on how to use a FTP task in SSIS package to Send a file. To follow my series of articles on SSIS packages refer to my profile for the links...

SQL Server Integration Services (SSIS) – Part 22 – Receive File using FTP Task in SSIS Package  Version: 0.00     Price: $0.00  
Total Hits: 10  |  Today: 0Author: KarthikAnbarasan      Rating:  
Read Reviews | Write Review |  Your Rating: 

In this article we are going to see on how to use a FTP task in SSIS package to receive a file. To follow my series of articles on SSIS packages refer to the below URL’s...

SQL Server Integration Services (SSIS) – Part 27 – Delete local folder using FTP Task in SSIS Package  Version: 0.00     Price: $0.00  
Total Hits: 10  |  Today: 0Author: KarthikAnbarasan      Rating:  
Read Reviews | Write Review |  Your Rating: 

In this article we are going to see on how to use a FTP task in SSIS package to delete a local folder using FTP Task in SSIS packaging.

To follow my series of articles on SSIS packages refer to the below URL’s...

Camel case table names in MySQL  Version: 0.00     Price: $0.00  
Total Hits: 8  |  Today: 0Author: stephen.vaubell      Rating:  
Read Reviews | Write Review |  Your Rating: 

I have been working with Entity Framework 4 and MySQL. The main problem I have found is that since I am working on a windows server, the table names in the database are all lower case. This means that when I create the entities in Visual Studio, the classes are all lower case.

So I have found this solution:

There is a setting in the configuration file in the MySQL server directory. I am using Windows 7, so this was under: C:\Program Files (x86)\MySQL\MySQL Server 5.5C:\Program File...

SQL Server Integration Services (SSIS) -Import Data using Wizard  Version: 0.00     Price: $0.00  
Total Hits: 7  |  Today: 0Author: Karthikeyan Anbarasan      Rating:  
Read Reviews | Write Review |  Your Rating: 

In this article we will see how to import data from SQL Server using the wizard which is provided with SSMS (SQL server Management Studio). Using SSMS we can perform many tasks like copying data from one server to the other or from one data source to the other in a variety of formats. Here our task is to do a transform of data from SQL server to Excel using the Wizard....

Basics of SQL Server Integration Services  Version: 0.00     Price: $0.00  
Total Hits: 9  |  Today: 0Author: Karthikeyan Anbarasan      Rating:  
Read Reviews | Write Review |  Your Rating: 

In this article we will see what a SQL Server Integration Services (SSIS) is; basic on why SSIS is used for, how to create a SSIS Package and how to debug the same.

SSIS is an ETL tool (Extract, Transform and Load) which is very much needed for the Data warehousing applications. Also SSIS is used to perform the operations like loading the data based on the need, performing different transformations on the data like doing calculation's (Sum, Average, etc.) and to define a workflow of how t...

SQL Server Combo Control  Version: 0.00     Price: $0.00  
Total Hits: 9  |  Today: 0Author: Sorcerer1324      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article shows how to create a custom combo box control that lists the fully qualified SQL Server instance names for all servers connected to a network and running locally....

Conditional Split in SSIS  Version: 0.00     Price: $0.00  
Total Hits: 5  |  Today: 0Author: Madhu.b.rokkam      Rating:  
Read Reviews | Write Review |  Your Rating: 

At times we come across situations where we had to split data based on some conditions. And doing this is very easy in SSIS Conditional Split task.

The Conditional Split can be used to transfer data to different outputs depending on the condition specified and content of the data. This almost acts the same way as we have Switch Case statement in programming language. This too has the default option to redirect rows if non of the conditions met.

Let us consider a scenario where we h...

SQL SERVER - 2005 Best Practices Analyzer Tutorial - Sample Example  Version: 0.00     Price: $0.00  
Total Hits: 7  |  Today: 0Author: pinaldave      Rating:  
Read Reviews | Write Review |  Your Rating: 

Yesterday I posted small note about SQL SERVER - 2005 Best Practices Analyzer (July BPA). I received many request about how BPA is used. Some of readers has asked me to provide sample tutorial which can help start using BPA. This utility has many uses for best practice. I have created very simple and initial tutorial....

Creating SQL Server Login’s and assign specific roles to them  Version: 0.00     Price: $0.00  
Total Hits: 7  |  Today: 0Author: Madhu.b.rokkam      Rating:  
Read Reviews | Write Review |  Your Rating: 

Today in this article we will discuss on how to create Logins and give database level roles in SQL Server and how to assign these roles to the specific users.

So in this scenario we will create two logins one with admin role and one with readonly tester role.
So let’s start with starting the SQL Server Management Studio....

JOIN Instead of Repeating a Subquery  Version: 0.00     Price: $0.00  
Total Hits: 8  |  Today: 0Author: AspDotNetDev      Rating:  
Read Reviews | Write Review |  Your Rating: 

There is sometimes a need to JOIN to a table, but only include the first result that matches the JOIN condition so the result records aren't duplicated by the JOIN. The typical way to do that is to use a subquery. However, if the fields on the table are used in more than one place, that can become cumbersome to add the same subquery several times, as in the following example:...

"Column name Create Date contains an invalid XML identifier as required by FOR XML; ' '(0x0020) is the first character at fault."  Version: 0.00     Price: $0.00  
Total Hits: 11  |  Today: 0Author: Umair Feroze      Rating:  
Read Reviews | Write Review |  Your Rating: 

I have a stored procedure which returns data as an XML node. This stored procedure uses temp table to populate data. The column names in the temp table contain spaces, i.e. [Create Date]....

SQL Server and DMO: Distributed Management Objects Enable Easy Task Automation  Version: 0.00     Price: $0.00  
Total Hits: 23  |  Today: 0Author: Francesco Balena      Rating:  
Read Reviews | Write Review |  Your Rating: 

SQL Server can be administered programmatically using system stored procedures, but Distributed Management Objects (DMO) offer a more modern, object-oriented alternative. This article introduces SQL-DMO in SQL Server 7.0 and SQL Server 2000 and describes the SQL-DMO object model, then focuses primarily on the Databases tree and the JobServer tree of the object model. The sample code and the article show how to use various objects such as the Registry object, the Configuration object, and the Dat...

Top 10 steps to optimize data access in SQL Server. Part III (Apply advanced indexing and denormalization)  Version: 0.00     Price: $0.00  
Total Hits: 41  |  Today: 0Author: M.M.Al-Farooque Shubho      Rating:  
Read Reviews | Write Review |  Your Rating: 

We are in the process of optimizing an SQL Server database, and so far we have done lots of things. We applied indexing in our database tables and then re-factored the TSQL’s to optimize the data access routines. If you are wondering where we did all these and what are the things we have exactly done, take a look at the following articles in this series:
Top 10 steps to optimize data access in SQL Server. Part I (Use Indexing)...

Using Computed Columns in SQL Server with Persisted Values     
Total Hits: 149  |  Today: 0Author: Atif Shehzad      Rating:  
Read Reviews | Write Review |  Your Rating: 

In my databases I had some values that were often calculated while generating several reports. Also there were some columns that were dependent on one or more other columns. As one column was updated triggers were being used to synchronize new values in dependent columns. I was required to provide a more efficient and standard approach to handle these types of scenarios. So how could I get rid of the overhead for calculations at report generation time and how could I avoid the use of triggers fo...

Analysis Services: DISTINCT COUNT, Basket Analysis, and Solving the Multiple Selection of Members Problem     
Total Hits: 74  |  Today: 0Author: Amir Netz      Rating:  
Read Reviews | Write Review |  Your Rating: 

Microsoft knows that many organizations do not use SQL Server to answer the following business intelligence question, "How many customers are buying each of my products?" Simple analysis, such as aggregating or sorting data into dimensions and levels using a regular COUNT measurement, does not work for this query because it may lead to double counts when a single customer buys a product more than once. A solution, the DISTINCT COUNT measure, requires advanced knowledge of SQL Server's online ana...


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


Disclaimer - Privacy
© 2002-2017 DevASP.net