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
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
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
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
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
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
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
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
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
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
By HeyMo0sh
As a DevOps professional, I’ve seen firsthand how cloud costs can quickly spiral out...
By Steve Jones
AI is everywhere. It’s in the news, it’s being added to every product, management...
By Vinay Thakur
RAG — Retrieval Augmented Generation. we have covered so far — embeddings, vectors, vector...
Hi, ssms is free here. I can think of other reasons to do this...
I've written some documentation on using different Markdown types of files on GitHub. It's...
Comments posted to this topic are about the item Not Just an Upgrade
I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?
USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO USE DNRTest GO CREATE TABLE MyTest(myid INT) GO USE master RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACESee possible answers