SP_SPACEUSED & SP_MSTABLESPACE
Take a look two SP inside the sys Procedure in SQL Server 2008 (included also in the SQL Server 2005),...
2010-03-22
4,497 reads
Take a look two SP inside the sys Procedure in SQL Server 2008 (included also in the SQL Server 2005),...
2010-03-22
4,497 reads
A quick info where you can find the Maximum specification for SQL Server 2008/2005 (32 bit & 64 bit).
SQL Server 2008...
2010-03-21
1,238 reads
Since the early versions of SQL Server, from version 6.5 we can know and
determine the latest version that we...
2010-03-20
1,059 reads
In SQL Server 2008, by default, the option to prevent tables changes is "on". We can have some issues and...
2010-03-20
2,796 reads
SQL Server 2008 R2 Update for Developers Training Kit (March 2010 Update)
The content of this update includes 11 Presentations, 17...
2010-03-06
611 reads
There it is the SQL Server Migration Assistant or SSMS for MySQL, it comes for both versions SQL Server 2008...
2010-02-20
1,851 reads
This is a good news from the Microsoft about SQL Server Release Services for both versions SQL Server 2008 & 2005.
SQL...
2010-02-19
647 reads
It is a good news for developers! Microsoft published the Training Kit for SQL Server 2008 R2.
The content of...
2010-02-05
585 reads
Let me show you another free tool for SQL Server that is very usefull and thanks from the companies that...
2010-02-05
1,124 reads
I recieved the notification from Azure Platform Team that the CTP accouct will be closed at the end of the...
2010-01-21
374 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