|
|
Stories recently tagged with 'TSQL'
|
|
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
|
category:  Database | Views: 3
| 
|
tags:
TSQL, Database | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
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
|
category: Database | Views: 4
| 
|
tags:
2005, TSQL, SQLServer, Database, SQL | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
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
|
category: Database | Views: 0
| 
|
tags:
SqlServer2005, TSQL, Database | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
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
|
category: Database | Views: 14
| 
|
tags:
SqlServer2005, TSQL, Database, SQLServer | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
published 8 months, 27 days ago, submitted by
 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...
1 comment
|
category: Database | Views: 0
| 
|
tags:
TSQL, TechAhead, SQLServer, Database, SQL | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
published 9 months, 3 days ago, submitted by
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
|
category: Database | Views: 4
| 
|
tags:
TSQL, TechAhead, SQLServer, Database, SQL | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
published 8 months, 27 days ago, submitted by
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
|
category: Database | Views: 11
| 
|
tags:
SQLServer, TSQL, TechAhead, tables, Database | tag it
Everyones tags: | Your tags: | |
|
|
|
|
Sponsored Link: www.carlist.ie
Ads via The Lounge
|