Parallel Data Warehouse (PDW) How-To: Check Database Size with DBCC_pdw_showspaceused
There is a way to view the size of a particular PDW database using the DBCC_pdw_showspaceused command via the NEXUS...
2012-08-28
3,396 reads
Parallel Data Warehouse (PDW) How-To: Avoid ShuffleMove and PartitionMove Operations
There are a couple process hungry operations that can be avoided when developing or migrating T-SQL queries into Microsoft’s Parallel Data Warehouse (PDW) environment. With proper planning and attention to...
2012-08-27
64 reads
Parallel Data Warehouse (PDW) How-To: Avoid ShuffleMove and PartitionMove Operations
There are a couple process hungry operations that can be avoided when developing or migrating T-SQL queries into Microsoft’s Parallel Data...
2012-08-27
3,887 reads
Parallel Data Warehouse (PDW) Tip: Usage of SYSDATETIME() vs GETDATE()
Usage of GETDATE() dates back to the earliest versions of SQL server and has become the primary blade in our...
2012-07-21
2,754 reads
Parallel Data Warehouse (PDW) Basics: CREATE TABLE and CTAS Syntax
After forgetting the syntax for temp tables a couple of times, I decided to write a brief overview of the...
2012-07-12
3,754 reads
SQL SERVER - CTRL+SHIFT+] Shortcut to Select Code Between Two Parenthesis
Reblogged from Journey to SQL Authority with Pinal Dave:
Every weekend brings creative ideas and accidents brings best unknown secrets in...
2012-07-12
970 reads
Dynamic Multi-Threaded SSIS using C#
Here is a snippet of code that will assist in the dynamic ‘spin-up’ of duplicate SSIS packages. To put it...
2012-07-09
1,461 reads
Parallel Data Warehouse (PDW) Lesson 1: – Basic Architecture Overview
I’ll begin my coverage of Microsoft’s Parallel Data Warehouse (PDW) architecture / appliance with a brief overview of the Massively Parallel...
2012-07-09
1,104 reads
SSIS How-To: Reuse Existing Connection Manager to Execute SQL in Script Task
There’s a myriad of examples out there on how to execute a sql task via OLEDB connections and C# in a...
2012-04-09
3,268 reads
Blogs
AI: Blog a Day – Day 7: Vector and Vector Databases
By Vinay Thakur
Continuing from Day 6 we learned Embeddings, Semantic Search and Checks, on Day 7...
AI: Blog a Day – Day 6: Embeddings – How AI Understands
By Vinay Thakur
Continuing from Day 5 where we covered notebooks, HuggingFace and fine tuning AI now...
The Book of Redgate: Mistakes
By Steve Jones
This is kind of a funny page to look at. The next page has...
Forums
Why End-User Testing Is Even More Important with AI
Comments posted to this topic are about the item Why End-User Testing Is Even...
Dynamic Unpivot
I have a table I didn't design that has tons of repeating groups in...
Writing as an Art and a Job
Comments posted to this topic are about the item Writing as an Art and...
Question of the Day
String Similarity II
What is the range for the result from the EDIT_DISTANCE_SIMILARITY() function in SQL Server 2025?
See possible answers