T SQL

Welcome to the 'T-SQL' tag page at Technorati. This page features content from the farthest reaches of the Blogosphere that authors have "tagged" with 'T-SQL'.

Latest blogosphere posts tagged “T SQL”

• SQL SERVER – 2005 2008 – Backup, Integrity Check and Index Optimization By Ola Hallengren

  
  Journey to SQL Authority with Pinal Dave — Authority: 530
  Script of Backup, Integrity Check and Index Optimization are the most important scripts for any developer. SQL Expert and true SQL enthusiast Ola HallenGren is known for his excellent scripts. Please try it out and let me know what you think. The documentation is available on ...
  3 hours ago

• passing data between two SQL Server databases

  
  IT answers — Authority: 457
  New Question Created by LL123
  10 hours ago

• T-SQL: Using cursor with Common Table Expressions

  
  Mehroz's Experiments — Authority: 99
  Cursors aren’t a bad choice for certain scenarios. Few days back, I was writing a stored procedure that was to be scheduled as a SQL agent job. I needed to send emails for each row of a result set and hence concluded that a Fast Forward cursor (Read Only, Forward only cursor) would be a nice choice. I created ...
  20 hours ago

• SQLAuthority News – Notes of Excellent Experience at SQL PASS 2009 Summit, Seattle

  
  Journey to SQL Authority with Pinal Dave — Authority: 530
  Update: Do not forget to checkout last three photos and follow me on twitter (of course!) I have previously documented my four-day experience of SQL PASS 2009 Summit at Seattle. There were many reasons for SQL enthusiasts to attend the SQL PASS event; I am listing my own reasons here in order of importance ...
  1 day ago

• SQLAuthority News – Notes of Excellent Experience at SQL PASS 2009 Summit, Seattle

  
  Visit SQLAuthority.com — Authority: 127
  Update: Do not forget to checkout last three photos and follow me on twitter (of course!) I have previously documented my four-day experience of SQL PASS 2009 Summit at Seattle. There were many reasons for SQL enthusiasts to attend the SQL PASS event; I am listing my own reasons here in order of importance ...
  1 day ago

• SQL SERVER – Whitepaper Consolidation Using SQL Server 2008

  
  Journey to SQL Authority with Pinal Dave — Authority: 530
  Many companies are considering or have already implemented consolidation of computing resources, including Microsoft SQL Server instances and databases, in their organization. A consolidation effort is a complex task that requires information, a detailed plan and timeline for success, and a strategy for administering ...
  2 days ago

• SQL SERVER – Whitepaper Consolidation Using SQL Server 2008

  
  Visit SQLAuthority.com — Authority: 127
  Many companies are considering or have already implemented consolidation of computing resources, including Microsoft SQL Server instances and databases, in their organization. A consolidation effort is a complex task that requires information, a detailed plan and timeline for success, and a strategy for administering ...
  2 days ago

• SQLAuthority News – Disk Partition Alignment Best Practices for SQL Server

  
  Journey to SQL Authority with Pinal Dave — Authority: 530
  Disk partition alignment is a powerful tool for improving SQL Server performance. Configuring optimal disk performance is often viewed as much art as science. A best practice that is essential yet often overlooked is disk partition alignment. Windows Server 2008 attempts to align new partitions out-of-the-box, yet ...
  3 days ago

• Executing a Stored Procedure using SQLCMD

  
  Sql Server Blog — Authority: 121
  Here’s how to execute a SQL Server Stored Procedure using SQLCMD. For demonstration purposes, I will be executing the ‘CustOrderHist’ Stored Procedure in the Northwind database. This procedure accepts the CustomerID and returns a list of orders placed by the Customer. Open your Command Prompt. I have a named ...
  3 days ago

• Drop All Objects in a SQL Server 2005 Database

  
  PimpThisBlog.com - Latest published stories — Authority: 465
  This post documents a T-SQL script used to dynamically delete all objects in a database.
  3 days ago

