Thanks Hugo. Sorry I don't have...

Oleg Netchaev (11/15/2010)

---

Carlo,

Please check compat level of your SQL Server 2005 AdventureWorks database. If the level...

Carlo Romagnano (11/14/2010)

---

Very bad worded question:

This is related to SQL Server caching. What should be the output of following T-SQL query:

USE AdventureWorks2008R2

GO

EXEC uspPrintError

GO

SELECT st.text...

Thanks...

parthi-1705 (11/12/2010)

---

Hardy21 (11/12/2010)

---

Yes there are 6 rows in the table and index_id = 1 (its primary key). In same table, there are other indexes that has statistic date and their...

Yes there are 6 rows in the table and index_id = 1 (its primary key). In same table,...

Thanks for response.

I have executed sp_updatestats stored procedure still same records have NULL for statistic date.

Shall I need to update the statistic for NULL records manually?

Thanks @adam-2 Gojdas & Author.

It helps me to solve one issue.

As per the BOL:

If all arguments are NULL, COALESCE returns NULL with Note: At least one of the null values must be a typed NULL.

Then why "SELECT COALESCE(NULL,NULL) AS [COALESCE]"...

Good one point question. Thanks

Good question. Nice extension - Carlo. Thanks

Really Nice information. Thanks for sharing.

Please refer:

You can use WITH ROLLUP.

For example:

USE AdventureWorks2008R2;

GO

SELECT SalesQuota, SUM(SalesYTD) 'TotalSalesYTD', GROUPING(SalesQuota) AS 'Grouping'

FROM Sales.SalesPerson

GROUP BY SalesQuota WITH ROLLUP;

GO

Nice & Easy question.