The tool is not for free, I can't afford for it to be. This is my full-time job so as my wife and children cannot live on air - I have to charge for my services which have an excellent return on investment I might add.What a suprise, Mark! No offense, but I have a […]
2004-12-20
Comments posted to this topic are about the Question of the Day for 21 Dec 2004 posted at http://qa.sqlservercentral.com/testcenter/qod.asp?QuestionID=414.
2004-12-18
Hey Steve, is there anything I can do to help with QA on the QOD?
2004-11-17
The resource kit for SQL2005 Beta2 contains a tool called databasepopulator. I think it will also work for SQL2K. Another option, though it's not free would be Quest Software (www.quest.com), which has a tool called datafactory which does what you want. M
2004-11-08
Hi,What is the best strategy for backing up my SQL data to tape using Veritas? a) Backup the transaction logsb) Use the Veritas sql agent to backup the data directlyThank you, Victor...
2004-11-01
This design limits the number of possible values to:31 if the Int field is used.63 if the BigInt field is used.If you are happy with that then why not prepopulate the table. Issues are only 2n-1
2004-10-07
it sounds like you mean that it is a two part primary key dp + num. so then you could do exactly the same thing except with a self join select... FROM legal a JOIN legal b on a.dp = b.dp AND a.num = 1 and b.num = 2 WHERE rtrim(a.descr1) + ' ' + […]
2004-09-22
Yep, that's what i got too. The XML schema created from the ado.net dataset is not compatable with what SQLXMLBulkLoad expects. Hard to believe that two things from microsoft would not be compatable. A couple of things need to be yanked from the dataset schema to make it compatable. (there was an example on some […]
2004-09-16
The table names are in the dtproperties table, but they're hard to get at.This is a crude attempt. I tried to filter out the table names, but sometimes they have an extra garbage character as a prefix. This code assumes that all table names are made up of regular ASCII characters, and that all dtproperties tables in […]
2004-09-02
You could set up a trigger to output details to a table of whose process is running although not the specific stored procedure or application. The following from BOL : This example returns the process ID, login name, and user name for the current user process. SELECT @@SPID AS 'ID', SYSTEM_USER AS 'Login Name', USER […]
2004-08-31
2 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers