Fine Tuning Production SQL Servers
The Silicon Valley SQL Server User Group – Jan 17 2012 Thanks you everyone for attending session, here is the presentation...
2012-01-18
739 reads
SQL Performance Tuning - optimizing for response time
Different queries are optimized for different objectives
Response Times and Throughput are two standard objectives.
Response Time is about retrieving the hits...
2012-01-18
852 reads
#SQLThursday is here
Struggling to source quality free content on SQL Server? Finding it difficult to fill the void between #TSQL2sDay and Un-SQL...
2012-01-17
420 reads
Eliminating Successful Backup messages with Powershell and SMO
As a DBA, I enjoy knowing that the better job I do, the less likely it is that any of...
2012-01-17
956 reads
CTE command In Sql Server
Common table expression (CTE):- Common table expression or CTE can be described as the temporary, named record set return by...
2012-01-17
5,003 reads
SQLServerCentral Webinar #15
Once again, I’m the moderator for a webinar coming up at the end of the month, on Jan 31, 2012....
2012-01-17
832 reads
PASS Data Architecture VC presents: Audrey Hammonds–Database Makeover: Renovate Your Data Model
Subject: Database Makeover: Renovate Your Data Model
Start Time: Thursday, January 19, 2011 12:00 PM US Central Time (January 19, 2011...
2012-01-17
500 reads
ColoradoSQL for January 2012
All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend...
2012-01-17
573 reads
Goals – 6 month checkup
Last week’s resolutions post reminded me that it’s time for another status check on the goals I set for myself...
2012-01-17
833 reads
A Trio of Functions
I found myself perusing an execution plan the other day. I know, big surprise there. This execution plan showed me some interesting things I had never really paid much...
2012-01-17
23 reads
Blogs
How I Built RAG for My Accounting App on Bedrock and pgvector
The first version of my accounting assistant could not find a single purchase of...
Why AI isn’t paying off yet, and what to invest in first
Why isn’t AI paying off yet? Drawing on lessons from digital transformation, Joyful Craftsmen...
Flyway Tips: Analytics Platforms (Snowflake and Databricks)
By Steve Jones
I’m really excited about some growth in Flyway support. I’ve been asking about this...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Alamat BCA KCP City Center Hub/Wa. 0817-819-444
WhatsApp:0817819444 Kawasan Terpadu The City Center, Gedung Perkantoran Tower One, Ground Floor, Jl. K.H....
Alamat BCA KCP Majalaya Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Raya Laswi No.212 A, Majalaya, Kec. Majalaya, Kabupaten Bandung, Jawa Barat 40382
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