Article Featured on SQLServerCentral
My article, ANSI Padding, Trailing Whitespace, and Variable Length Character Columns, is featured in today’s SQLServerCentral newsletter. Check it out!...
2010-07-16
368 reads
Advanced Troubleshooting Week at SQL University, Lesson 2
Advanced Troubleshooting Week at SQL University, Lesson 2
Welcome back to Advanced Troubleshooting Week at SQL University. I’m your guest professor...
2010-07-16
2,026 reads
The Wiffle-Waffle, or Why I’m Running for the PASS Board of Directors
I’ll announce it here first, along with some reasons why I’m waffling from an earlier post:
I’m going to run...
2010-07-16
2,202 reads
The week that was: Friday 15th July 2010
This is just a short post for a Friday, I have no technical content ready to publish today but lots...
2010-07-16
650 reads
Book Review: Rework
I recently read Rework by Jason Fried of 37 Signals ($13 @ Amazon) and it talks about a lot of philosophy...
2010-07-16
547 reads
SubQuery Performance
Why would you do this?
select distinct(hostname),
(select count(*) as criticalCnt
from @temp where severity_guid='0168A833-1732-411E-8205-C2F6CD91737D'
and hostname=t.hostname
group by hostname),
(select count(*) as criticalCnt...
2010-07-16
1,927 reads
How Can I Quickly Script Out Replication?
This script takes a distribution server name and an output directory as parameters then works through all publications on each of the servers that connects to the distribution server,...
2010-07-16
17 reads
How Can I Quickly Script Out Replication?
This script takes a distribution server name and an output directory as parameters then works through all publications on each of the servers that connects to the distribution server,...
2010-07-16
66 reads
How Can I Quickly Script Out Replication?
I recently finished taking down a bunch of servers that I was using to scale out my environment by forcing...
2010-07-16
528 reads
Free SQL Server Training for the Week of July 19, 2010
This will start a new trend on my blog. Every Friday morning I'll have a blog post covering the free SQL...
2010-07-15
756 reads
Blogs
Paginated Reporting at Scale: Choosing the Right Microsoft Platform
By Rayis Imayev
"I've seen things you people wouldn't believe..."— Roy Batty, Nexus-6 Replicant, Blade Runner (1982)(2026-Nov-08) Yep,...
The Book of Redgate: Fun with Images
By Steve Jones
We’ve celebrated our birthday many times at Redgate. In the Book of Redgate –...
Why companies use Palantir and how we help implement it in the Czech Republic
Discover how Palantir connects enterprise data, supports AI-driven decision-making and helps companies turn insights...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Alamat BCA KCP Mangunsarkoro Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Mangunsarkoro No.24, Pamoyanan, Kec. Cianjur, Kabupaten Cianjur, Jawa Barat 43211
Alamat BCA KCU CIANJUR Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. HOS Cokro Aminoto No.56-58, Muka, Kec. Cianjur, Kabupaten Cianjur, Jawa Barat 43215
Question of the Day
Too Many Choices
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