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”

• How to Display DateTime Formats in Different Languages using SQL Server

  
  Sql Server Blog — Authority: 122
  SET LANGUAGE can be used to specify the language environment for the current session. You can use the sys.syslanguages to first determine the languages present in an instance of SQL Server SELECT * FROM sys.syslanguages Once you know the different languages, use SET LANGUAGE to display the DateTime in the ...
  11 hours ago

• SQLAuthority News – Notes from TechDays 2009 at Infosys, Bangalore

  
  Journey to SQL Authority with Pinal Dave — Authority: 539
  I recently had opportunity to attend TechDays 2009 Infosys. This event was the largest technology conference by Microsoft in Infosys. Microsoft Tech Days focused on positioning Microsoft as the company to bet on for future technology investments by businesses and consumers alike. The event was a showcase of ...
  22 hours ago

• SQL SERVER – 2008 Star Join Query Optimization

  
  Journey to SQL Authority with Pinal Dave — Authority: 539
  Business Intelligence (BI) plays a significant role in businesses nowadays. Moreover, the databases that deal with the queries related to BI are presently facing an increase in workload. At present, when queries are sent to very large databases, millions of rows are returned. Also the users have to go through extended ...
  1 day ago

• SQLAuthority News – Airline Review – Paramount, Kingfisher, Go Air, Indigo, Jet Airways, Indian Airlines, Spicejet

  
  Journey to SQL Authority with Pinal Dave — Authority: 539
  First of all, this is a totally different article that I have ever written on this site. As the regular readers of my blog are aware that I am always traveling due to my different assignments at work. In last two months, I have been on flight for 36 times; this makes me a regular air traveler, who travels almost every ...
  2 days ago

• SQLAuthority News – Airline Review – Paramount, Kingfisher, Go Air, Indigo, Jet Airways, Indian Airlines, Spicejet

  
  Visit SQLAuthority.com — Authority: 129
  First of all, this is a totally different article that I have ever written on this site. As the regular readers of my blog are aware that I am always traveling due to my different assignments at work. In last two months, I have been on flight for 36 times; this makes me a regular air traveler, who travels almost every ...
  2 days ago

• SQL SERVER – Validate an XML document in TSQL using XSD by Jacob Sebastian

  
  Visit SQLAuthority.com — Authority: 129
  Following article is sent by SQL Server MVP Jacob Sebastian on request to provide solution for validating XML document. XML Schema Collections Because of the ‘eXtensible’ nature of XML (eXtensible Markup Language), often there is a requirement to restrict and validate the content of an XML document to a ...
  3 days ago

• SQLAuthority News – A Daily Doze of Technology – Alvin Ashcraft’s Morning Dew

  
  Journey to SQL Authority with Pinal Dave — Authority: 539
  A common question that I receive is regarding how I keep myself updated with latest information about technology and what is going on at present. I read lots of blogs and books. I am usually traveling 4 days in my any regular work week. I read physical books at the time. I prefer to read the books in hard copy and not ...
  4 days ago

• SQLAuthority News – A Daily Doze of Technology – Alvin Ashcraft’s Morning Dew

  
  Visit SQLAuthority.com — Authority: 129
  A common question that I receive is regarding how I keep myself updated with latest information about technology and what is going on at present. I read lots of blogs and books. I am usually traveling 4 days in my any regular work week. I read physical books at the time. I prefer to read the books in hard copy and not ...
  4 days ago

• SQL SERVER – Size of Index Table for Each Index – Solution

  
  Journey to SQL Authority with Pinal Dave — Authority: 539
  Earlier I have posted small question on this blog and requested help from readers to participate here and provide solution. Please read the original Puzzle here. SQL SERVER – Size of Index Table – A Puzzle to Find Index Size for Each Index on Table The puzzle was to write a query that will return the size ...
  5 days ago

• SQL SERVER – Size of Index Table for Each Index – Solution

  
  Visit SQLAuthority.com — Authority: 129
  Earlier I have posted small question on this blog and requested help from readers to participate here and provide solution. Please read the original Puzzle here. SQL SERVER – Size of Index Table – A Puzzle to Find Index Size for Each Index on Table The puzzle was to write a query that will return the size ...
  5 days ago

