SQL Server Utility in SQL Server 2008 R2
One of the new management related features in SQL Server 2008 R2 is SQL Server Utility. SQL Server Utility gives...
2010-03-15
4,162 reads
One of the new management related features in SQL Server 2008 R2 is SQL Server Utility. SQL Server Utility gives...
2010-03-15
4,162 reads
Microsoft has recently announced that SharePoint 2010 and Office 2010 will RTM in April 2010, and will be officially launched...
2010-03-11
5,814 reads
If you want to record the results of some useful, instance level DMV queries somewhere where you can easily query...
2010-03-09
1,146 reads
It is pretty common for large, busy SQL Server instances to run into I/O bottlenecks. Even smaller, less busy systems...
2010-03-09
4,505 reads
I just wanted to remind people to participate in T-SQL Tuesday #004 on the subject of IO. You just need...
2010-03-08
555 reads
I have been playing around some more with SQL Azure in order to get ready for an upcoming presentation, so...
2010-03-05
2,266 reads
Microsoft has a new KB article outlining issues with using SCOPE_IDENTITY and @@IDENTITY to retrieve values inserted into an identity...
2010-03-03
2,730 reads
I attended and presented at the Rocky Mountain Tech Trifecta yesterday, where I had a very nice time. Julie Yack...
2010-02-28
1,478 reads
Since I like to measure and monitor things (maybe that is why I am a DBA), and I care about...
2010-02-28
1,562 reads
Here is the script that has the diagnostic queries that I will be using during my presentation at the Rocky...
2010-02-26
2,753 reads
In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...
By Steve Jones
The 11th episode is now live, recorded a few weeks ago at the PASS...
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
Dipping my toes into the waters of Azure and of course before I get...
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
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