The CHOOSE keyword
G’day,
I love coming across features of SQL that I’ve not used before and one happened today – the CHOOSE statement – introduced...
2014-02-17
1,542 reads
Marty
- Interests: Playing Guitar, Music Theory
- Website: http://martincatherall.com/
TSQL-Tuesday#050 – Automation
TweetG’day,
Well, it’s the first TSQL-Tuesday of 2014 and one of my New Years resolutions for 2014 is to contribute to...
2014-01-14
1,289 reads
Do you clean up after yourself?
TweetG’day folks,
I remember a fair few years ago when I was relativly new to TSQL creating a stored procedure that...
2014-01-13
1,258 reads
Installed SQL SERVER 2012? maybe you’d like to re-set your shortcuts!
TweetG’day,
Just a quick post on a seemingly trivial matter that others may find useful.
The post was prompted by the Simple-Talk...
2013-12-30
1,358 reads
SQL Saturday #252, Christchurch New Zealand
TweetSQL Saturday #252 Christchurch, New Zealand
G’day,
Well, these are exciting times for the Christchurch SQL SERVER User Group.
After a period of...
2013-07-28
1,169 reads
Dedicated Admin Connections (DAC) and SQL SERVER 2012 SSMS
TweetG’day,
As part of any SQL SERVER install that I do, I turn on Remote admin connections (using sp_configure) and open...
2013-04-07
5,163 reads
Multiple ALTER DATABASE SET options
TweetG’day,
Did you know that you can actually combine multiple SET operations into a single ALTER DATABASE statement.
It’s true, you can!
Mostly...
2013-04-06
4,163 reads
SSPI error and Incorrect timing.
TweetG’day,
Recently, quite out of the blue I started seeing this error when I tried to log into my SQL instance...
2013-03-28
1,646 reads
The first record on data page.
TweetG’day,
I had a recent conversation about data pages. There was some debate about the location of the first record on...
2012-08-06
1,189 reads
2012 DDL for Roles
TweetG’day,
I’m extremely pleased that Microsoft are continuing their commitment to provide full DDL to preform TSQL operations that have previously been preformed using stored...
2012-04-22
1,325 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