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'.

Are you an expert about 't sql'? Do you want to be the Technorati authority on 't sql'? You can write a description that will appear right here: Join Blogcritics!

Latest blogosphere posts tagged “t sql”

 

• SQL SERVER – Importance of Resource Database – Quiz – Puzzle – 18 of 31

  
  Journey to SQL Authority with Pinal Dave — Authority: 412
  Year 2011 was a year of learning and opportunity for me. My recent book,  SQL Server Interview Questions and Answers , has received such overwhelming love and support from all of you. While writing the book, I had  two simple goals : (1)  Master the Basics  and (2)  Ignite Learning . There was a ...
  2 weeks ago

• SQL SERVER – Various Ways to Create Constraints – Quiz – Puzzle – 17 of 31

  
  Journey to SQL Authority with Pinal Dave — Authority: 412
  Year 2011 was a year of learning and opportunity for me. My recent book,  SQL Server Interview Questions and Answers , has received such overwhelming love and support from all of you. While writing the book, I had  two simple goals : (1)  Master the Basics  and (2)  Ignite Learning . There was a ...
  2 weeks ago

• SQL SERVER – CHECKPOINT Behavior and Database Recovery Models – Quiz – Puzzle – 16 of 31

  
  Journey to SQL Authority with Pinal Dave — Authority: 412
  Year 2011 was a year of learning and opportunity for me. My recent book,  SQL Server Interview Questions and Answers , has received such overwhelming love and support from all of you. While writing the book, I had  two simple goals : (1)  Master the Basics  and (2)  Ignite Learning . There was a ...
  2 weeks ago

• SQL SERVER – Difference between CHAR, VARCHAR, NVARCHAR and VARCHAR(MAX) – Quiz – Puzzle – 15 of 31

  
  Journey to SQL Authority with Pinal Dave — Authority: 412
  Year 2011 was a year of learning and opportunity for me. My recent book,  SQL Server Interview Questions and Answers , has received such overwhelming love and support from all of you. While writing the book, I had  two simple goals : (1)  Master the Basics  and (2)  Ignite Learning . There was a ...
  2 weeks ago

• SQL SERVER – Using SafePeak to Accelerate Performance of 3rd Party Applications

  
  Journey to SQL Authority with Pinal Dave — Authority: 412
  An exciting solution I found last year (2011) for SQL Server performance acceleration is SafePeak . Designed to specifically to accelerate and tune performance of cases where you have minimum control on the applications, like 3 rd party line of business applications. SafePeak performs automated caching of queries ...
  2 weeks ago

• SQL SERVER – Cases When Stored Procedure RECOMPILE – Quiz – Puzzle – 14 of 31

  
  Journey to SQL Authority with Pinal Dave — Authority: 412
  Year 2011 was a year of learning and opportunity for me. My recent book,  SQL Server Interview Questions and Answers , has received such overwhelming love and support from all of you. While writing the book, I had  two simple goals : (1)  Master the Basics  and (2)  Ignite Learning . There was a ...
  2 weeks ago

• SQL SERVER – Debate – Table Variables vs Temporary Tables – Quiz – Puzzle – 13 of 31

  
  Journey to SQL Authority with Pinal Dave — Authority: 412
  Year 2011 was a year of learning and opportunity for me. My recent book,  SQL Server Interview Questions and Answers , has received such overwhelming love and support from all of you. While writing the book, I had  two simple goals : (1)  Master the Basics  and (2)  Ignite Learning . There was a ...
  2 weeks ago

• The Equivalent of T-SQL’s SELECT TOP N in Oracle PL/SQL

  
  luefher techo — Authority: 99
  So you have been coding away T-SQL queries for a while now and know that by using the TOP keyword you can select the first what’s-the-number rows of your result set. Suddenly you find yourself in a familiar SQL environment, less the look and feel of the SQL Management Studio, with the exception that PL/SQL is ...
  3 weeks ago

• SQL SERVER – DACPAC and SQL Azure – Quiz – Puzzle – 12 of 31

  
  Journey to SQL Authority with Pinal Dave — Authority: 412
  Year 2011 was a year of learning and opportunity for me. My recent book,  SQL Server Interview Questions and Answers , has received such overwhelming love and support from all of you. While writing the book, I had  two simple goals : (1)  Master the Basics  and (2)  Ignite Learning . There was a ...
  3 weeks ago

• SQL SERVER – Non-Clustered Index and Automatic Rebuild – Quiz – Puzzle – 11 of 31

  
  Journey to SQL Authority with Pinal Dave — Authority: 412
  Year 2011 was a year of learning and opportunity for me. My recent book,  SQL Server Interview Questions and Answers , has received such overwhelming love and support from all of you. While writing the book, I had  two simple goals : (1)  Master the Basics  and (2)  Ignite Learning . There was a ...
  3 weeks ago

• SQL SERVER – A Quick Look at expressor Data Quality Solutions

  
  Journey to SQL Authority with Pinal Dave — Authority: 412
  Last month I described the extension framework that allows one to easily add functionality to an  expressor Studio installation.  I then used this added functionality – the input and output operators to SalesForce.com – to develop an example application.  But  expressor has a second mechanism that allows you ...
  3 weeks ago

• SQL SERVER – Reasons for Using Output Clause – Quiz – Puzzle – 10 of 31

  
  Journey to SQL Authority with Pinal Dave — Authority: 412
  Year 2011 was a year of learning and opportunity for me. My recent book,  SQL Server Interview Questions and Answers , has received such overwhelming love and support from all of you. While writing the book, I had  two simple goals : (1)  Master the Basics  and (2)  Ignite Learning . There was a ...
  3 weeks ago

• Index Misconceptions [TSQL Tuesday #026 - Second Chances]

  
  sqlity.net — Authority: 95
  T-SQL Tuesday #26 is hosted by David Howard ( blog | twitter ). This month’s topic is “ Second Chances ”. Index Misconceptions The topic this month is "Second Chances" which means that we can write about anything, we would have liked to write about before but didnt get to. Well, not really anything, but any of ...
  3 weeks ago

• SQL SERVER – Locking, Blocking and Deadlock – Quiz – Puzzle – 9 of 31

  
  Journey to SQL Authority with Pinal Dave — Authority: 412
  Year 2011 was a year of learning and opportunity for me. My recent book,  SQL Server Interview Questions and Answers , has received such overwhelming love and support from all of you. While writing the book, I had  two simple goals : (1)  Master the Basics  and (2)  Ignite Learning . There was a ...
  3 weeks ago

• APPLY – not exactly set-based

  
  Rob Farley — Authority: 79
  In my last post, I showed a technique for dealing with working columns when writing T-SQL. The idea was around using APPLY to be able to push values from the existing set through calculations (but preferably not scalar functions, of course), producing new columns which can be used further down the query, even in the ...
  3 weeks ago

• SQL SERVER – Using RANKING Functions Instead of SQL Looping Logic of Cursor – Quiz – Puzzle – 8 of 31

  
  Journey to SQL Authority with Pinal Dave — Authority: 412
  Year 2011 was a year of learning and opportunity for me. My recent book,  SQL Server Interview Questions and Answers , has received such overwhelming love and support from all of you. While writing the book, I had  two simple goals : (1)  Master the Basics  and (2)  Ignite Learning . There was a ...
  3 weeks ago

Comments about t sql