Cast Your Data
This article looks at the T-SQL CAST function and how it is used and preferred to CONVERT().
2002-03-18
16,794 reads
This article looks at the T-SQL CAST function and how it is used and preferred to CONVERT().
2002-03-18
16,794 reads
Steve Jones completed an online eLearning course with IMG University that provided an introduction to the OLAP / Analysis services available with SQL Server 2000. This article examines some of his impressions from this vendor.
2002-03-12
3,035 reads
I found this on the Internet, but I think it's really my own personal list.
2002-03-08
2,626 reads
As I work with a particular topic or problem, I often research on the Internet
different opinions, white papers, etc. Here is a list of resources that are located both
on SQL Server Central and other sites that I have found useful.
2002-03-04
11,038 reads
2002-03-01
2,215 reads
Steve Jones examines the possible notion that a system can achieve 0% downtime. Read on to see if he thinks it's possible.
2002-02-25
5,978 reads
2002-02-15
3,562 reads
A new T-SQL Bible that is a must have for SQL Server DBAs. Read a review of this book.
2002-01-23
14,612 reads
If you are like most DBAs, you have probably implemented some type of hash function for some of your tables at one time or another. This article takes a look behind the scenes as to how the Identity property works.
2002-01-17
6,492 reads
2002-01-11
3,414 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