INSERT INTO SELECT vs SELECT INTO
INSERT INTO SELECT and SELECT INTO may be very similar commands but they have some important differences. Every now and...
2014-12-03
16,920 reads
Create your own SQL Tools with PowerShell and Windows Forms
Steve:
Check out a new blogger who is sharing secrets of the DBA world. In his first post, James shows us...
2014-12-09 (first published: 2014-12-03)
7,244 reads
Clustered Columnstore Indexes – part 45 (“Multi-Dimensional Clustering”)
Continuation from the previous 44 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
I have blogged a couple times (part 29 – “Data Loading for Better...
2014-12-02
367 reads
Preparing a Technical Session Part 1: Picking a Topic
So you’ve decided or perhaps were told to do a technical presentation. If this is something that’s new for you...
2014-12-12 (first published: 2014-12-02)
5,401 reads
Preparing a Technical Session Part 1: Picking a Topic
So you’ve decided or perhaps were told to do a technical presentation. If this is something that’s new for you...
2014-12-02
826 reads
Review: Ghost of My Father
I finished reading Ghost of My Father by Scott Berkun over the holiday weekend. It’s an intense read about the...
2014-12-02
551 reads
More Notes From The PASSWatch Project And Thoughts on Transparency
It’s been just over two months since I wrote the first post for PASSWatch. I’m trying hard to keep PASSWatch...
2014-12-02
551 reads
Get Information on Current Traces Running
This is just a quick informational query to save as a snippet to get some quick information on running traces,...
2014-12-02
954 reads
T-SQL Tuesday #61 – Giving Back
The Season of Giving
The annual PASS Summit (otherwise known as the #SQLFamily reunion) is over. Here in the United States,...
2014-12-08 (first published: 2014-12-02)
6,445 reads
SQL Server 20082008 R22012 || Remove Node from failover cluster
Steps to remove node from failover cluster for SQL Server 2008 onwards :-
Note :-
a) Same process will be used to...
2014-12-02
1,112 reads
Blogs
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
How to Check TDE Progress and Elapsed Time in SQL Server
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
Forums
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
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...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers