How SQL Server stores indexes on variable length columns
In the last months I had done a lot of performance tuning workshops, and there is
almost the same question: How...
2011-01-10
2,392 reads
In the last months I had done a lot of performance tuning workshops, and there is
almost the same question: How...
2011-01-10
2,392 reads
Microsoft released the first CTP version of SQL Server Denali during the SQLPASS Community
Summit in Seattle last year. Since this...
2010-12-10
1,466 reads
Today I’m very proud to announce a FREE SQL Server consulting service from me called
the “SQLDoctor”.
The concept of the SQLDoctor...
2010-11-17
583 reads
As announced in both of my session you can find my slides & samples here for download:
Building FILESTREAM
solutions with SQL Server...
2010-11-15
674 reads
On January 4, I’m speaking about index internals for the Performance Virtual Chapter
of PASS (http://performance.sqlpass.org).
Here’s my session abstract:
SQL Server provides...
2010-11-02
609 reads
Beginning with tomorrow I’m no longer working for HP Austria, because I’m starting
my own SQL Server Consulting business. I’ve been...
2010-10-31
1,551 reads
I’m one of the 3 lucky guys whose submitted precon workshop for the developer category
for PASS SQLRally is in the...
2010-10-25
639 reads
As announced in my workshop and in my sessions at the SQLdays 2010 last week in Rosenheim/Germany,
you can download my...
2010-10-25
479 reads
As announced in my SQLBits workshop & session last week in York/UK, you can find the
session/workshop material here.
Have fun!
-Klaus
2010-10-04
420 reads
As announced in my StreamInsight session at 24HOP you can download the session material
from here.
Within the next weeks I will...
2010-09-17
547 reads
The first version of my accounting assistant could not find a single purchase of...
Why isn’t AI paying off yet? Drawing on lessons from digital transformation, Joyful Craftsmen...
By Steve Jones
I’m really excited about some growth in Flyway support. I’ve been asking about this...
Comments posted to this topic are about the item Pay for Performance, which is...
WhatsApp:0817819444 Jl. KH. Wahid Hasyim No.20, Jombang, Kec. Jombang, Kabupaten Jombang, Jawa Timur 61415
WhatsApp:0817819444 Jl. Jend. Sudirman No.6, Mulyoharjo, Kec. Pemalang, Kabupaten Pemalang, Jawa Tengah 52313
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