Microsoft SQL Server 2005

Email Alerts

Register now to receive SearchSQLServer.com-related news, tips and more, delivered to your inbox.
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

  • Create DDL table in SQL Server 2005 to audit DDL trigger activity

    Each time DDL statements in SQL Server 2005 make changes with commands, such as CREATE TABLE and ALTER, the DDL trigger fires an event. It's possible to log these events with an audit table and custom-made DDL trigger. In this tip, SQL Server expert ...  Tip

  • How to process SQL Server 2005 Analysis Services for data availability

    When processing very large databases in Analysis Services and ensuring users access to data, you can break a cube's measure group into manageable chunks. In this tip, contributor Baya Pavliashvili looks at Analysis Services partition processing optio...  Tip

  • Configure SQL Server Service Broker for sending stored procedure data

    The Service Broker feature in SQL Server 2005 allows you to queue data of stored procedures and other application development components. Instead of processing the data, it's sent to a queue where it can be automatically read at a later date and proc...  Tip

  • SQL Server 2005 log shipping setup using the wizard

    When you set up log shipping in SQL Server 2005, there are many options to choose from to get the optimal configuration between primary and secondary servers. Along with some best practices, SQL Server MVP Hilary Cotter shares a log shipping setup pr...  Tip

  • Retrieve XML data values with XQuery in SQL Server 2005

    When you want to access specific XML data values -- instead of XML as a single data type value -- the XQuery is the scripting language you're looking for. Microsoft designed XQuery specifically to access XML data in SQL Server 2005, allowing you to r...  Tip

  • Track changes to SQL Server 2000 and 2005 with one simple utility

    As a DBA, you need to be aware of what's happening within your SQL Servers. But if you have dozens of SQL Servers -- both 2000 and 2005 models -- and permissions are shared, you'll have to go beyond the limits of triggers.  Tip

  • Create an upgrade plan for your move to SQL Server 2005

    The best way to move from SQL Server 2000 to SQL Server 2005 is to map it out in phases. Here's a project plan with key points to consider at each upgrade phase, such as differences in print statements, testing during QA, preparing for rollback and c...  Tip

  • Five sqlcmd features to automate SQL Server database tasks

    Make your life easier with the sqlcmd tool in SQL Server 2005 that automates administration and maintenance via scripting. In this tip, you'll get five useful features and examples to execute sqlcmd commands, such as for utilizing and populating vari...  Tip

  • Simplify queries with SQL Server 2005 common table expressions (CTEs)

    Common table expressions (CTEs) are a handy alternative to using derived tables and views in SQL Server 2005 for retrieving data. There's no need to repeat complex code because CTEs separate code into unique units and they're self-referencing within ...  Tip

  • XML data type in SQL Server 2005 vs. VARCHAR (MAX)

    When choosing to use the XML data type or the VARCHAR (MAX) data type, in SQL Server 2005, DBAs and developers should know the potential performance impact of each. Here's a look at two tables, one inserted and queried with XML and the other with the...  Tip

Back to top