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
287 reads
How CONCAT_NULL_YIELDS_NULL behave with computed columns In Sql Server
Hi friends, in this blog I am going to tell you about effect of CONCAT_NULL_YIELDS_NULL for computed columns while creating...
2015-04-18
240 reads
Rebuild Indexes of database with fragmentation more than 30%
Rebuild of indexes is the prime job of a DBA as heavily fragmented indexes can degrade query performance and cause your application...
2015-04-29 (first published: 2015-04-18)
17,727 reads
Windows Phone – What Should Microsoft Do?
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
842 reads
Heraflux is Hiring
I’m proud to announce my company, Heraflux Technologies, is looking to fill the position for Vice President of Business Development....
2015-04-17
457 reads
On Software and OS Lifecycle Management
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
305 reads
On Software and OS Lifecycle Management
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-30 (first published: 2015-04-17)
5,139 reads
Good things should be appreciated–SQL sentry Plan Explorer TIP #95
Although , It is out of box but I would like to share here. I am very choosy in food. When...
2015-04-16
561 reads
Error Creating Remote Distributor When Creating a Local Distributor
Recently, I was working on a Peer-to-peer replication automation project. When I switched from my local test servers to some...
2015-04-16
754 reads
April Blogger Challenge 3 – Filtered Indexes
The April Blogger Challenge is from Ed Leighton-Dick and aimed at new bloggers, but anyone is welcome. I’m trying to...
2015-05-01 (first published: 2015-04-16)
5,249 reads
Blogs
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten Years of PowerShell
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Forums
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Managing Feature Flags with GET_BIT() and SET_BIT() in SQL Server
Comments posted to this topic are about the item Managing Feature Flags with GET_BIT()...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers