<< < 14 15 16 17 18 19 20 21 22 23 24 > >>   Sort: Date

Understanding and Managing Indexes in SQL Server
Where to find answers to frequently asked questions on Understanding and Managing Indexes in SQL Server? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Understanding and Managing Indexes in SQL Server. Clear answers are provided with tutorial exe...
2016-11-15, 275👍, 0💬

UNIQUE Constraint Creating Default Index in SQL Server
Does the UNIQUE Constraint Create an Index in SQL Server? If you add the UNIQUE constraint on a column, SQL Server will automatically add a non-clustered index for that column. The tutorial exercise below shows you the index created as part of the UNIQUE column, "id", of "fyi_links": USE FyiCenterDa...
2016-11-13, 275👍, 0💬

Rebuilding All Indexes on One Table in SQL Server
How To Rebuild All Indexes on a Single Table in SQL Server? If you have several indexes on a single table and want to rebuild all of them, you may use the "ALTER INDEX ALL ON table_name REBUILD" statement as shown in the tutorial exercise below: USE FyiCenterData; GO UPDATE fyi_links_indexed SET url...
2016-11-08, 275👍, 0💬

Using Group Functions in the ORDER BY Clause in SQL Server
Can Group Functions Be Used in the ORDER BY Clause in SQL Server? If the query output is aggregated as groups, you can sort the groups by using group functions in the ORDER BY clause. The following statement returns the maximum "counts" in each group, determined by a unique combination of tag and ye...
2016-10-25, 275👍, 0💬

Security Principals Used in SQL Server 2005 in SQL Server
What Are Security Principals Used in SQL Server 2005 in SQL Server? SQL Server 2005 supports several basic security principals located at different levels: Windows-Level Principals: Windows Local Login and Windows Network Domain Login - Used to control accesses to SQL Server instances. SQL Server-Le...
2016-10-20, 275👍, 0💬

Close MySQL Connection Objects in MySQL
How To Close MySQL Connection Objects in MySQL? MySQL connection objects created with mysql_connect() calls should be closed as soon as you have finished all of your database access needs by calling mysql_close($con) function. This will reduce the consumption of connection resources on your MySQL se...
2017-11-11, 274👍, 0💬

Attaching AdventureWorksLT Physical Files to the Server in SQL Server
How to attach AdventureWorksLT physical files to the server in SQL Server? After installed the sample database AdventureWorksLT, you need to attach it to your SQL server to make it available by follow this tutorial: EXEC sp_attach_db @dbname=N'AdventureWorksLT', @filename1=N'C:\Program Files\Microso...
2016-12-02, 274👍, 0💬

Adding a New Index to a Large Table in SQL Server
What Happens If You Add a New Index to Large Table in SQL Server? An index can be added when you create a new table. New rows will be indexed as they are inserted into the table. But you can also add a new index to an existing table with the same CREATE INDEX statement. The existing rows will be ind...
2016-11-13, 274👍, 0💬

Using Multiple Columns in the GROUP BY Clause in SQL Server
Can Multiple Columns Be Used in GROUP BY in SQL Server? If you want to break your output into smaller groups, you can specify multiple column names or expressions in the GROUP BY clause. Output in each group must satisfy a specific combination of the expressions listed in the GROUP BY clause. The mo...
2016-10-25, 273👍, 0💬

Index Speeding Up SELECT Statements in SQL Server
Does Index Speed Up SELECT Statements in SQL Server? If you want to see the impact of indexes on SELECT statements, you can run the same SELECT statement on "fyi_links" and "fyi_links_indexed" tables. See the tutorial exercise below: USE FyiCenterData; GO -- Run SELECT on the table without indexes D...
2016-11-13, 272👍, 0💬

Rolling Back the DDL Statement in a Trigger in SQL Server
Can You Roll Back the DDL Statement in a Trigger in SQL Server? Can you roll back the DDL statement in a trigger? The answer is yes. Since the DDL statement that fires the trigger and the statements defined inside the trigger are all executed as a single statement batch, you can add a ROLLBACK state...
2016-10-22, 271👍, 0💬

PHP Connections and Query Execution for MySQL
Where to find answers to frequently asked questions on PHP Connections and Query Execution for MySQL? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on PHP Connections and Query Execution in MySQL. Clear explanations and tutorial exercises are provi...
2017-11-25, 270👍, 0💬

