Search Results

Search found 32226 results on 1290 pages for 'sql community'.

Page 425/1290 | < Previous Page | 421 422 423 424 425 426 427 428 429 430 431 432  | Next Page >

• SQL Server Column Considerations and Column Placement

  Determining which columns to select for your indexes is critical. Having a little knowledge of how your application is using your database columns and how SQL Server processes indexes helps you make good decisions when you create your indexes.

  Read the article

• Stairway to T-SQL DML Level 11: How to Delete Rows from a Table

  You may have data in a database that was inserted into a table by mistake, or you may have data in your tables that is no longer of value. In either case, when you have unwanted data in a table you need a way to remove it. The DELETE statement can be used to eliminate data in a table that is no longer needed. In this article you will see the different ways to use the DELETE statement to identify and remove unwanted data from your SQL Server tables.

  Read the article

• Physical Join Operators in SQL Server - Nested Loops

  SQL Server implements three different physical operators to perform joins. In this article series we will examine  how each  operators works, its advantages and challenges. We will try to understand the ... [Read Full Article]

  Read the article

• Exploring Derived Column Transformation in SQL Server Integration Services

  Marcin Policht examines SQL Server Integration Services' component, Derived Column Transformation,and how its usefulness is enhanced by its ability to implement fairly elaborate mathematical, logical, and string operations.

  Read the article

• SQL Server 2012 Integration Services - Implementing Package Security using Access Control

  SQL Server 2012 Integration Services offers a wide range of powerful features that allow you to streamline and automate tasks involving data extraction, transformation, and loading. However, incorporating these features into your existing business intelligence framework frequently necessitates additional security measures ensuring that data which is being processed remains protected from unauthorized access.

  Read the article

• How to Evict a Failed Node and Add it Back to SQL Server 2005 Cluster

  Adding and removing nodes in SQL Server Clusters is not so difficult, and instructions on how to do so abound on the internet. However, mismanagement when adding/removing nodes can quickly become a 'gotcha' that wastes time. Bo Chen offers insight into some of those scenarios that are not normally covered in the standard online documents.

  Read the article

• How to Optimize Stored Procedures

  - by Derek D.

  There are many factors to speeding up stored procedures. Knowing these in advance can save you and your company many hours of headaches. Using these practices when writing procedures, you can turn your SQL Server into a fine-tuned machine. This tutorial will cover the specifics to help you tune your procedures optimally. Know [...]

  Read the article

• T-SQL: Why “It Depends”

  Why does everyone use "it depends" as an answer to many T-SQL questions? Bob Hovious brings us a short example of how performance can change based on data loads for the same code.

  Read the article

• Get Performance Tips Directly From SQL Server

  This article describes a utility that allows you to inspect cached plans and extract information that can be useful in improving the performance of your SQL.

  Read the article

• Import and Export Registered SQL Servers To Other Machines

  I need to setup other computers the same way that are used to manage my SQL Servers. Instead of having to manually add the registered servers on each computer in this tip I show you how you can import and export registered servers between computers.

  Read the article

• Stairway to T-SQL DML Level 9: Adding Records to a table using INSERT Statement

  Not all applications are limited to only retrieving data from a database. Your application might need to insert, update or delete data as well. In this article, I will be discussing various ways to insert data into a table using an INSERT statement. Need to share database changes?Keep database dev teams in sync using your version control system and the SSMS plug-in SQL Source Control. Learn more.

  Read the article

• Using SQL Server Concatenation Efficiently

  This article shares some tips on using concatenation efficiently for application development, pointing out some things that we must consider and look at when concatenating values or fields in our queries or stored procedures. NEW! Never waste another weekend deployingDeploy SQL Server changes and ASP .NET applications fast, frequently, and without fuss, using Deployment Manager, the new tool from Red Gate. Try it now.

  Read the article

