Thank you for the question

It says on msdn link:

"You can query the bpool_commit_target and bpool_committed columns in the sys.dm_os_sys_info catalog view to return the number of pages reserved as the...

thank you for the question, it is useful

Iulian

Nice question, thank you

Iulian

Thank you Koen, Kiara and Mark , I appreciate your help

Have a nice day,

Iulian

Thanks for the question

Interesting area, but why would someone usually use trace flags in practice;

I have not used them yet so I did not had the chance to understand their...

Resources - Migration from SQL 2000/SQL2005 to SQL 2008: http://blogs.msdn.com/b/blakhani/archive/2008/12/27/resources-migration-from-sql-2000-sql2005-to-sql-2008.aspx

But this guide here is pretty inspiring:

http://www.dell.com/downloads/global/solutions/public/white_papers/SQL_2000_SQL_2008_Migration_Guide.pdf

I guess you are using Visual Studio to write the queries (dataset1 ...),

you can try SQL Server Management Studio here you can edit your queries easier and then paste...

You can evaluate Annotated XSD Schemas, I never used but looks like it might help you:

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

Regards,

Iulian

maybe this helps:

NEWID ( ) function creates a unique value of type uniqueidentifier.

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

Regards,

Iulian

Nice question thank you.

Besides the explanation on the msdn link referring to SQL 2000: http://msdn.microsoft.com/en-us/library/aa173918%28v=sql.80%29.aspx

there is also one msn article referring to SQL 2008 R2: http://msdn.microsoft.com/en-us/library/ms174203.aspx

Regards,

Iulian

What is the DML of the table?

Regards,

Iulian

Could you please attach a sample file?

Regards,

Iulian

Hello, I haven't used but I guess you need to write your own formula.

Check this:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=21948

Regards,

Iulian

I wish you luck! 🙂 post if you get stucked

Regards,

Iulian

You can try this to see if you filter the correct data:

SELECT

Department,

Tax_Year,

Tax_Period,

Total_Bill,

Total_Hours,

Purchase_Order_Number

FROM Timesheets

WHERE

(Department = '971')

AND (

( (Tax_Year = '2009') AND...