Atlanta Custom Software Development 

 
   Search        Code/Page
 

User Login
Email

Password

 

Forgot the Password?
Services
» Web Development
» Maintenance
» Data Integration/BI
» Information Management
Programming
VB VB (1648)
VB.net VB.net (736)
C# C# (15)
ASP.net ASP.net (779)
ASP ASP (41)
VC++ VC++ (25)
PHP PHP (0)
JAVA JAVA (4)
JScript JScript (5)
  Database
» SQL Server (708)
» ORACLE (5)
» MySQL (0)
» DB2 (0)
Automation
» C/C++/ASM (11)
» Microcontroller (1)
» Circuit Design (0)
OS/Networking
» Networking (5)
» Unix/Linux (1)
» WinNT/2k/2003 (8)
Graphics
» Flash (0)
» Maya (0)
» 3D max (0)
» Photoshop (0)
Links
» ASP.net (2)
» PC Interfacing (1)
» Networking (4)
» SQL Server (4)
» VB (23)
» VB.net (4)
» VC (3)
» HTML/CSS/JavaScript (10)
Tools
» Regular Expr Tester
» Free Tools

Submitted By : Nayan Patel  (Member Since : 5/26/2004 12:23:06 PM)

Job Description : He is the moderator of this site and currently working as an independent consultant. He works with VB.net/ASP.net, SQL Server and other MS technologies. He is MCSD.net, MCDBA and MCSE. In his free time he likes to watch funny movies and doing oil painting.
View all (893) submissions by this author  (Birth Date : 7/14/1981 )

