Why PolyBase matters - Part 2
Part 2, a more in depth look at An alternative approach to disaster recovery and backup strategies using PolyBase.
2015-08-11
1,933 reads
APS
Why PolyBase Matters
An alternative approach to disaster recovery and backup strategies using PolyBase.
2017-08-25 (first published: 2015-08-10)
7,124 reads
SQL to APS Automation
This script was designed to help make importing data from any SQL2008+ database to an APS much easier.
2015-08-12 (first published: 2015-07-14)
971 reads
RE: sp_ExecuteSql permission chaining
No, not in SQL Server 2000 (there is help on the way in SQL Server 2005). When you run dynamic SQL in SQL Server 2000, it executes that code in a separate batch from the first. That means new security checks and ownership chaining is not continued from the calling stored procedure. You could create […]
2004-08-12
compute by [altered date] ???
Hi,Using SQL2K, can anyone make this work ? Whenever I try to compute by an altered date I get stuck...What I want is this: (this works)use northwind go select OrderDate, CustomerID, count(*) from dbo.Orders group by OrderDate, CustomerID order by OrderDate, CustomerID compute sum(count(*)) by OrderDateBUT using an converted date such as the following: (this fails)use […]
2004-08-10
2 reads
Recovery Scenarios
Greetings,Does anyone have some illustrations of recovery scenarios when media failure, and server crashes suddenly occur? My other scenario question is how does SQL Server handle torn pages in a database if media failure or server crashes occur whether you have torn pages detection on or off? TAtlanta, Ga
2004-08-04
1 reads
How to create a Data Dictionary in SQL
I want to create a Data Dictionary in SQL Server 2000(concept taken from Oracle, but with a little variation) and in that I want to capture all the table names, DB name , last updated on , last updated (by) Login, Rows before update , Rows after update. This I want to build for one server, […]
2004-08-04
2 reads
Viewing print statement output from JDBC
HiIf you put helpful debugging print statements in your TSQL how do you get to see them when you execute the stored procedure from something other than Query Analyzer e.g. from a JAva program.I think they might be appearing on a console somewhere? If so how can you see that remotely?ThanksSean
2004-07-29
355 reads
RE: Interesting ! Update query with alias ?
Interesting AJ! If you read the BOL reference I posted, it specifically states and shows by example that the syntax won't work.Guess that's one of the 'flukes' in SQL Server.-SQLBill
2004-07-29
RE: Delete taking too long
If you are absolutely positive that the records that you are about to delete don't have an related records in other tables then, as part of the delete process, try dropping the constraint before you do the delete then re-enable the constraint afterwards.
2004-07-29
Blogs
Real-World SQL Mastery: Your Hands-On, Mess-Free Sandbox
Are you ready to take your SQL skills from theoretical to tactical? If you've...
Set a Runtime Variable in an Azure DevOps Pipeline
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
A New Word: Symptomania
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers