Product Guide for SQL Server “Denali” released
Released today, the SQL Server code name ‘Denali’ Community Technical Preview 3 (CTP3) Product Guide download contains the latest datasheets, white...
2011-08-11
1,251 reads
Released today, the SQL Server code name ‘Denali’ Community Technical Preview 3 (CTP3) Product Guide download contains the latest datasheets, white...
2011-08-11
1,251 reads
Replaying multiple threads of a captured trace in SQL Profiler is difficult, and you are limited to replaying the workload from...
2011-08-10
1,577 reads
For those of you who use MDX, I’m sure you share my opinion that MDX is a lot harder to...
2011-08-08
775 reads
I take it for granted that everyone knows all about Microsoft certifications and Microsoft MVP’s. But a few years ago,...
2011-08-05
1,633 reads
As a consultant or contractor, many times the client we are at does not provide us with a laptop, so we must...
2011-08-03
1,236 reads
Project Apollo is a new feature in CTP3 of SQL Server Denali that enables a new columnstore index that offers...
2011-08-01
1,654 reads
Here is a tip that could make you much more productive: At home, I have a desktop computer with dual-monitors...
2011-07-29
2,282 reads
Here is a got-ya that happened to me. In SQL Server I want to generate a script of all the...
2011-07-27
9,088 reads
Here is a common got-ya. You are modifying the cube dimension security for a role-playing dimension. You make the changes and...
2011-07-25
2,021 reads
“vNext” is the codename Microsoft has chosen for the next version of the Visual Studio.
A big feature is improving the application lifecycle management...
2011-07-22
707 reads
I wanted to figure out how big (or approximately how big) my dump file...
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Comments posted to this topic are about the item Announcing SQL Server 2025
Comments posted to this topic are about the item Running Steve's Code
Comments posted to this topic are about the item New SQL Server 2022 Functions
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; GOSee possible answers