• SQL SERVER – Policy Based Management – Create, Evaluate and Fix Policies

  
  Journey to SQL Authority with Pinal Dave — Authority: 530
  Introduction This article will cover the most spectacular feature of SQL 2008 – Policy-based management and how the configuration of SQL Server with policy-based management architecture can make a powerful difference. Policy based management is loaded with several advantages. It can help you implement various ...
  4 days ago

• SQL SERVER – Policy Based Management – Create, Evaluate and Fix Policies

  
  Visit SQLAuthority.com — Authority: 127
  Introduction This article will cover the most spectacular feature of SQL 2008 – Policy-based management and how the configuration of SQL Server with policy-based management architecture can make a powerful difference. Policy based management is loaded with several advantages. It can help you implement various ...
  4 days ago

• Extracting DotNetNuke User Information With SQL

  
  PimpThisBlog.com - Latest published stories — Authority: 465
  It is not uncommon to have a client request a list of site users in a particular role. You can obviously get this information from the DotNetNuke user interface but its very easy to get this directly from the tables in SQL Management Studio and then export to a CSV or Excel file for easy distribution. Below is an ...
  4 days ago

• SQL SERVER – Disable CHECK Constraint – Enable CHECK Constraint

  
  Journey to SQL Authority with Pinal Dave — Authority: 530
  Foreign Key and Check Constraints are two types of constraints that can be disabled or enabled when required. This type of operation is needed when bulk loading operations are required or when there is no need to validate the constraint. The T-SQL Script that does the same is very simple. USE AdventureWorks GO ...
  5 days ago

• SQL SERVER – Disable CHECK Constraint – Enable CHECK Constraint

  
  Visit SQLAuthority.com — Authority: 127
  Foreign Key and Check Constraints are two types of constraints that can be disabled or enabled when required. This type of operation is needed when bulk loading operations are required or when there is no need to validate the constraint. The T-SQL Script that does the same is very simple. USE AdventureWorks GO ...
  5 days ago

• Pivoting, Un-pivoting and Aggregating: A Quick Spin Around the Block

  
  Simple Talk rss feed — Authority: 492
  In which Phil is asked to write a nice simple quick-start guide about aggregation, pivoting and un-pivoting techniques. To do so, he takes us all the way from getting the data from a published source, transferring it to SQL Server, un-pivoting it, storing it in a relational table, aggregating it and finally pivoting ...
  5 days ago

• title

  
  Script For All — Authority: 127
  Carol Bartz: Yahoo! discuss « a little bit » with Microsoft – Actualits – ZDNet. FrExit Windows 7 complete records Plays vidé O of Noë L id=”; down”; >; Copyright &Copy; 2009 Interactive CBS. [...]
  5 days ago

• SQL SERVER – Sharepoint Resource Available for SQL Server

  
  Journey to SQL Authority with Pinal Dave — Authority: 530
  Here is quick list of the tools which are available for SQL Server and Sharepoint. These are recently updated resources from Microsoft. External Collaboration Toolkit for SharePoint This solution allows users to create collaboration environments that use the familiar SharePoito deploy a SharePoint-based ...
  6 days ago

• SQL SERVER – Sharepoint Resource Available for SQL Server

  
  Visit SQLAuthority.com — Authority: 127
  Here is quick list of the tools which are available for SQL Server and Sharepoint. These are recently updated resources from Microsoft. External Collaboration Toolkit for SharePoint This solution allows users to create collaboration environments that use the familiar SharePoito deploy a SharePoint-based ...
  6 days ago

• SQL Authority News – Training MS SQL Server 2005/2008 Query Optimization And Performance Tuning

  
  Journey to SQL Authority with Pinal Dave — Authority: 530
  This is very short note announcing details about my course details for ‘ MS SQL Server 2005/2008 Query Optimization And Performance Tuning ‘. The course is scheduled to be delivered from 19th Nov, 2009 and 21st Nov, 2009 in Pune, India . This three day course is an intensive course designed to give ...
  1 week ago

Comments about T SQL