• Validate Email Addresses in SQL Server

  
  Sql Server Blog — Authority: 122
  I will be honest here – doing email address validation in SQL Server is one of the most challenging tasks a T-SQL programmer faces. Stefan Plattner sometime back on the forums shared a query to validate Email Address. I have been using this query in my applications and thought of sharing this with all of you ...
  6 days ago

• SQL SERVER – Azure Start Guide – Step by Step Installation Guide

  
  Journey to SQL Authority with Pinal Dave — Authority: 539
  As SQL Azure CTP is released I have included here step by step guide for how to configure the CTP. For pricing and introduction please read SQLAuthority News – SQL Azure – Microsoft SQL Data Services – Introduction and Pricing First it has to be configured online at https://sql.azure.com/ Login using your ...
  6 days ago

• SQL SERVER – Azure Start Guide – Step by Step Installation Guide

  
  Visit SQLAuthority.com — Authority: 129
  As SQL Azure CTP is released I have included here step by step guide for how to configure the CTP. For pricing and introduction please read SQLAuthority News – SQL Azure – Microsoft SQL Data Services – Introduction and Pricing First it has to be configured online at https://sql.azure.com/ Login using ...
  6 days ago

• SQLAuthority News – SQL Server R2 Resources Downloads, Documentations

  
  Journey to SQL Authority with Pinal Dave — Authority: 539
  Microsoft SQL Server 2008 R2 November Community Technology Preview Building on SQL Server 2008, R2 provides an even more scalable data platform with comprehensive tools for managing your databases and applications, improving the quality of your data, and empowering your users to build rich analyses and reports using ...
  1 week ago

• Find Number of Weeks in a Month using SQL Server

  
  Sql Server Blog — Authority: 122
  I have been asked this question plenty of times – How do I calculate the number of weeks in a month. The answer to this query depends on how do you define a week. For simplicity purposes, I will take a week from Sunday to Saturday as depicted in the calendar So November has 5 weeks! Let us write the query ...
  1 week ago

• SQLAuthority News – Subscribe to Blog – Search a Blog

  
  Journey to SQL Authority with Pinal Dave — Authority: 539
  Quite often I get request if I send blog post in newsletter or through email. Here are few important links. You can for sure get email of my post, however, I strongly suggest to visit blog as if there are any updates in my post they are reflected on blog. Subscribe to blog post through email Subscribe ...
  1 week ago

• SQLAuthority News – Subscribe to Blog – Search a Blog

  
  Visit SQLAuthority.com — Authority: 129
  Quite often I get request if I send blog post in newsletter or through email. Here are few important links. You can for sure get email of my post, however, I strongly suggest to visit blog as if there are any updates in my post they are reflected on blog. Subscribe to blog post through email Subscribe ...
  1 week ago

• CRM: Dell will propose the solutions of Salesforce. COM with its PC

  
  Script For All — Authority: 132
  CRM: Dell will propose the solutions of Salesforce. COM with its PC – Actualits – ZDNet. FrExit Windows 7 complete records id=”; talkbackform”; >; Your comment You N `ê your steps identifié to take part [...]
  1 week ago

• SQLAuthority News – SQL Server 2008 Analysis Services Performance Guide

  
  Journey to SQL Authority with Pinal Dave — Authority: 539
  Because Microsoft SQL Server Analysis Services query and processing performance tuning is a fairly broad subject, this white paper organizes performance tuning techniques into the following three segments. Enhancing Query Performance – Query performance directly impacts the quality of the end user experience. As ...
  1 week ago

• SQLAuthority News – SQL Server 2008 Analysis Services Performance Guide

  
  Visit SQLAuthority.com — Authority: 129
  Because Microsoft SQL Server Analysis Services query and processing performance tuning is a fairly broad subject, this white paper organizes performance tuning techniques into the following three segments. Enhancing Query Performance – Query performance directly impacts the quality of the end user experience. As ...
  1 week ago

Comments about t sql