Are my Linked Servers Being Used?
This is a follow up to an article published on 3/1/2012. That article showed how to find what linked servers...
2012-03-05
2,781 reads
This is a follow up to an article published on 3/1/2012. That article showed how to find what linked servers...
2012-03-05
2,781 reads
AdvertisementsUse the simplest script to find the latest database backup and the location.
-- To get the backup history
SELECT top 100...
2012-03-05
872 reads
Introduction
This blog covers the High Availability Solutions provided by SQL Server i.e. Database Mirroring.
Database mirroring is a solution in SQL...
2012-03-05
1,839 reads
I have had a few people ask me recently about books that I would recommend to help further develop your...
2012-03-05
743 reads
Woohoo! I have been selected to present my SSIS Tips & Tricks presentation at this year's 24 Hours of Pass. I am...
2012-03-04
523 reads
Originally posted: 3-4-2012 Welcome to a new blog series of tips related to Oracle with a focus on helping those...
2012-03-04
600 reads
Pretty much right on schedule, Frank Delattre has released CPU-Z 1.60, which has support for some new and upcoming processors...
2012-03-04
841 reads
Resource Governor(RG) is a technology which introduced in SQL server 2008 to manage the CPU and Memory resource that a incoming session can...
2012-03-04
4,686 reads
I'm very happy today to announce 4 new upcoming SQL Server workshops across Europe
within the next months:
SQL Server Configuration...
2012-03-04
934 reads
Common reasons for query time-outs are :
1) The application starts using a query not optimal for the index
2) Hardware changes\...
2012-03-04
4,409 reads
By Rayis Imayev
"I've seen things you people wouldn't believe..."— Roy Batty, Nexus-6 Replicant, Blade Runner (1982)(2026-Nov-08) Yep,...
By Steve Jones
We’ve celebrated our birthday many times at Redgate. In the Book of Redgate –...
Discover how Palantir connects enterprise data, supports AI-driven decision-making and helps companies turn insights...
Comments posted to this topic are about the item Pay for Performance, which is...
Comments posted to this topic are about the item Too Many Choices
Comments posted to this topic are about the item Table Partitioning in SQL Server:...
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers