Blogs about: T Sql

Featured Blog

SQLAuthority News - Book Review - The Rational Guide to Building Technical User Communities (Rational Guides)

pinaldave wrote 1 day ago: The Rational Guide to Building Technical User Communities (Rational Guides) (Paperback) by Greg Low … more →

Tags: Pinal Dave, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQL User Group, SQLAuthority Book Review, SQLAuthority News

Creating Insert Statements for SQL Server

quarksoft wrote 1 day ago: Ran across an interesting approach to generating insert statements for SQL Server 2005 (and other va … more →

Tags: SQL Server, quarksoft, SQL Server 2005, Programming, David Finkelstein

Guillaume Tyrant (Citrix) the virtualisation nest not a technology miracle

kostland wrote 2 days ago: Opinion D `expert – Source of profits in matire dadministration, continuit dactivit and rdu … more →

Tags: Internet, firefox beta, Machines, msbuild, SQL Documentation, SQL Query, Status Updates, Virtual, Winforms

TSQL Challenge 10: Horizontal and Vertical sorting of a result set1 comment

Syed Mehroz Alam wrote 2 days ago: TSQL Challenge 10 was an interesting one. We needed to sort a result set horizontally as well as ver … more →

Tags: horizontal sorting, Pivot, TSql, unpivot

SQL SERVER - Difference between Line Feed (\n) and Carriage Return (\r) - T-SQL New Line Char4 comments

pinaldave wrote 3 days ago: Today, we will examine something very simple and very generic that can apply to hordes of programmin … more →

Tags: Pinal Dave, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, sqlcmd, technology

TSQL Challenge 9: Getting longest chain of consecutive alike/duplicate rows

Syed Mehroz Alam wrote 4 days ago: The BeyondRelational team is working hard to present us with cool TSQL challenges. For challenge 9, … more →

Tags: TSql, Ranking Functions, duplicaton

SQL SERVER - Maximum Number of Index per Table8 comments

pinaldave wrote 5 days ago: TechEd on Road Ahmedabad, June 20, 2009, was a huge success. This grand event saw over 200 attendees … more →

Tags: Pinal Dave, reader's contribution, Reader's question, SQL, SQL Authority, SQL Index, SQL Query, SQL Server, SQL Tips and Tricks

SQL SERVER - Fix : Error : 17892 Logon failed for login due to trigger execution. Changed database context to 'master'.

pinaldave wrote 1 week ago: I had previously written two articles about an intriguing observation of triggers online. SQL SERVER … more →

Tags: Pinal Dave, Reader's question, SQL, SQL Authority, SQL Error Messages, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks

Default value on a column

matt wrote 1 week ago: What is the default value on my column?  (Take out the criterion for a broader result set) FROM … more →

Vente binds: Microsoft leaves gaining dun procs in Core the South

kostland wrote 1 week ago: Legal – justice has gift wrong two socits showing Microsoft dabus of dominant position for … more →

Tags: Internet, Author Pinal, dataset, Dollars, Internet Life, JDBC, script-land, Status Updates, Windows

Errors upgrading SQL Server 2005 to SQL Server 2008

scmay wrote 1 week ago: I have an existing SQL Server 2005 database which I would like to use in SQL Server 2008 database. E … more →

Tags: SQL Server, SQL Server 2008

How to: tell if a string is a valid date

jlamorgese wrote 1 week ago: This afternoon I received a request from a colleague of mine in Philadelphia via email.  See the exc … more →

Tags: MSSQL 2005

SQLAuthority News - Authors Visit - K-MUG TechEd Trivandrum on June 27, 2009

pinaldave wrote 1 week ago: K-MUG is organizing TechEd Trivandrum on 27th June, 2009. Not just this, they are launching an offic … more →

Tags: MVP, Pinal Dave, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority Visit, SQLAuthority News

Make sure your SQL queries are using the proper index2 comments

chrishaas wrote 1 week ago: I’ve got a live table with 98 million rows that I’m normalizing. Unforuntately all full … more →

Tags: SQL Server 2000

Vente binds: laudition of Microsoft before the Commission europenne cancels

kostland wrote 1 week ago: Legal – the firm owed dfendre its case before the Commission europenne at the time dauditio … more →

Tags: Internet, Web Browser, dataset, ADO.NET, SQL Query, web², PHP Development, Competition

T-SQL: Creating a hierarchical structure from relational data

Syed Mehroz Alam wrote 1 week ago: Recently, while developing an SSIS package, I came across a scenario where I needed to create parent … more →

Tags: CTE, Hierarchy, parent-child, recursion, relationship, TSql

Get list of view that uses certain column name

BaLs wrote 1 week ago: I was looking a query that tell me a list of view using certain view from a table, and found the ans … more →

Tags: SQL Server, SQL, View, Usage

SQLAuthority News - Update on pinaldave.com and SQLAuthority.com2 comments

pinaldave wrote 1 week ago: Problem: SQLAuthority.com site was not allowed in some browsers as pinaldave.com site was marked as … more →

Tags: Database, Pinal Dave, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, SQLSERVER

Breaking up is hard to do

matt wrote 1 week ago: There are a lot of great posts about splitting a table into a list or splitting a list into a table. … more →


Have your say. Start a blog.

See our free features →

Related Tags
All →

Follow this tag via RSS

Find other items tagged with “t-sql”:
Technorati Del.icio.us IceRocket