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 > Applications > SQL > Data Management


Search:
What's New - What's Hot
If it's on the Internet, it must be true     
Total Hits: 124  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

Among many other things, the Internet is a great resource and has revolutionized many things including troubleshooting SQL Server issues. Based on my observations, more often than not, when a SQL Server issue occurs DBAs, Developers or Network Administrators will ask their team if they have seen the issue they are experiencing and for the resolution. Depending on the answer, the next resource that is tapped is their favorite search engine i.e. Google. After a few different keyword searches, ...

Analyze and Correct a large SQL Server MSDB Database     
Total Hits: 125  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

It has come to my attention that some of our MSDB databases are getting what I would consider large for a system database. Some of our MSDB databases are over 2 GB which is a little perplexing because I know we do not create any user defined objects in that database. Can you give me some insight into the issue? I know we have this issue with both SQL Server 2000 and 2005 instances. On a few different SQL Server instances, we have observed MSDB databases over 1 GB. In each of the circumstance...

Making data imports into SQL Server as fast as possible     
Total Hits: 219  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

When bulk loading data into SQL Server, in most cases you want to have this process run as fast as possible. Depending on the options you select and how indexes are setup on the table, the time to load the data could differ quite drastically. In this tip we will take a look at different options for bulk loading along with examples and the time it takes for each of these operations to complete....

SQL Server DBA database management checklist     
Total Hits: 245  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

For both old and new DBAs there are fundamental procedures that should be addressed and proper processes put in place to handle various areas of database management for SQL Server. Whether you are a full time DBA or this is one of many job roles that you perform the same basic steps should be implemented and adhered to in order to have some peace of mind that you are performing the correct procedures to ensure a healthy running SQL Server environment. For old DBAs these items should be a no-br...

SQL Server Task Management Best Practices     
Total Hits: 143  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

Do you feel like all of your projects are going in circles with little progress being made on a weekly basis? Do these projects prevent you from working on the latest and greatest technologies? If so, consider taking the first step in trying to move forward with your projects in a more straight forward manner....

Run The Same SQL Command Against All SQL Server Databases     
Total Hits: 198  |  Today: 0Author: Tim Ford      Rating:  
Read Reviews | Write Review |  Your Rating: 

There are times when I find myself needing to run a SQL command against each database on one of my SQL Server instances. There is a handy undocumented stored procedure that allows you to do this without needing to set up a cursor against your sysdatabases table in the master database: sp_MSforeachdb....

ASP.NET Enterprise Manager for SQL Server and MSDE  Version: 0.1.3     Price: Free / Free Trial  
Total Hits: 2742  |  Today: 0Author: Wes Grant      Rating:  
Read Reviews | Write Review |  Your Rating: 


An Open-Source, Web-Based Interface for SQL Server and MSDE. The USer Interface mimics Microsoft's Enterprise Manager....

SQLPane  Version: 1.0     Price: $19.99 / Free Trial  
Total Hits: 755  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

SQLPane is a webbased SQL utility, which gives interface to perform any SQL operation, namely INSERT, UPDATE, DELETE, SELECT etc.SQLPane shows the query results in a HTML table. SQLPane also shows database structure with describe table capability.SQLPane works onAccess Oracle and SQLServer databases. This component is very useful for the projects where developers need to access the database,andperform different operations. It's also useful for developers who wants to work remotely, because SQLPa...

Visual Access XP      
Total Hits: 779  |  Today: 0Author: Danny Lesandrini      Rating:  
Read Reviews | Write Review |  Your Rating: 

Microsoft Access is a two-fold blessing for programmers. In addition to being a fantastic development platform, its wide popularity as an office productivity tool helps to sustain a market for end user data reporting utilities. Savvy developers know how to cash in on this opportunity by writing focused applications with a clear objective in mind. Does Visual Access XP meet this litmus test? Read on and see....

Proc-Blaster   Price: $297.00 / Free Trial  
Total Hits: 683  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

Proc-Blaster is a Template Based Code Generation tool which supports a variety of programming languages including VB.NET and C#. Prewritten VB.NET and C# templates are also included in the installation....

QuB  Version: 1.0.0     Price: $99.00  
Total Hits: 458  |  Today: 0Author: InterAKT Online      Rating:  
Read Reviews | Write Review |  Your Rating: 

