How index gets dropped in Views in SQL Server
Hi Friends, In this blog I am going to tell about dropping of indexes in view in SQL Server. Views...
2015-04-18
271 reads
Hi Friends, In this blog I am going to tell about dropping of indexes in view in SQL Server. Views...
2015-04-18
271 reads
I’m proud to announce my company, Heraflux Technologies, is looking to fill the position for Vice President of Business Development....
2015-04-17
452 reads
“He’s a screw-up. Always trying things that don’t work.”
I’ll be honest: I used to be afraid of being the person...
2015-04-17 (first published: 2015-04-09)
5,687 reads
An Important Rule:
If you’re trying to convince someone to your viewpoint, insulting them generally doesn’t work. If it does anything,...
2015-04-17
300 reads
I recently finished the book Now You See It: Simple Visualization Techniques for Quantitative Analysis by Stephen Few of Perceptual...
2015-04-17 (first published: 2015-04-07)
7,371 reads
Welcome to SQLSaturday #380 - Precons Announced!
In addition to the extraordinary extravaganza SQLSaturday NYC event we have planned for Saturday, May...
2015-04-17 (first published: 2015-02-11)
6,022 reads
I’ve been intrigued by Windows Phone as a platform. I’ve never owned one, and while I considered getting one, the...
2015-04-17
834 reads
Last year, I was very much honored to be selected to deliver a pre-con with my friend brother Chris Shaw (B|T). I...
2015-04-16
411 reads
I was recently asked to do some fairly heavy modifications to a table. It involved adding 6 new columns, removing...
2015-04-16
963 reads
Intro
This blog post is designed to be useful to two different audiences:
Those implementing Ola Hallengren’s Maintenance Solution for the first timeThose...
2015-04-16
6,021 reads
By Steve Jones
Recently I had someone internally ask about whether SQL Source Control supports Git Hooks....
By Steve Jones
At Redgate, we’re experimenting with how AI can help developers and DBAs become better...
I was messing around performing investigative work on a pod running SQL Server 2025...
All, My query is as follows: SET DATEFORMAT dmy SELECT p.query_id, DATEADD(MICROSECOND,-rs.max_duration,rs.first_execution_time) AS starttime,...
Comments posted to this topic are about the item Encoding Strings
Comments posted to this topic are about the item Deep Learning and Craftsmanship Matter
I have this code in SQL Server 2025. What is the result?
DECLARE @message VARCHAR(50) = 'Hello SQL Server 2025!'; DECLARE @encoded VARCHAR(MAX); SET @encoded = BASE64_ENCODE(@message); SELECT @encoded AS EncodedResult;See possible answers