You can also use the SUM and GROUP BY with arguments like ROLLUP or CUBE these will give a summary row of the policy. GROUPING SETS for multiple groupings of...

See this article it might give you some directions

http://www.codeproject.com/KB/database/Dynamic_Management_Views.aspx

The certification is important but when you look at most business intelligence architect job description its the knowledge, skills and experience.

one can be a business intelligence architect in a number...

make sure you kill all connection and verify your backups before you start the restore. See articles below

http://dbmanagement-blog.com/2009/08/24/how-to-restore-a-database-with-litespeed-for-sql-server/

https://help.maximumasp.com/KB/a592/restoring-database-with-litespeeds-console.aspx

You might as well look at this

http://www.simple-tech.info/how-pass-parameters-variables-and-use-set-values-field-from-a-sql-server-job-to-a-ssis-package.aspx

if you don't like to use cursors and while statement then this article is good

http://www.mssqltips.com/tip.asp?tip=1593

maybe it is for a bonus point

Hi,

You can make this your starting point

http://www.sqlservers.net/p145498-sql-server-optimization-and-the-performance.cfm

http://msdn.microsoft.com/en-us/library/cc278098.aspx#_Toc189384682

Hi,

Can you give us a sample of the tsql statement.

Hi

You can also use RowNumber, if you know the number of rows of data see

http://msdn.microsoft.com/en-us/library/ms186734.aspx

Thanks for the information

Hi,

I would use the stored procedure (separate from the application in a database) and pass the language selected as a parameter from the application. in this way it is...

i have tried the bing with no luck.

Hi,

You can check on these sites

http://msdn.microsoft.com/en-us/library/ms175887.aspx

http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_23518760.html

Thanks