DotNetKick.com is an open-source project. Please report any bugs and let us know your great suggestions. Currently running svn revision 620 (rss)

Kick Spy!, Kick Zeitgeist and Kick Widgets

Stories recently tagged with 'TSQL' Subscribe to this feed
2
kicks
submitted by Marlonr 7 days, 3 hours ago

dbalink.wordpress.com — I have created a Backup Script to backup all the databases in our SQL Server 2005. I want to keep old backups for sometime for some reason; so I want to create subdirectory with the run date as the name of the folder to separate the set of backups by date. read more...

Add a comment add a comment | category: | Views: 3
tags: , | tag it

5
kicks
submitted by Marlonr 9 days, 6 hours ago

dbalink.wordpress.com — For some reasons, DBA’s need to rename their Databases. One of the reasons might be to comply to Best Practices Policy changes. Here we are going to rename our Database named “Bad_Ass_DB” into “Best_Practice_DB”. This is how Database renaming with TSQL is done in SQL Server 2005.... read more...

Add a comment add a comment | category: | Views: 4
tags: , , , , | tag it

1
kicks
submitted by Marlonr 2 months, 9 days ago

dbalink.wordpress.com — Watch out for these events! read more...

Add a comment add a comment | category: | Views: 3
tags: , , , , | tag it

5
kicks
submitted by kprernn 3 months, 14 days ago

weblogs.sqlteam.com — Link to the "Writing Better Queries" presentation that Joe Webb gave at the Nashville SQL Server User Group meeting on 4 April 2008. read more...

Add a comment add a comment | category: | Views: 2
tags: , , | tag it

4
kicks
submitted by kprernn 4 months, 26 days ago

weblogs.sqlteam.com — Does the order of the search criteria make any difference in Microsoft SQL Server's ability to use indexes or resolve a query? In this post, Joe provides a demonstration of how SQL Server can optimize the WHERE clause to its benefit. read more...

Add a comment add a comment | category: | Views: 0
tags: , , | tag it

1
kicks
submitted by ormico 5 months, 26 days ago

blog.zacksfiasco.com — Build a complete Stored Procedure based Data Access Layer using Code Generation - Part 2 read more...

Add a comment add a comment | category: | Views: 3
tags: , , , , | tag it

1
kicks
submitted by ormico 5 months, 26 days ago

blog.zacksfiasco.com — Build a complete Stored Procedure based Data Access Layer using Code Generation Part 1 read more...

Add a comment add a comment | category: | Views: 4
tags: , , , , | tag it

5
kicks
submitted by prashantvictory prashantvictory 8 months, 21 days ago

techahead.wordpress.com — This article give you the detailed explaination about cursors used in sql.... read more...

Add a comment add a comment | category: | Views: 1
tags: , , , , | tag it

4
kicks
submitted by kprernn 8 months, 25 days ago

weblogs.sqlteam.com — This posting demonstrates how to use the undocumented sp_MSforeachtable stored procedure in the SQL Server master database to execute a SQL script against each table in the database. Great for disabling check constraints before loading data. read more...

Add a comment add a comment | category: | Views: 14
tags: , , , | tag it

10
kicks
published 8 months, 27 days ago, submitted by prashantvictory prashantvictory 9 months, 3 days ago

techahead.wordpress.com — 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...

Add a comment 1 comment | category: | Views: 0
tags: , , , , | tag it

6
kicks
submitted by prashantvictory prashantvictory 9 months, 6 days ago

techahead.wordpress.com — 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 add a comment | category: | Views: 18
tags: , , , , | tag it

11
kicks
published 9 months, 3 days ago, submitted by prashantvictory prashantvictory 9 months, 7 days ago

techahead.wordpress.com — 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 add a comment | category: | Views: 4
tags: , , , , | tag it

7
kicks
submitted by kprernn 9 months, 8 days ago

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

Add a comment add a comment | category: | Views: 5
tags: , , , , | tag it

4
kicks
submitted by kprernn 9 months, 9 days ago

weblogs.sqlteam.com — 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 add a comment | category: | Views: 2
tags: , , , , | tag it

10
kicks
published 8 months, 27 days ago, submitted by prashantvictory prashantvictory 9 months, 9 days ago

techahead.wordpress.com — 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 add a comment | category: | Views: 11
tags: , , , , | tag it

3
kicks
submitted by kprernn 9 months, 16 days ago

weblogs.sqlteam.com — 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 add a comment | category: | Views: 0
tags: , , , , | tag it

 

Sponsored Link: www.carlist.ie

Search:

Ads via The Lounge