Lost in Translation – Deprecated System Tables – sysconstraints
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-07-07
1,590 reads
5 Reasons Why I Need To Go To SQLskills Immersion Training
I was thinking about the contest that SQL Sentry is running for a week of SQLskills Immersion Training, and the...
2012-07-07
967 reads
MDX ClosingPeriod and PeriodsToDate
I’ve decided that the best way to spend a day of 104 degree weather is to sit inside and write...
2012-07-07
1,297 reads
This week’s links on monitoring SQL Server performance
From time to time, I will be posting links that I encountered during the week. This is also one way...
2012-07-06
840 reads
Find the size of Index in SQL Server
As we know, sp_spaceused gives the size of table and index but it gives the sum of size of all...
2012-07-06
7,519 reads
IOPS verses Throughput – Measuring Performance of Your Storage
Working on a recent consulting job, I was asked to explain the difference in throughput, which is, measured in MB/s...
2012-07-06
1,211 reads
The Standing Desk – In the Light
It’s been almost a month since I started the Standing Desk experiment. My first setup was down in the basement,...
2012-07-05
1,132 reads
Lost in Translation – Deprecated System Tables – sysconfigures
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-07-05
1,213 reads
Differences in the Null Bitmap between SQL 2005 and 2012
Hello Dear Reader, I’ve been working on a series for BIDN.com, the Business Intelligence Developers Network, on how to read...
2012-07-05
1,235 reads
SQL Server table partition switching
If you are using partitions in SQL Server, be aware that “partition switching” is a great feature to quickly truncate partitions...
2012-07-05
8,032 reads
Blogs
Reading Blogs: T-SQL Tuesday #204
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
Are Blogs Still Relevant? - T-SQL Tuesday #204
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
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...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Slow - Linked server query
Hi I have this slow query that is pulling data from a linked server....
Too Many Choices
Comments posted to this topic are about the item Too Many Choices
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