New Trends In Storage Technology: AFD
I have a passing interest in storage technology and trends so you can probably guess I got really excited after...
2010-04-01
500 reads
Kendal Van Dyke
SQL Saturday #33 Recap
SQL Saturday #33 was held on Saturday, 3/6, at the Microsoft campus in Charlotte. Hosted by the Charlotte SQL Server...
2010-03-16
1,055 reads
Solid State Drive Performance Hands-On: Part 1
(Punch it, Hurb
Yo, I don't think we should talk about this
Come on, why not?
People might misunderstand what...
2010-03-09
1,989 reads
Presenting At SQL Saturday #33 - Charlotte
Just a quick note to let you know that I'm presenting two sessions at SQL Saturday #33 in Charlotte on...
2010-02-17
737 reads
A Tale Of Two Execution Plans – Solved!
Earlier this week I wrote about a perplexing problem I was having where identical servers were producing different execution plans...
2010-02-12
1,297 reads
A Tale Of Two Execution (Updated)
Update: Scroll to the bottom for more information added after originally posting.
Earlier this week a coworker asked me for help...
2010-02-10
706 reads
Three Things That Got Me Here
Tim Mitchell (Blog | Twitter) and Jack Corbett (Blog | Twitter) both tagged me in the latest meme circulating through the SQL...
2010-02-04
556 reads
Use Your Tech Skills To Help Haiti
By now you've heard about last week's earthquake in Haiti and have seen the devastating impact that it had on...
2010-01-19
356 reads
We Interrupt Your Regular SQL Blogging For This Announcement…
EXEC sys.sp_addextendedproperty
@name = N'IsWifePregnant',
@value = N'True',
@level0type = N'USER',
@level0name = N'Kendal.VanDyke' ;
EXEC sys.sp_addextendedproperty
@name = N'ExpectedDueDate',
@value = N'August 2010',
@level0type = N'USER',
@level0name...
2010-01-12
792 reads
10 Goals For 2010
As is the traditional thing to do at the beginning of a new year I'm making goals for what I'd...
2010-01-12
628 reads
Blogs
How to find free space in Azure PosgreSQL
I wanted to figure out how big (or approximately how big) my dump file...
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
Announcing SQL Server 2025
Comments posted to this topic are about the item Announcing SQL Server 2025
Running Steve's Code
Comments posted to this topic are about the item Running Steve's Code
New SQL Server 2022 Functions
Comments posted to this topic are about the item New SQL Server 2022 Functions
Question of the Day
Running Steve's Code
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc]
AS
SELECT Consumer_ID ,
Trend_Category ,
Bit_Trace
FROM NewWorldDB.dbo.MarketTrend;
GO See possible answers