CPU and Scheduler Performance Monitoring using SQL Server and Excel
This article will demonstrate a method of creating an Excel-based CPU/scheduler performance dashboard for SQL Server 2005+.
2012-10-04
9,704 reads
This article will demonstrate a method of creating an Excel-based CPU/scheduler performance dashboard for SQL Server 2005+.
2012-10-04
9,704 reads
This article will show you how to use user-defined triggers to supplement your security policies, preventing unauthorised data manipulation and blocking unfriendly logins.
2012-07-12
6,448 reads
This article outlines three different tried and tested methods of obtaining access to databases in SQL Server 2005 where no database-level administrative access exists.
2012-03-07
7,352 reads
Want to seriously boost your data skills? Mastering advanced SQL is the key, whether...
The post How to Build Data Management for Unstructured Data appeared first on Joyful...
By Steve Jones
Brent Ozar is a very successful DBA/consultant/speaker/business owner in the data platform space. Many...
Hi, I would like to contribute to SQLServerCentral in peer reviews. As there are...
Comments posted to this topic are about the item Getting ANY of the data
Comments posted to this topic are about the item Why Would You Do That?
I have this data in two tables:
-- Beer table BeerIDBeerNamebrewer 5Becks Interbrew 6Fat Tire New Belgium 7Mac n Jacks Mac & Jack's Brewery 8Alaskan AmberAlaskan Brewing 9Kirin Kirin Brewing -- Beercount table BeerName BottleCount Becks 5 Fat Tire 1 Mac n Jacks 2 Alaskan Amber 4 NULL 7 Corona 2 Tsing Tao 4 Kirin 12What is returned from this query?
SELECT * FROM dbo.BeerCount AS bc WHERE bc.BeerName=ANY (SELECT b2.BeerName FROM dbo.Beer AS b2);See possible answers