SQL Server A to Z – Waits
In the world of SQL Server, a process is either running, runnable, or waiting. A running process is, obviously, running;...
2011-11-28
915 reads
In the world of SQL Server, a process is either running, runnable, or waiting. A running process is, obviously, running;...
2011-11-28
915 reads
If you are a DBA in Space fan, and in case you missed them, there have been two items published...
2011-11-28
679 reads
Dimensions are often recycled for multiple purposes within the same database. For instance, a “Date” dimension can be used for...
2011-11-28
4,892 reads
Do you have $5 you could re-direct from a cup of coffee to a donation on men’s health issues?
If you...
2011-11-28
490 reads
Are you 100% satisfied with your current job? Of course not!
When given serious consideration most people will agree that there...
2011-11-28
939 reads
2011-11-28
768 reads
This is a continuation of my DBA in Space journal.
Episode six is filmed at the “Visions of the Future Exhibit”...
2011-11-28
763 reads
Ed Wilson (Blog|Twitter) aka Scripting Guy is kicking off another guest blogger week (Nov 28th 2011) with my guest blog...
2011-11-28
3,577 reads
This post was published to Vinay Thakur – Sql Server DBA at 5:05:51 PM 11/25/2011 Day 28: Linked server errors Linked...
2011-11-28
637 reads
Lazy writing , eager writing and checkpoint use asynchronous IO in writing pages to disk. The purpose of asynchronous IO is...
2011-11-28
12,275 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