CONCAT() string function–SQL Server 2012
As the name indicates, CONCAT() will concatenate two or more strings. This is one of the two string functions introduced in...
2011-12-22 (first published: 2011-12-19)
3,991 reads
Sam Vanga
Why did I start blogging?
This post is in response to #meme15 started by Jason Strate (b|t). Two questions were asked in the first assignment....
2011-12-16
672 reads
T-SQL Tuesday #025 – Tips and Tricks
And the trick i share for this month’s T-SQL Tuesday is… Distraction free management studio.
If you’re an avid writer, you might...
2011-12-13
726 reads
Create Drillthrough Reports
Use Actions!
Your user wants a summary report, containing sales for calendar year, for example. When the user clicks on the...
2011-12-06
926 reads
Start Documenting Your Day! Why Now?
I read a post about documenting your day by Steve Jones, here is where culture insists i write a few words about...
2011-11-30
1,529 reads
New string function in SQL Server 2012 – FORMAT()
Formatting numbers in an SSRS report is a common task. For example, you may want to format a number as...
2011-11-29
3,233 reads
SSAS Processing Mode (Lazy Aggregations)
Processing mode property of a partition/measure group determines how partitions will be available to users.
Processing mode has two possible options.
Regular....
2011-11-21
3,250 reads
Create Sparklines in SSRS
When creating a SSRS report, you want to add lines that display trends. Sparklines that were introduced in SQL Server 2008 R2...
2011-11-14
3,887 reads
#SSRS error – An item with the same key has already been added
Here is a simple yet annoying error I ran into while creating a dataset. Below is the query that I...
2011-11-10
2,194 reads
Column alias in order by and where
If you ever wonder why column alias can be used in order by and not in where clause, it’s the...
2011-11-08
6,610 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