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)


How to perform case sensitive searches in SQL Server?     
Total Hits: 70  |  Today: 0Author: Narayana Vyas Kondreddi      Rating:  
Read Reviews | Write Review |  Your Rating: 

This is another one of those questions, that gets asked at least once a day in the Microsoft SQL Server programming newsgroups. Over the years, different programmers have come up with different solutions, and I'll be presenting some of those in this article.
A default SQL Server installation is case insensitive, which means that SQL Server will not differentiate between upper and lower case characters/letters. That is, "Oracle" is the same as "ORACLE" or "oracle". Let's see what controls this...

How to search all columns of all tables in a database for a keyword?     
Total Hits: 202  |  Today: 0Author: Narayana Vyas Kondreddi      Rating:  
Read Reviews | Write Review |  Your Rating: 

While browsing the SQL Server newsgroups, every once in a while, I see a request for a script that can search all the columns of all the tables in a given database for a specific keyword. I never took such posts seriously. But then recently, one of my network administrators was troubleshooting a problem with Microsoft Operations Manager (MOM). MOM uses SQL Server for storing all the computer, alert and performance related information. He narrowed the problem down to something specific, and neede...

Check the size of each table in your Database     
Total Hits: 202  |  Today: 0Author: DevASP      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article is about how you can check the size of each table in your database. Steps you will do. Open the Enterprise Manager and in your database create a new store procedure with any name that you wish. Copy and paste the following code in the body of store procedure save the store procedure and open the query analyzer. Call the store procedure and see the results. You will see the name of each table in your data base, number of rows in the table and size of the table in the data base, etc....

User Tips: Using Return Values from a SQL Server Stored Procedure to Customize Error Messages     
Total Hits: 188  |  Today: 0Author: Pete Draigh      Rating:  
Read Reviews | Write Review |  Your Rating: 

When I started developing web pages that interact with a SQL Server database, I probably started like everbody else: with inline SQL statements. I then progressed to using the connection object to call stored procedures and eventually started using the command object. I eventually realized how useful return values from stored procedures could be, since I could use them to return a value based on a potential error condition that I check for in the stored procedure....

Determine when to use stored procedures vs. SQL in the code     
Total Hits: 263  |  Today: 0Author: Tony Patton      Rating:  
Read Reviews | Write Review |  Your Rating: 

I once was pulled into a discussion about the merits of stored procedures versus placing SQL directly in the code. The atmosphere resembled a heated political debate, with each side presenting valid points. Here are both sides of the discussion. It's rare to tackle a development project that doesn't interact with a backend data source. After all, data is the lifeblood of an organization. When you create an application with a backend database like SQL Server, the Transact-SQL (T-SQL) programming ...

Error Locating Server/Instance Specified Error During Microsoft SQL Server 2005 Beta 2 April CTP Setup     
Total Hits: 115  |  Today: 0Author: Michael G.      Rating:  
Read Reviews | Write Review |  Your Rating: 

Server/Instance Specified error message. If you receive the error during installation of Microsoft SQL Server 2005 Beta 2 April CTP, perform the steps discuss in this article to resolve the issue. Read the article for further description!...

10 Things You Shouldn't Do with SQL Server (Data Access Developer "Don'ts")     
Total Hits: 121  |  Today: 0Author: Michael G.      Rating:  
Read Reviews | Write Review |  Your Rating: 

A very nice and common sense article regarding SQL Server best practices that some DBAs and developers unfortunately don't follow. Good job Doug!
I came across an article link today at TechWeb, 10 Things You Shouldn't Do with SQL Server (Data Access Developer "Don'ts"), that caught my eye. Now, while the article discusses don'ts that make perfectly common sense to me, you'd be surprised how many DBAs don't follow those kinds of best practices....

Some "Hints" for Mastering SQL Tuning     
Total Hits: 288  |  Today: 0Author: Raghu Donepudi      Rating:  
Read Reviews | Write Review |  Your Rating: 

Help your database optimize SQL queries by including hints in your SQL statements. Used correctly, hints can reduce the running time of your queries significantly....

Data Dictionary from within SQL Server 2000     
Total Hits: 175  |  Today: 0Author: Mindy Curnutt      Rating:  
Read Reviews | Write Review |  Your Rating: 

