10 T-SQL Index statements needed with DBA
sql server dba (database administrator) people - database administrators know very well that index entries in the database are very similar to index in the library section. or
Tags : t-sql
Improvements in SQL Server 2008 T-SQL command (Part 2)
in the previous section we explored some of the improvements in sql server 2008 t-sql statements, including intellisense, grouping set, and forceseek hint tables.
Improvements in SQL Server 2008 T-SQL command
sql server 2008 integrates many remarkable new features. one of these features is improvements in t-sql statements that reduce the time spent working on these statements.
Good habits when writing T-SQL statements (Part 1)
application performance depends on a lot of factors, including a very important factor that is the time for sql server to process t-sql statements. sometimes database design and
Good habits when writing T-SQL statements (Part 2)
this second part will focus on how to optimize multi-purpose storage procedures.
Good habits when writing T-SQL statements (Part 3)
in this third part, the article will show you how to write t-sql statements to promote the reuse of cached diagrams.
Attach database in Microsoft SQL Server 2008
this article will illustrate the different usage methods of the 'for attach' clause to overcome the limitations encountered when using sp_attach_db and sp_attach_single_file_db.