Owner: SQL Server,MySQL,Oracle,.Net and Java articles URL:http://sqldbpool.blogspot.com/ Join Date: Sat, 31 May 2008 12:58:45 -0500 Rating:0 Site Description: Blog contains the number SQL Server, MySQL, Oracle, Java and .Net articles and interview questions Site statistics:Click here
Basics of ASP.NET 2008-05-30 08:58:00 When was ASP.NET released?
ASP.NET is a part of the .NET framework, which was released as a software platform in 2002. Is a new version coming up?
ASP.NET 2.0, Visual Studio 2005 (Whidbey), Visual Web Developer 2005 Express Edition are the next releases of Microsoft's Web platform and tools. They have already been released as Beta versions. They are scheduled to be released in the week of Nov Read more:Basics
New Types of Replication in SQL Server 2005 2008-05-29 08:21:00 New Types of Replication in SQL
Server 2005 Heterogeneous Replication New types of replications have been introduced in SQL Server
2005. The first of these is the Heterogeneous Replication which allows the publication of data from heterogeneous subscribers such as Oracle, DB2 using relevant ODBC drive and OLE DB provider. In SQL Server 2005 allows configuration of the snapshot and transaction re
Index Rebuilds in SQL Server 2000 verus SQL Server 2005 2008-05-29 08:20:00 Index Rebuilds in SQL
Server 2000 vs SQL Server
2005Below outlines the index rebuilding code changes from SQL Server 2000 to 2005 with the purpose of the code and a sample. SQL Server 2000 SQL Server 2005 CREATE INDEX with DROP_EXISTING - Creates a new index with the same name and drops the current index while ensuring the nonclustered indexes are not rebui Read more:Index
Copy_Only option with Backup command 2008-05-29 07:49:00 Copy_Only option
with backup A copy-only backup is a SQL Server backup that is independent of the sequence of conventional SQL Server backups. Usually, taking a backup changes the database and affects how later backups are restored. However, occasionally, it is useful to take a backup for a special purpose without affecting the overall backup and restore procedures for the database. For this purp Read more:command
Replication Agents 2008-05-28 07:25:00 Replication AgentsReplication uses a number of standalone programs, called agents, to carry out the tasks associated with tracking changes and distributing data. By default, replication agents run as jobs scheduled under SQL Server Agent, and SQL Server Agent must be running for the jobs to run. Replication agents can also be run from the command line and by applications that use Replication Manag
Replication in SQL Server 2005 2008-05-28 07:02:00 Replication is a set of technologies for copying and distributing data and database objects from one database to another and then synchronizing between databases to maintain consistency. Using replication, you can distribute data to different locations and to remote or mobile users over local and wide area networks, dial-up connections, wireless connections, and the Internet. Replication Types Read more:SQL
, SQL Server
SQL Server Fixed Database-Level Roles 2008-05-24 06:26:00 SQL Server FixedDatabase
-Level Roles Fixed database roles are defined at the database level and exist in each database. Members of the db_owner and db_securityadmin database roles can manage fixed database role membership; however, only members of the db_owner database role can add members to the db_owner fixed database role. The fixed database roles are the following: * Read more:SQL
, SQL Server
SQL Server 2005 Server-Level Fixed Roles 2008-05-24 05:43:00 SQL Server 2005 Server-Level Fixed
Roles Fixed server roles are server-wide in their scope. Each member of a fixed server role can add other logins to that same role The fixed server roles are: * bulkadmin * dbcreator * diskadmin * processadmin * securityadmin * serveradmin * setupadmin * sysadmin bulkadminMembers of the bulkadmin fixed server rol Read more:SQL
, SQL Server
T-SQL Enhancement in SQL Server 2005 2008-05-16 06:52:00 Q. What is CTE (Common Table Expression)?Ans: CTE is a temporary Table created from a simple SQL
query. You can say it’s a view. Below is a sample CTE created “PurchaseOrderHeaderCTE” from “PurchaseOrderHearder” With PurchaseOrderHeaderCTE (Orderdate, status) As(SELECT order date, statusFROM Purchasing.PurchasingOrderheader ) SELECT * FROM PurchasingOrderheader The WITH Statement defin Read more:SQL Server
.Net Integration with SQL Server 2005 2008-05-16 06:50:00 • What are steps to load a .NET code in SQL
SERVER 2005?Write the managed code and compile it to a DLL/Assembly.After the DLL is compiled using the “CREATE ASSEMBLY” command you can load the assemby into SQL SERVER. Below is the create command which is loading “mycode.dll” into SQL SERVER using the “CREATE ASSEMBLY” commandSyntaxCREATE ASSEMBLY AssemblyName FROM ‘C:/MyAssmbly.dll
DBMS/RDBMS Terms and keywords 2008-05-16 06:48:00 Data Mart - A single star schema, i.e. dimensions and a fact table that stores data at the detail level. A Data Mart covers a specific area of the business: billing, inventory, transactions, claims, etc. Data Modeling - Performing analysis on the business processes and data to discover attributes of, and relationships between, data elements. An Entity Relationship Diagram (ERD) is the implem Read more:Terms
SQL Server, Oracle and MySQL basic questions and answers 2008-05-16 06:46:00 1. What is database? A database is a logically coherent collection of data with some inherent meaning, representing some aspect of real world and which is designed, built and populated with data for a specific purpose. 2. What is DBMS? It is a collection of programs that enables user to create and maintain a database. In other words it is general-purpose software that provides the users with Read more:SQL
, SQL Server
, Oracle
, MySQL
, questions
, answers
SQL Server Database Coding Standards 2008-05-16 06:44:00 Databases are the heart and soul of many of the recent enterprise applications and it is very essential to pay special attention to database programming. I’ve seen in many occasions where database programming is overlooked, thinking that it’s something easy and can be done by anyone. This is wrong. For a better performing database you need a real DBA and a specialist database programmer, let i Read more:SQL
, SQL Server
, Database
, Coding
, Standards
MySQL Interview Questions and Answers 2008-05-16 06:43:00 How do you start and stop MySQL
on Windows? - net start MySQL, net stop MySQL How do you start MySQL on Linux? - /etc/init.d/mysql start Explain the difference between mysql and mysqli interfaces in PHP? - mysqli is the object-oriented version of mysql library functions. What’s the default port for MySQL Server? - 3306 What does tee command do in MySQL? - tee followed by a filenam
SQL Server DBA Checklist/Daily Activity of DBA 2008-05-16 06:42:00 1. Check OS Event Logs, SQL
Server Logs, and Security Logs for unusual events.2. Verify that all scheduled jobs have run successfully.3. Confirm that backups have been made and successfully saved to a secure location.4. Monitor disk space to ensure your SQL Server
s won’t run out of disk space.5. Throughout the day, periodically monitor performance using both System Monitor and Profiler.6. Use En Read more:Checklist
, Daily
, Activity
SQL Server 2000/2005 Interview Questions and Answers 2008-05-16 06:40:00 • What is a DDL, DML, DCL, TCL and DSPL concept in RDBMS world?The Data Definition Language (DDL) includes, CREATE TABLE - creates new database tableALTER TABLE - alters or changes the database tableDROP TABLE - deletes the database tableCREATE INDEX - creates an index or used as a search keyDROP INDEX - deletes an index The Data Manipulation Language (DML) includes, SELECT - extracts data Read more:SQL
, SQL Server
RDBMS Concepts 2008-05-16 06:38:00 • What is database or database management systems (DBMS)?A collection of programs that enables you to store, modify, and extract information from a database. There are many different types of DBMSs, ranging from small systems that run on personal computers to huge systems that run on mainframes.The following are examples of database applications:* computerized library systems* automated te Read more:Concepts
Disk Space Alerts using SQL Server 2005 2008-05-16 06:36:00 Step 1: Create the database mail profile account using SQL
Server Management Studio. Give the profile name to “FreeSpace
AlertMails” Step2: Create the below procedure in master database which will check the disk space. CREATE PROCEDURE sendAlertMailsASBEGINSET NOCOUNT ONDECLARE @availableSpace AS FLOATDECLARE @alertMessage AS Varchar(4000) CREATE TABLE #tbldiskSpace(driveName VARCHAR(3),f Read more:SQL Server
How to read transaction log data/file in SQL Server? 2008-05-16 06:35:00 We can’t read the transaction logs directly from SQL
Server. Some products do allow you to read the logs, such as: * Apex SQL Log (Works with MSSQL2000 and MSSQL2005)* Log Explorer* SQL Log Rescue (Only work with the SQL Server
2000) The below undocumented DBCC command is working in both SQL Server 2000 & SQL Server 2005 DBCC LOG([,{0|1|2|3|4}]) 0 - Basic Log Information (default)1 - L
How to read transaction log data/file in SQL Server 2008-05-16 06:35:00 We can’t read the transaction logs directly from SQL
Server. Some products do allow you to read the logs, such as: * Apex SQL Log (Works with MSSQL2000 and MSSQL2005)* Log Explorer* SQL Log Rescue (Only work with the SQL Server
2000) The below undocumented DBCC command is working in both SQL Server 2000 & SQL Server 2005 DBCC LOG([,{0|1|2|3|4}]) 0 - Basic Log Information (default)1 - L
XP_cmdshell extended stored procedure (Execute Winows commands) 2008-05-16 06:33:00 xp_cmdshell Executes a given command string or batch file as an operating-system command shell and returns any output as rows of text. Permission/Rights: Only SysAdmin fixed role can execute it. Syntax xp_cmdshell {‘command_string‘} [, no_output] Arguments ‘command_string‘ Is the command string to execute at the operating-system command shell or from DOS prompt. command_string is varchar( Read more:stored
GIS Data types in SQL Server 2008 2008-05-16 06:31:00 Microsoft’s SQL
Server 2008 offers new support for spatial data types
that some analysts say should deliver a real boost to geospatial applications and data sharing. Expected to ship in the third quarter, the new version of SQL Server
will allow storage of spatial data — in the form of points, lines and polygons — in SQL tables. The software will also offer a set of functions to
SQL Server 2005 System Databases 2008-05-16 06:21:00 Master Purpose - Core system database to manage the SQL
Server instance. In SQL Server
2005, the Master database is the logical repository for the system objects residing in the sys schema. In SQL Server 2000 and previous editions of SQL Server, the Master database physically stored all of the system objects.Prominent Functionality Per instance configurationsDatabases
residing on the instanceFiles Read more:System
SQL Server 2005 Interview Questions Answers 2008-05-16 06:05:00 • If I want to see what fields a table is made of, and what the sizes of thefields are, what option do I have to look for?Sp_Columns ‘TableName’ • What is a query?A request for information from a database. There are three general methods for posing queries:# Choosing parameters from a menu: In this method, the database system presents a list of parameters from which you can choose. T Read more:SQL
, SQL Server
Oracle Database Interview Question and Answers 2008-05-16 06:03:00 What is Log Switch? - The point at which ORACLE ends writing to one online redo log file and begins writing to another is called a log switch.What is On-line Redo Log? - The On-line Redo Log is a set of tow or more on-line redo files that record all committed changes made to the database. Whenever a transaction is committed, the corresponding redo entries temporarily stores in redo log buffe Read more:Database
, Oracle
, Question
SQL Server Configuration Settings for Performance Enhancement 2008-06-06 02:19:00 Configuration Settings
This article describes the following configuration settings and considerations for their use: • Affinity Mask• Lightweight Pooling• Max Async IO• Max Worker Threads• Memory• Priority Boost• Set Working Set SizeSQL
Server can obtain a very high level of performance with relatively little configuration tuning. You can obtain high levels of performance by using goo Read more:Configuration
, Performance
, SQL Server
Joins In SQL Server 2008-06-06 02:09:00 One of the trickiest things about learning SQL
is mastering how various JOIN statements differ in the ways they combine data from multiple data tables. There are three types of joins: inner, outer, and cross. In addition, there are three types of outer joins: left, right, and full. It can be frustrating trying to keep them differentiated, so here's a quick guide. All of the following examples invo Read more:SQL Server
Recommend Site To A Friend
