Tutorials,Articles,Algorithms,Tips,Examples about Database

Change page: < 1 2 3 4 5 6 7 8 9 10 11 > | Displaying page 7 of 11, items 241 to 280 of 433.

Programming Microsoft SQL Server 2005 : FOR XML Commands (part 2) - FOR XML EXPLICIT

FOR XML EXPLICIT is the most complex but also the most useful and flexible of the three options. It produces XML by constructing a UNION query of the various levels of output elements.

Programming Microsoft SQL Server 2005 : FOR XML Commands (part 1) - FOR XML RAW & FOR XML AUTO

FOR XML RAW produces what we call attribute-based XML. FOR XML RAW essentially creates a flat representation of the data where each row returned becomes an element and the returned columns become the attributes of each element.

SQL Server 2008 : Audit-Related Startup and Shutdown Problems

When either the ON_Failure = On or Shutdown Server on Audit Log Failure option is checked, SQL Server will not start if it cannot initialize the target for an audit or if it cannot write to the target of an audit.

SQL Server 2008 : Creating SQL Server Audits Using the GUI

Since you know how to create SQL Server audits and add server and database audit specifications using T-SQL, we would like to spend a brief moment on the creation of SQL Server audits from SQL Server Management Studio.

SQL Server 2008 : Creating Database Audit Specifications

Database-level audit action groups consist of actions against a specific database. Database-level audit actions enable you to monitor actions on database, schemas, and schema objects within the database.

Programming Microsoft SQL Server 2005 : The XML Data Type (part 3) - XML Indexes

There are four types of XML indexes: a single “primary XML index” that must be created and three types of optional “secondary XML index” that are created over the primary index

Programming Microsoft SQL Server 2005 : The XML Data Type (part 2) - XML Schemas

One powerful feature of XML is its ability to strongly type the data in an XML document. XML Schema Definition (XSD) defines a standard set of data types that must be supported in all XML documents.

Programming Microsoft SQL Server 2005 : The XML Data Type (part 1) - Working with the XML Data Type as a Variable & Working with XML in Tables

There are some limitations of the XML data type that you should be aware of. Although this data type can contain and be checked for null values, unlike other native types, you cannot directly compare an instance of an XML data type to another instance of an XML data type

SQL Server 2008 : Auditing SQL Server - Creating Server Audit Specifications

The server audit specifications are tracked across the entire instance of SQL Server. There are not any boundaries within the SQL Server instance

SQL Server 2008 : Auditing SQL Server - Creating SQL Server Audits with T-SQL

The audit does not contain any information about the actions either at the database level or the server level within its definition

Programming Microsoft SQL Serve 2005 : An Overview of SQL CLR - Security

Depending on the deployment method, you have numerous ways to specify what security level to grant a CLR assembly.

Programming Microsoft SQL Serve 2005 : An Overview of SQL CLR - CLR Aggregates

The SQL CLR features in SQL Server 2005 allow us to implement user-defined aggregates in .NET code and use them from T-SQL

SQL Server 2008: Monitoring Resource Governor

Resource Governor monitors provide you with the essential data needed to alter and adapt your configuration based on informed decisions instead of just making random configuration changes and hoping for the best.

SQL Server 2008: Managing Resources with the Resource Governor (part 3) - Classifier Function

The classifier function is a T-SQL function that is executed for each login, which allows you to write logic to route incoming requests to the appropriate workload group.

SQL Server 2008: Managing Resources with the Resource Governor (part 2) - Workload Groups

The Resource Governor uses workload groups as a way to segregate all incoming requests that have predefined common characteristics together as a single unit.

SQL Server 2008: Managing Resources with the Resource Governor (part 1) - Resource Pools

Resource pools are based on the memory and CPU that is available to the SQL Server instance where you are configuring the Resource Governor, not the total resources available to the OS.

SharePoint 2010 : SQL Backup Tools

Although the backup options out-of-the-box in SharePoint give an array of tools to back up the configuration and the content databases; critical SQL Server databases such as Master, MSDB, and TempDB cannot be backed up by these tools from within SharePoint.

Windows Azure : Storing static reference data with dynamic data

Regardless of your chosen storage platform (SQL Azure or the Table service), you should consider caching static data rather than continually retrieving the same data from a table

SQL Server 2008 : Managing Query Performance - Adding Hints Through Plan Guides

SQL Server 2008 has actually taken plan guides a step further so that you can provide an entire XML query plan as a query hint.

SQL Server 2008 : Managing Query Performance - Forcing a Specific Execution Plan

Plan forcing is useful when the query optimizer will not produce an optimal execution plan for a query, even though you know a better execution plan is available.

Programming Microsoft SQL Server 2005 : An Overview of SQL CLR - CLR Triggers

