SQL Server System Views: The Basics

When maintaining or refactoring an unfamiliar database, you'll need a fast way to uncover all sorts of facts about the database, its tables, columns keys and indexes. SQL Server's plethora of system catalog views, INFORMATION_SCHEMA views, and dynamic management views contain all the metadata you need, but it isn't always obvious which views are best to use for which sort of information. Many of us could do with a simple explanation, and who better to provide one than Rob Sheldon?

Data Mining Part 30: System Views

Sometimes we need to retrieve system information from our data mining models. In this chapter, we will show how to do it using system views.

Data Mining Part 30: System Views

Sometimes we need to retrieve system information from our data mining models. In this chapter, we will show how to do it using system views.

SQL Server 2008 views

RE: Can Job from one server trigger another job on a different server???

Try exec [AVB1\AVB1].msdb..sp_start_job 'UpdateMTS_AVB1'But, remember that you have to set up your 'restore' server up as a linked server and you can give it any alias you want on the backup server. It is the linked server alias you put in the command above.Peter

RE: Crosstab -- eliminate rows with all zeroes

select strBusinessFunction,        SUM(CASE WHEN strCondItionStatus ='A'and strTestPlan = @TestPlan  THEN 1 ELSE 0 END)AS 'A',        SUM(CASE WHEN strCondItionStatus ='U'and strTestPlan = @TestPlan THEN 1 ELSE 0 END)AS 'U',        SUM(CASE WHEN strCondItionStatus ='X'and strTestPlan = @TestPlan THEN 1 ELSE 0 END)AS 'X' FROM   tblconditions -- insertText WHERE  strCondItionStatus in ('A', 'U', 'X') -- […]

RE: QOD of 6/12

No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!