• SQL Azure - Creating backups and copies of your databases

  As a DBA you always followed a practice to back up your database (or take a snapshot of your database) before making any changes so that you can revert to your old database state if something goes wrong. Also to setup a development or test environment you use a backup of your database and restore it in the respective environment. If you are moving to SQL Azure, what would you do in these cases as backup / restore and database snapshots are not supported as of now?

  Read the article

• New SQL Monitor Custom Metric: Database Autogrowth

  This metric for Red Gate SQL Monitor measures the number of database autogrowth events (data file or log file) in the last hour. Too many autogrowth events causes disk fragmentation which requires a change in the autogrowth settings of a database. ‘Disturbing Development’Grant Fritchey & the DBA Team present the latest installment of the Top 5 hard-earned lessons of a DBA – read it now

  Read the article

• Help us improve SQL Source Control

  We've been working really hard on SQL Source Control, and need your input. We're currently working on suggestions from our user forum and on an updated migrations feature that supports all source control systems and works across branches. We'd love it if you could spare 10 minutes to complete this survey. If you complete the survey by Friday June 14, you could win a $100 Amazon voucher. There are two up for grabs!

  Read the article

• SQL Saturday #41 - Register and Call for Speakers

  If you'll be near Atlanta on Apr 24, 2010, come to SQL Saturday #41. If you are at all interested in speaking, submit a session.

  Read the article

• Simplified Restores with SQL Server 2012 Recovery Advisor

  Occasionally, a DBA may need to restore a database from a multiple backup files that originated from multiple servers. This requirement might arise, for example, in a database-mirroring configuration, where backups may be from either of the servers. Get smart with SQL Backup ProGet faster, smaller backups with integrated verification.Quickly and easily DBCC CHECKDB your backups. Learn more.

  Read the article

• Running SQL Server Jobs using a Proxy Account

  Proxy accounts are a useful tool to enable teams to work independently allow users who do not have administrative access to SQL Server to run jobs.

  Read the article

• SQL Server 2008 - Accessing Audit Details

  Learn how to use the SQL Server 2008 catalog view and dynamic management view to access the audit details of existing server and database level audits.

  Read the article

• AlwaysOn Availability Groups in SQL Server 2012

  This article discusses and demonstrates AlwaysOn Availability groups in SQL Server 2012, a new feature for high availability. Keep your database and application development in syncSQL Connect is a Visual Studio add-in that brings your databases into your solution. It then makes it easy to keep your database in sync, and commit to your existing source control system. Find out more.

  Read the article

• Using SQL Server Default Trace

  What is Default Trace? A default trace in SQL Server is a standard server side trace which is installed by default ... [Read Full Article]

  Read the article

• Working with Queues in SQL Server

  This article shows sow to create a queue from a SQL table to serve each operator exactly one item from the queue that has not been picked up by any other.

  Read the article

• Stairway to SQL Dialects Level 3: MySQL

  As part of the LAMP stack, MySQL is incredibly important for providing a reliable and platform-agnostic database platform for web development. This level looks at the syntax of MySQL and how to best port SQL code to a MySQL environment. NEW! The easiest way to deploy .NET codeDeploy ASP.NET applications fast, frequently, and without fuss, using Deployment Manager, the new tool from Red Gate. Try it now.

  Read the article

• [MSBuild] Can not run MSBuild Community Task 'WebDirectoryDelete' and 'WebDirectoryCreate'

  - by Nam Gi VU

  I have a new default ASP.net website and use MSBuild Community Task WebDirectoryDelete to delete and WebDirectoryCreate to create the IIS virtual directory. I can't get it done. It raise error : Unknow error 0x80005000. I retry by running the msbuild under "Run as Administrator" but the errors still appear. I'm using Windows 7 and dotNet Framework 3.5 Please help.

  Read the article

• Is there a standalone community website application which one can easily populate with a Ning conten

  - by fivebells

  Ning provides a structured content dump of Ning sites when requested. I was wondering whether a) the schema for this dump is publically specified and b) any open-source web applications can use such a dump to populate a community website.

  Read the article

< Previous Page | 421 422 423 424 425 426 427 428 429 430 431 432  | Next Page >