T-SQL triggers are really just stored procedures that are called by SQL Server at specific times and query values in the “inserted” and “deleted” pseudo-tables.

Programming Microsoft SQL Server 2005 : An Overview of SQL CLR - CLR Functions

As any programmer knows, a function is a lot like a procedure, except that it returns a value (or an object) . Mainstream .NET functions typically return .NET types. SQL CLR functions, on the other hand, must return a SqlType

SQL Server 2008 : Performance Tuning - Using Dynamic Management Views

Dynamic Management Views (DMVs) are almost certainly the single most useful tool for troubleshooting and performance tuning SQL Server databases.

SQL Server 2008 : Performance Tuning - Working with Database Tuning Advisor

The Database Tuning Advisor (DTA) is a tool provided with SQL Server to help Developers and System Administrators improve query performance by optimizing physical design structures such as indexes, indexed views, and table partitioning.

SQL Server 2008 : Performance Tuning - Tracing with SQL Profiler

If SQL Server is running on a shared server (perhaps with a third-party application or Web server such as Internet Information Services), System Monitor can help you find the process consuming resources.

SQL Server 2008 : Performance Tuning - Working with Query Execution Plans

An execution plan is a plan containing the steps SQL Server works through in order to satisfy a query. Most stored procedures or ad hoc Transact-SQL queries access more than one table, and most tables have a clustered index and usually multiple non-clustered indexes.

Externalizing BLOB Storage in SharePoint 2010 (part 2) - Installing and Configuring RBS & Migrating and Moving BLOBs Between BLOB Stores

Administrators can use the following procedure to install and configure the BLOB externalization in SharePoint 2010 using RBS and the RBS FILESTREAM provider

Externalizing BLOB Storage in SharePoint 2010 (part 1)

Remote BLOB Storage (RBS) is a library API set designed to move storage of large binary data (BLOBs) from Microsoft SQL Server to external storage solutions.

Sharepoint 2010 : Managing SharePoint Content Databases

Some of these tasks can be completed directly from central administration; others can be done only via PowerShell or the deprecated STSADM command-line utility

Sharepoint 2010 : Maintaining SQL Server in a SharePoint Environment

To keep SharePoint operating smoothly and with optimal performance, it is highly recommended that SharePoint administrators conduct regular maintenance on each SQL Server database

Sharepoint 2010 : Monitoring SQL Server in a SharePoint Environment

Understanding monitoring strategies and tools enables administrators to shift from reactively dealing with issues to proactively troubleshooting and fixing problems before the server gets to the point where end users are impacted

Database Availability Group Replication in Exchange Server 2010 : Load Balancing in Exchange Server 2010

Another high-availability technology provided with the Windows Server 2008 platform is Network Load Balancing (NLB). NLB clusters provide high network performance and availability by balancing client requests across several server systems.

Database Availability Group Replication in Exchange Server 2010 : Comparing and Contrasting DAG Versus CCR/SCR/SCC

For administrators coming from an Exchange Server 2003 or Exchange Server 2007 environment looking to upgrade to Exchange Server 2010, it may prove useful to compare and contrast Database Availability Groups to existing replication technologies that one might already be familiar with.

SQL Server 2008: Managing Query Performance - Forcing Index Seeks

The query optimizer does a really good job deciding whether a seek or scan is more efficient, but in certain scenarios you may want to override the execution plan's decision.

Exchange Server 2010 : Deploying a Database Availability Group (part 4)

Many Exchange Server administrators have embraced the Exchange Management Shell as the preferred tool for configuration. Doing things via the shell has many advantages

Exchange Server 2010 : Deploying a Database Availability Group (part 3)

Many Exchange Server administrators have embraced the Exchange Management Shell as the preferred tool for configuration. Doing things via the shell has many advantages

Exchange Server 2010 : Deploying a Database Availability Group (part 2) - Suspending and Reseeding a Database

In the event that a replica of a mailbox database should become out of sync with the primary copy, it becomes necessary to reseed the database in order to resume the replication of log files

Exchange Server 2010 : Deploying a Database Availability Group (part 1) - Creating the File Share Witness

One of the components required for this function is a file share witness. Administrators familiar with Exchange Server 2007 may recall that a file share witness acts like a voting node in a cluster, specifically a Majority Node Set cluster

Database Availability Group Replication in Exchange Server 2010 : Understanding Database Availability Groups

A Database Availability Group is a group of up to 16 Exchange Server 2010 mailbox role servers that replicate mailbox data to each other and that can perform automated recovery at the mailbox database level in the event of a hardware, storage, or network failure.

SQL Server 2008 : Managing Query Performance - Optimizing for Specific Parameter Values

The OPTIMIZE FOR query hint was introduced in SQL Server 2005 to allow you to specify a value the query optimizer will use when creating an execution plan for parameterized queries