There is functionality within SQL Server 2000 that allows you to enter metadata on the columns in the SQL Server. In fact, the 'Description' field (shown below) is a meta data field that comes right with SQL Server. This functionality can be used to create a traditional "Data Dictionary" - allowing you to define the purpose of each column and then to list all the tables and columns (with their fully described purpose and meaning) in a Dictionary type fashion. The difficulty is generally not eas...

Worst Practices - Not Using Primary Keys and Clustered Indexes     
Total Hits: 182  |  Today: 0Author: Andy Warren      Rating:  
Read Reviews | Write Review |  Your Rating: 

Two weeks ago Andy started his wildly successful series on Worst Practices. This week he continues that series discussing why failing to use primary keys and clustered indexes are worst practices. Agree or disagree, read the article and join the discussion. One thing you'll have to admit, reading an article by Andy is a lot more interesting than reading Books Online!...

Getting the Most Out of SQL Server 2000's Query Analyzer, Part III     
Total Hits: 134  |  Today: 0Author: Brian Kelley      Rating:  
Read Reviews | Write Review |  Your Rating: 

In this article, Brian Kelley continues his series on Query Analyzer for SQL Server 2000. Query Analyzer offers a highly configurable integrated development environment (IDE). Some of the areas Brian looks at are how to modify the fonts and colors, set connection settings, choose scripting options, and customizing file and result set options. Learn how to make the most of the IDE and make it work for you....

Getting the Most Out of SQL Server 2000's Query Analyzer, Part II     
Total Hits: 125  |  Today: 0Author: Brian Kelley      Rating:  
Read Reviews | Write Review |  Your Rating: 

Brian Kelley continues his series on getting the most out of SQL Server 2000's Query Analyzer. In this article he looks at the Object Browser and the Transact-SQL Debugger, new features in the 2000 Edition which can reduce development and troubleshooting time for DBAs and database developers....

Getting the Most out of SQL Server 2000's Query Analyzer, Part I     
Total Hits: 164  |  Today: 0Author: Brian Kelley      Rating:  
Read Reviews | Write Review |  Your Rating: 

So you open up the tool a hundred times a day. In this article by Brian Kelley, he shows you how to get the most out of some of the known and unknown features....

Ways to Determine the Version and SP of SQL Server     
Total Hits: 139  |  Today: 0Author: Dinesh Priyankara      Rating:  
Read Reviews | Write Review |  Your Rating: 

There may be more ways than you realize to determine the version and service pack of SQL Server. This quick article by Dinesh Priyankara will show you 3 of those methods....

SQL - Articles / Scripts / Tips     
Total Hits: 699  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

SQLServerCentral.com offers a large repository of SQL Server articles from throughout the web....

SQL Tutorial & Tips     
Total Hits: 535  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article provides different tips and samples for Update query in SQL....

INF: How to Use the Linear Regression Functions (Q307276)     
Total Hits: 945  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article explains and illustrates the use of the following Linear Regression functions in a calculated member:
  • LinRegIntercept

  • LinRegPoint

  • LinRegR2

  • LinRegSlope

  • LinRegVariance


MORE INFORMATION


Linear Regression is a statistical method that predicts the value of one variable, based on knowledge of another variable and the statistical relationship between the two. The Linear Regression functions use the...


Using BULK INSERT to Load a Text File     
Total Hits: 3133  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This example combines dynamic SQL, BULK INSERT and the proper handling of double-quotes to solve a client's problem with loading various text file formats into a database....

Eleven Quick Tips for SQL Server     
Total Hits: 849  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

Learn quick and simple ways to check if a file exists on disk, shut down a remote machine without leaving your chair, recover databases without backups, and much more....

Using SMS with SQL 2000 Named Instances     
Total Hits: 633  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

When forced to use Named Instances (when running SQL 2000 in a cluster, for example), a problem can arise if you install SMS 2.0 or if you've recently reset the site. Since SMS is not Named Instance-aware, it won't be able to find and connect to your SQL server. Jeff Huston shows in this article how the Client Network Utility that comes with SQL 2000 can help solve the problem....



Disclaimer - Privacy
© 2002-2015 DevASP.net