SQL - Truncate and Delete(techahead.wordpress.com)

submitted by prashantvictory(605) 4 years, 7 months ago

Truncate an Delete both are used to delete data from the table. These both the command will only delete the data of the specified table, they cannot remove the whole table data along with its structure. Now it’s ok that both the SQL statements are used to delete only the data from the table but they both differ from each other in many aspects like syntax, performance, resources uses etc. to find out all differnces take a look of this article..... read more...

1 comment |category: Database |Views: 7

tags: TSQL TechAhead SQLServer Database SQL another

SQL – Using "UNION ALL" to Convert Horizontal Data to Vertical Data(techahead.wordpress.com)

submitted by prashantvictory(605) 4 years, 7 months ago

This post will tell u how to use the UNION ALL operator to convert horizontal data to vertical data. read the post more more information....... read more...

add a comment |category: Database |Views: 330

tags: TSQL TechAhead SQLServer Database SQL another

SQL - Derived tables(techahead.wordpress.com)

submitted by prashantvictory(605) 4 years, 7 months ago

This article explains what are derived tables and how we can use them to perform our query better. In some situations they can be a better alternative of temporary tables, So take a look of this... :) read more...

add a comment |category: Database |Views: 89

tags: TSQL TechAhead SQLServer Database SQL another

When was a SQL Server table or view last altered?(weblogs.sqlteam.com)

submitted by kprernn(1445) 4 years, 7 months ago

A very handy little script to determine the last time a SQL Server table or view was altered. read more...

add a comment |category: Database |Views: 27

tags: TSQL Auditing SqlServer2005 Database SQL another

Enabling and disabling logins in SQL Server 2005(weblogs.sqlteam.com)

submitted by kprernn(1445) 4 years, 7 months ago

A concise, yet informative demonstration of how to create, enable, disable, and drop SQL Server logins and users using T-SQL. read more...

add a comment |category: Database |Views: 7

tags: TSQL SqlServer2005 SQLServer Database SQL another

SQL - Temporary tables a detailed view.(techahead.wordpress.com)

submitted by prashantvictory(605) 4 years, 7 months ago

This article contains almost each and everything related to temporary tables in SQL, all the concepts of temp tables like how to use them, wht are the alternatives of temp tables, what are the benefits and drwabacks, what is the performance tunibg tips etc, i think this is the best article to learn about SQL Server Temporary tables. read more...

add a comment |category: Database |Views: 123

tags: Temporary tables TechAhead TSQL Database another

How to tell when the SQL Server service was started(weblogs.sqlteam.com)

submitted by kprernn(1445) 4 years, 7 months ago

Neat little post that shows how to use T-SQL to determine with the SQL Server service was last started. read more...

add a comment |category: Database |Views: 3

tags: TSQL SqlServer2005 SQLServer Database SQL another

SQL Server 2000: when were the statistics updated?(weblogs.sqlteam.com)

submitted by kprernn(1445) 4 years, 8 months ago

A SQL script to determine when the statistics were updated for all indexes on all user tables in SQL Server 2000. read more...

add a comment |category: Database |Views: 7

tags: TSQL SQLServer2000 SQL SQLServer another

LINQ to the rescue?(sqlblog.com)

submitted by SQL_Menace(4890) 4 years, 8 months ago

I heard someone state that LINQ was going to rescue developers from having to know TSQL. Well if that's true then who will rescue us from LINQ? read more...

2 comments |category: Database |Views: 1

tags: TSQL LINQ SQL another

"Nothing has changed" - Determining when a procedure has been altered(weblogs.sqlteam.com)

submitted by kprernn(1445) 4 years, 8 months ago

Cool little script to determine when a stored procedure was last updated. read more...

add a comment |category: Database |Views: 3

tags: TSQL SqlServer2005 SQL SQLServer another

TABLESAMPLE Clause in SQL Server 2005(nayyeri.net)

submitted by keyvan(4086) 5 years, 1 month ago

TABLESAMPLE is a new clause in SQL Server 2005 to select a sample table from an exisiting table. read more...

1 comment |category: Database |Views: 9

tags: T-SQL TSQL KeyvanNayyeri SQL 2005 another

OUTPUT Clause in SQL Server 2005(nayyeri.net)

submitted by keyvan(4086) 5 years, 1 month ago

In this post you'll read about a new clause that is added to T-SQL with SQL Server 2005. OUTPUT clause helps you to retrieve data from inserted, updated or deleted rows. read more...

add a comment |category: Database |Views: 23

tags: T-SQL TSQL KeyvanNayyeri SQL 2005 another

New T-SQL Capabilities in SQL Server 2005 - Part 1 of 3 (setfocus.com)

submitted by SetFocus(510) 5 years, 2 months ago

This month I'll start a three-part series on new Transact-SQL language features in SQL Server 2005. Microsoft added many new language features in SQL Server 2005, in response to developer requests and also in following compliance with the SQL-99 standard. read more...

add a comment |category: Visual Studio |Views: 32

tags: SQLServer T-SQL TSQL SQL VisualStudio another

TSQL and CLR Performance Analysis(weblogs.asp.net)

submitted by wallym(2085) 5 years, 4 months ago

A performance analysis of different ways to use CLR objects and strategies for using them. read more...

add a comment |category: ADO.NET |Views: 9

tags: CLR TSQL ADO.NET Performance another