Number of Rows Selected or Affected in MySQL
How To Get the Number of Rows Selected or Affected by a SQL Statement in MySQL? There are two functions you can use the get the number of rows selected or affected by a SQL statement: mysql_num_rows($res) - Returns the number of rows selected in a result set object returned from SELECT statement. my...
2017-10-08, 270👍, 0💬

System Requirements for SQL Server 2005 Express Edition in SQL Server
What are the requirements to install SQL Server 2005 Express Edition in SQL Server? The following system requirements cover the SQL Server 2005 Express Edition: Processor 32-bit Processor of 600-megahertz (MHz) or faster Operating System Windows XP with Service Pack 2 or later Windows 2000 Professio...
2016-12-08, 270👍, 0💬

Installing SQL Server 2005 Express Edition in SQL Server
How to install SQL Server 2005 Express Edition in SQL Server? Once you have downloaded SQL Server 2005 Express Edition, you should follow this tutorial to install it on your system: 1. Double click SQLEXPR.EXE. The setup window shows up. 2. Click Next to let the setup program to unpack all files fro...
2016-12-08, 270👍, 0💬

Using Subqueries with the EXISTS Operators in SQL Server
How To Use Subqueries with the EXISTS Operators in SQL Server? A subquery can be used with the EXISTS operator as "EXISTS (subquery)", which returns true if the subquery returns one or more rows. The following statement is a good example of "EXISTS (subquery)". It returns rows from fyi_links table t...
2016-10-29, 270👍, 0💬

Sorting Query Output with ORDER BY Clauses in SQL Server
How To Sort the Query Output with ORDER BY Clauses in SQL Server? If you want the returning rows to be sorted, you can specify a sorting expression in the ORDER BY clause. The simplest sort expression is column name who's values will be sorted by. The following select statement returns rows sorted b...
2016-10-26, 270👍, 0💬

"AS" - Naming Query Output Columns in SQL Server
How To Name Query Output Columns in SQL Server? Each column in the query output has a default name. If you don't like the default name, you can specify a new name for any column in the query output by using the AS clause. The following statement shows you a good example: SELECT tag AS Category, YEAR...
2016-10-29, 269👍, 0💬

Creating a Logon Trigger in Express Edition in SQL Server
Can You Create a Logon Trigger in SQL Server 2005 Express Edition in SQL Server? Can you create a logon trigger in SQL Server 2005 Express Edition? The answer is no. LOGON is not a supported event type in Express Edition. The script below shows you the error message when you try to create a logon tr...
2016-10-22, 269👍, 0💬

Modes of Data Dump Export and Import in Oracle
What Are Data Pump Export and Import Modes in Oracle? Data Pump export and import modes are used to determine the type and portions of database to be exported and imported. Oracle 10g supports 5 export and import modes: Full: Exports and imports a full database. Use the FULL parameter to specify thi...
2016-10-15, 269👍, 0💬

Group Functions with Non-group Selections in MySQL
Can Group Functions Be Mixed with Non-group Selection Fields in MySQL? If a group function is used in the SELECT clause, all other selection fields must be group level fields. Non-group fields can not be mixed with group fields in the SELECT clause. The script below gives you an example of invalid S...
2017-10-16, 268👍, 0💬

What Is Commit in MySQL
What Is Commit in MySQL? Commit is a way to terminate a transaction with all database changes to be saved permanently to the database server.   ⇒Database Basics and Terminologies in MySQL ⇒⇒MySQL Database Tutorials
2016-10-16, 268👍, 0💬

"CREATE TABLE" Statement - Creating New Tables in SQL Server
How to create new table with "CREATE TABLE" statements in SQL Server? This is the second tutorial of a quick lesson on creating database objects with Transact-SQL statements. This lesson shows you how to create a database, create a table in the database, and then access and change the data in the ta...
2016-12-02, 267👍, 0💬

"sp_columns" - Getting a List of Columns in a Table in SQL Server
How To Get a List of Columns using the "sp_columns" Stored Procedure in SQL Server? If you have an existing table, but you don't remember what are the columns defined in the table, you can use the "sp_columns" stored procedure to get a list of all columns of the specified table. The following tutori...
2016-11-17, 267👍, 0💬

<< < 14 15 16 17 18 19 20 21 22 23 24 > >>   Sort: Date