This is a link to a different site How can I eliminate or reduce locking?
Total Hit (1872) Here are some resources that provide help with blocking issues in SQL Server.
Rating
This is a link to a different site Determining Table sizes, Index size, Total Rows
Total Hit (1126) Ever wanted to find out the amount of space a table is taking up (in Kilobytes, not record size... although you will be able to get the record size too this way).
Rating
How to Use Batch Size to Speed Mass Updates, Inserts and Deletes reducing locks require for operation.
Total Hit (2609) It is often necessary to perform mass updates, inserts, or deletes on a table or tables. If the action involves thousands to millions of rows, performance can bog down and the transaction log can grow very large, consuming much available disk space. In fact, updating millions of rows in one query ma ....Read More
Rating
This is a link to a different site Using Lock Escalation to Improve Update Query Performance
Total Hit (2017) Lock escalation is the process of converting many fine-grain locks into fewer coarse-grain locks, reducing system overhead.
Rating
This is a link to a different site using NT Authentication to login into SQL
Total Hit (1169) This is for using NT authentication (NT users already setup in the Domain) So you need to get the correct spelling of each user in User Manager for Domains. Then it will get the user from NT when they log in and bingo they have permissions to the SQL server database too. ....Read More
Rating
This is a link to a different site How can I script my SQL Server databases from Visual Basic?
Total Hit (989) You can use SQLDMO (SQL Distributed Management Objects) in VB to script a SQL Server database. There is a VB example included on the SQL 2000 install CD. If you installed the SQL Server developer tools, you should be able to find the sample code in... ....Read More
Rating
This is a link to a different site How do I script all the objects from all databases on a server and record changes
Total Hit (2324) This is for an uncontrolled environment where developers are allowed to change SPs without change control. I would suggest to run the procedure every night.
Rating
This is a link to a different site How Can I Obtain "Rows Affected" by Execution of a Dynamic SQL Statement?
Total Hit (770) When a SQL statement is executed using the Execute command, it is not possible to obtain the rows affected count. At least I've not been able to find a way to obtain this value.
Rating
This is a link to a different site Sysprocesses table definition
Total Hit (792) The sysprocesses table holds information about processes running on Microsoft® SQL Server™. These processes can be client processes or system processes. sysprocesses is stored only in the master database.
Rating
This is a link to a different site JOIN Fundamentals
Total Hit (735) Very often we need to pull data from 2 or more sources (tables or views) and combined them into 1 logical unit. There is often a bit of confusion on when and how to use them. I will first describe each JOIN type and how it works with the 2 tables involved. The major JOIN types are color cod ....Read More
Rating
This is a link to a different site fn_formatdatetime (Format a datetime variable with a user-defined string)
Total Hit (1033) This UDF will take a datetime variable and a varchar format string variable. It will then pass back the date/time formated according to the format string. This is similar to the CONVERT function, but you are not limited to the predefined types of it. It works more like the Format function of VB/V ....Read More
Rating
This is a link to a different site Tutorial : Programming in Visual Basic
Total Hit (946)
Rating
This is a link to a different site Tutorial : Using DLLs and The Windows API
Total Hit (2378) Windows provides a number of function calls, in the form of DLLs, that are useful to VB programmers. You can also co-opt DLLs from other programs to do work for you. We'll concentrate on using the Windows DLLs here, but what we learn is widely applicable ....Read More
Rating
This is a link to a different site Creating and using your own VC++ dlls
Total Hit (1007) Using the Windows API is a wonderful way to speed up your applications when they need to perform processor intensive tasks like graphics manipulation. However, the Windows API doesn’t always provide all the functionality you need for your application. Perhaps some 3rd party control does what you wan ....Read More
Rating
This is a link to a different site Tutorial : Drawing & Animation
Total Hit (1565) These tutorials are were originally developed as part of a VB Game Programming for beginners book Soren and I were working on. For a variety of reasons the book idea never came to fruition and so we decided to post the material that is finished as a series of tutorials in the hopes that you would fi ....Read More
Rating
This is a link to a different site Tutorial : Sound & Games
Total Hit (1746) These tutorials are were originally developed as part of a VB Game Programming for beginners book Soren and I were working on. For a variety of reasons the book idea never came to fruition and so we decided to post the material that is finished as a series of tutorials in the hopes that you would fi ....Read More
Rating
This is a link to a different site Using the Joystick, Mouse and Keyboard
Total Hit (2214) So far we have learned how to move, animate and do some other stuff to sprites. We have also looked into the area of sound playback in games. This is all very nice if you want to create a game with no human interaction. Since this is most likely not the kind of game you want to make, then you need t ....Read More
Rating
This is a link to a different site Get Disk Information for any Machine In the selected Domain
Total Hit (1190) This is a project that enumerates drive details on remote NT systems, but is not limited by GetDriveSpace's 2.0 GB limit. It uses GetDriveSpaceEx and the Currency Data Type (multiplied by 10000) to accurately return large drive sizes. It enumerates all NT workstations and servers and propagates a se ....Read More
Rating
This is a link to a different site Enumrate Local or Remote Disks
Total Hit (1772) VB example of using the NetServerDiskEnum API call from within VB. It returns a list of disk drives on a machine (local or remote). Author: Michael S. Jones
Rating
This is a link to a different site NT and Net Error messages in an Access Database. Author: Rob Agnew
Total Hit (991)
Rating
This is a link to a different site GetLastErr
Total Hit (1047) This code snippet returns any error codes from net related functions and system related functions. Author: Elvio Serrao
Rating
This is a link to a different site An example of how to read the Windows NT event viewer on local and remote machine. Author: Gianluigi Cosari
Total Hit (1079)
Rating
This is a link to a different site A NT eventlog monitor with filters, and many options. Author: Richard Puckett
Total Hit (2339)
Rating
This is a link to a different site This is simple and scaled down example of how to register a program to the NT eventlog and write to the log. The registration is based on L.J. Johnsons code. Author: Morten Brun
Total Hit (1046)
Rating
This is a link to a different site The best example of how to read from the NT eventlog.
Total Hit (2391)
Rating
This is a link to a different site The best example of how to write to the NT eventlog. Done by VB/NT specialist L.J. Johnson. You will find his webpage on the link page. Author: L.J.Johnson
Total Hit (2378)
Rating
This is a link to a different site MS SQL Server Distributed Partitioned Views
Total Hit (948) Don Schlichting explores the use of Distributed Partitioned Views for accessing multiple MS SQL Severs when configured as a Federated Database.
Rating
This is a link to a different site A better Soundex code
Total Hit (1118) Terms that are often misspelled can be a problem for database designers. Names, for example, are variable length, can have strange spellings, and they are not unique. American names have a diversity of ethnic origins, which give us names pronounced the same way but spelled differently and vice versa ....Read More
Rating
This is a link to a different site How do I use the new table variables in SQL Server 2000?
Total Hit (727) Table variables did not work for me until I started using an alias for the table variable when I had to qualify column names of a table variable.
Rating
This is a link to a different site How do I set up and configure SQL Mail?
Total Hit (1261) SQL Mail provides a way to send EMail from Micosoft SQL Server. The focus of this FAQ is configuration of SQL Mail. There are other ways to send Email from SQL Server. Links to articles about these alternatives to SQLMail are listed at the end of this FAQ. ....Read More
Rating


(Page 60 of 133) 3968 Result(s) found  ... 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 ...

Home   |  Comment   |  Contact Us   |  Privacy Policy   |  Terms & Conditions   |  BlogsZappySys

© 2008 BinaryWorld LLC. All rights reserved.