t sql
Tag details
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'.
Look up
"t-sql"
at The Free Dictionary
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