The solution for automating SQL query generation, easying database applications development for building website administration tools For a dynamic web application developer, who needs to put database content on the web and is not an SQL expert, QuB is the tool that allows table relation management, automating SQL query generation. Unlike other tools, QuB manages tables, relations and conditions for your queries visually....

Auto-Inserts   Price: $99.00 / Free Trial  
Total Hits: 508  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

Auto-Inserts automatically and intelligently converts SQL Server data into Insert scripts. Auto-Inserts handles Identities and all SQL Server datatypes. It even intelligently orders the script processing to delete and re-insert every record in a database without violating referential integrity....

Retrieving SQL Server Database Properties with DATABASEPROPERTYEX     
Total Hits: 236  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

Finding out information about database settings is not that hard when you use Enterprise Manager or Management Studio, T-SQL commands such as sp_helpdb or query the system tables directly. But the way the information is returned may not always be the most useful. When using the GUI tools you can't easily grab just the information that you need and you can only look at one database at a time. With the T-SQL commands such as sp_helpdb the database options are all strung together and not listed ...

SQL Server Database Integrity Checks Checklist     
Total Hits: 215  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

In a previous tip we discussed 10 items that should be addressed to manage your SQL Server environment. These items included; backups, security, disaster recovery, etc... The second item on the list was to check database and table integrity. This is pretty much a simple task to perform and there is not much if any interaction that needs to take place between the DBA and SQL Server. Although this is pretty straightforward to setup and run, this is not always implemented and secondly the output...

SQL Server Index Maintenance Checklist     
Total Hits: 244  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

In a previous tip we discussed 10 items that should be addressed to manage your SQL Server environment. These items included; backups, security, disaster recovery, etc... The third item on the list was to maintain indexes. There have been several tips on the MSSQLTips.com website about index maintenance, but we will take a look at a checklist of things to perform to ensure your indexes are not degrading performance on your system....

Modifying SQL Server database tables and keeping like columns together     
Total Hits: 197  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

When designing tables you may not always know what columns need to exist prior to when the table is created. Therefore over time table changes are made where you may add or drop columns. Based on this table modification you may want to have certain columns next to each other for easier management and grouping of like data in the table structure. It doesn't really matter to SQL Server where the column is located, but to us humans it sometimes makes a difference. Dropping a column is not a big ...

Different Options for Importing Data into SQL Server     
Total Hits: 194  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

Moving data into SQL Server is something that most DBAs or Developers are faced with probably on a daily basis. One simple way of doing this is by using the Import / Export wizard, but along with this option there are several other ways of loading data into SQL Server tables. Another common technique would be to use either DTS (SQL 2000) or SSIS (SQL 2005). In this tip we take a look at some of these other options for importing data into SQL Server....

SQL Server 2005 Row Versioning-Based Transaction Isolation     
Total Hits: 175  |  Today: 0Author: Kimberly L. Tripp, Neal Graves      Rating:  
Read Reviews | Write Review |  Your Rating: 

Microsoft SQL Server 2005 provides nonlocking, nonblocking read consistency to your users through snapshot isolation and read committed isolation using row versioning. Find out when you can use these features to improve performance and reduce latency in your applications....

Regular Expressions Make Pattern Matching And Data Extraction Easier     
Total Hits: 227  |  Today: 0Author: David Banister      Rating:  
Read Reviews | Write Review |  Your Rating: 

Although T-SQL is extremely powerful for most data processing, it provides little support for text analysis or manipulation. Attempting to perform any sophisticated text analysis using the built-in string functions results in massively large functions and stored procedures that are difficult to debug and maintain. Is there a better way?

In fact, regular expressions provide a much more efficient and elegant solution. It is easy to see how they would be helpful for comparing text to identif...

Interact with SQL Server's Data and Procedure Cache     
Total Hits: 1009  |  Today: 0Author: Randy Dyess      Rating:  
Read Reviews | Write Review |  Your Rating: 

As you work with SQL Server you have probably heard of the terms data cache and procedure cache and may have wondered what exactly a cache was. SQL Server is configure to use a pool of memory of the server and it will allocate the majority of this memory pool to hold both data pages that have been read and the compiled execution plans for all Transact-SQL statements. It is this dynamic pool of memory that is being referred to and the data cache and procedure cache, keep in mind that in versions ...



Disclaimer - Privacy
© 2002-2017 DevASP.net