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”

• SQLAuthority News – SQL Server R2 Resources Downloads, Documentations

  
  Journey to SQL Authority with Pinal Dave — Authority: 528
  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 ...
  7 hours ago

• SQLAuthority News – Subscribe to Blog – Search a Blog

  
  Journey to SQL Authority with Pinal Dave — Authority: 528
  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 day ago

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

  
  Script For All — Authority: 130
  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 day ago

• SQLAuthority News – SQL Server 2008 Analysis Services Performance Guide

  
  Journey to SQL Authority with Pinal Dave — Authority: 528
  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 ...
  2 days ago

• SQL SERVER – Comma Separated Values (CSV) from Table Column

  
  Journey to SQL Authority with Pinal Dave — Authority: 528
  I use following script very often and I realized that I have never shared this script on this blog before. Creating Comma Separated Values (CSV) from Table Column is a very common task, and we all do this many times a day. Let us see the example that I use frequently and its output. USE AdventureWorks GO ...
  3 days ago

• SQL Server Schema Automatic Revision History using DDL Triggers and SVN

  
  stevienova.com — Authority: 104
  SQL 2005 introduced DDL Triggers, where you could catch events on your DDL statements in SQL, and hopefully most DBA’s are catching them, at least to a table and have some kind of report on who is adding, changing and deleting what objects. What I wanted to do was capture that, but also keep and automatic running ...
  4 days ago

• SQL SERVER – Interesting Observation – TOP 100 PERCENT and ORDER BY

  
  Journey to SQL Authority with Pinal Dave — Authority: 528
  Today we will go over a very simple, but interesting subject. The following error is quite common if you use ORDER BY while creating any view: Msg 1033, Level 15, State 1, Procedure something, Line 5 The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, ...
  4 days ago

• Getting the name of the table in which a column with specified name appears

  
  Kris' blog — Authority: 107
  Sometimes you need to find out in which tables a certain column name exists. For examplewhen you want to find out where it’s being used as a foreign key. Here’s a handy scriptto use in T-SQL. SELECT OBJECT_NAME(object_id), * FROM sys.columns WHERE name = columnname This makes use of the OBJECT_NAME ...
  4 days ago

• title

  
  Script For All — Authority: 130
  Patch Tuesday Oracle: 38 corrective measures of scurit annoncs – Actualits – ZDNet. FrExit Windows 7 complete records id=”; talkbackform”; >; Your comment You N `ê your steps identifié to take part &worsen; the discussion, [...]
  5 days ago

• SQL SERVER – A Common Design Problem – Should the Primary Key Always be a Clustered Index

  
  Journey to SQL Authority with Pinal Dave — Authority: 528
  In SQL Server, whenever we create any key, a Primary Key automatically creates clustered index on the same. I like this feature and I use this feature every now and then. The question is does the change of any column as Primary Key should also create a Clustered Index? Moreover, is there any case, where one would not ...
  5 days ago

• SQL SERVER – Remove Bookmark Key Lookup – 4 Different Ideas

  
  Journey to SQL Authority with Pinal Dave — Authority: 528
  I quite often get request to summarized my ideas about Removing bookmark lookup on this blog post. Bookmark lookup or key lookup are bad for any query as they force query engine to lookpup corresponding row in the table or index as it does not find required data from just reading the data. Here are list of my four ...
  6 days ago

• Update a Column with Random Numbers in SQL Server

  
  Sql Server Blog — Authority: 122
  In this blog post, I will show you how to update a database column with Random Numbers Let’s create a sample table DECLARE @TT table ( ID smallint , StudentID smallint , DayAlloted smallint ) -- Create Sample Data INSERT INTO @TT VALUES ( 101, 1, 0); INSERT INTO @TT VALUES ( 102, 2, 0); INSERT ...
  6 days ago

• SQLAuthority News – SQL Server 2008 for Oracle DBA

  
  Journey to SQL Authority with Pinal Dave — Authority: 528
  This 15 modules, level 300 course provides students with the knowledge and skills to capitalize on their skills and experience as an Oracle DBA to manage a Microsoft SQL Server 2008 system. This workshop provides a quick start for the Oracle DBA to map, compare, and contrast the realm of Oracle database management to ...
  1 week ago

• SQLAuthority News – Book Review – Expert SQL Server 2008 Encryption by Michael Coles

  
  Journey to SQL Authority with Pinal Dave — Authority: 528
  Expert SQL Server 2008 Encryption (Paperback) Michael Coles (Author), Rodney Landrum (Author) Link to Amazon “What is your opinion on encryption? What I mean is: In a world filled with data, how do you see encryption?” This is the precise question Michael Coles posed to me on March 3 rd of this ...
  1 week ago

• Convert Month Number to Month Name in SQL Server

  
  Sql Server Blog — Authority: 122
  One of my blog readers mailed me asking a simple way to convert a month number to month name. Here’s the simplest way in my opinion: DECLARE @Mth smallint SET @Mth = 11 SELECT DateName (mm, DATEADD (mm,@Mth,-1)) as [MonthName] OUTPUT Similarly if you want to list all the month names for a year using ...
  1 week ago

• SQL SERVER – Understanding Table Hints with Examples

  
  Journey to SQL Authority with Pinal Dave — Authority: 528
  Introduction Today we have a very interesting subject to look at. I tried to look for help online but have not found any other documentation besides what we have from the Book Online. Let us try to understand what are the different kinds of hints available in SQL Server and how they are helpful. What is a Hint? ...
  1 week ago

• SQL SERVER – Size of Index Table – A Puzzle to Find Index Size for Each Index on Table

  
  Journey to SQL Authority with Pinal Dave — Authority: 528
  It is very easy to find out some basic details of any table using the following Stored Procedure. USE AdventureWorks GO EXEC sp_spaceused [HumanResources.Shift] GO Above query will return following resultset The above SP provides basic details such as rows, data size in table, and Index size of all ...
  1 week ago

• SQL SERVER – Size of Index Table – A Puzzle to Find Index Size for Each Index on Table

  
  Visit SQLAuthority.com — Authority: 125
  It is very easy to find out some basic details of any table using the following Stored Procedure. USE AdventureWorks GO EXEC sp_spaceused [HumanResources.Shift] GO Above query will return following resultset The above SP provides basic details such as rows, data size in table, and Index size of ...
  1 week ago

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

  
  Journey to SQL Authority with Pinal Dave — Authority: 528
  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 ...
  1 week ago

• passing data between two SQL Server databases

  
  IT answers — Authority: 458
  New Question Created by LL123
  1 week ago

Comments about t sql