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,955 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,132 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)
995 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
389 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
Daily Coping 30 Nov 2022
By Steve Jones
Today’s coping tip is to learn a new skill from a friend or share...
Encrypting Your SQL Data Should be Your Default Option
Cyber-attacks and data breaches seem to be perpetually on the rise. Every week we...
Power BI Embedded: Using Row-Level Security for Multilingual Reports
By DataOnWheels
Making multilingual reports in Power BI requires a lot of different elements. Translations can...
Forums
How to apply rates in a time column
Hello all I have this selected column : convert(TT.horas, Time) AS TimeTT, this column...
Designing Database from a piece of paper
Greetings experts, Hopefully, this is the forum for my question. I am trying to...
Ask SSC