Forum Replies Created
Viewing 15 posts - 796 through 810 (of 824 total)
-
RE: SQL Injection!
Good information, thank you Chris.
As a DBA SQL Injection is one of my big concerns. My biggest problem usually lies in getting our developers to appreciate that it's a...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
-
RE: Restoring system databases to different SQL Edition
I can't say that I've done this with master, but msdb works (going from Standard to Enterprise) as long as they are both at the same SP/version level.
Off the top of...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
-
RE: Weird error message when inserting table
Given the error text I would tend to think that this is an application issue. There may be a SQL Server error somewhere in the process, but it appears that...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
-
RE: DB Backup files
You are correct in your assumption that sqlmaint actually looks at the timestamp portion of the file name to determine which files to delete for a given database. It will...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
-
RE: Linked server, index service and security
My guess is that you don't have access!
Actually, it might help if you provided some more details. When (under what circumstances) are you getting...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
-
RE: JOIN VS CORRELATED SUBQUERIES
As pointed out in other posts, the second example would give an error unless there was a 1 to 1 relationship between the two tables.
On the other hand, many subqueries...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
-
RE: For SQL Server, XML Is One Answer
quote:
I concur that we need to remain civil. Overall both this article and the original have evoked a good deal of discussion.../*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
-
RE: For SQL Server, XML Is One Answer
quote:
I must admit to being confused by your anger. Your criticisms do not appear directed at the position that I took./*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
-
RE: For SQL Server, XML Is One Answer
quote:
I don't see this article as arguing for XML as a data management tool...That is...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
-
RE: For SQL Server, XML Is One Answer
In response to your article which argues that XML is a good way to manage data, I would simply make one statement and ask one simple question.
The relational model of...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
-
RE: Cluster That Index - Part 2
Good series of articles Chris. I especially appreciated that you got the "physical ordering" thing right. That is the source of much confusion, and if I were to...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
-
RE: Is XML the Answer?
quote:
I agree with the article. I have to ask the possibly naive question: why can't you do all that you can do.../*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
-
RE: Is XML the Answer?
quote:
1. Does XML not bring flexibility to the data source?If I am the consumer of a csv file, changing the order or...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
-
RE: Is XML the Answer?
quote:
Mr. Peterson, you are obviously an intelligent and well spoken individual who is very familiar with the topic of data management. I...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
-
RE: Is XML the Answer?
quote:
XML addresses two major needs: transferring data from one place to another and storing "sparse" data. The usefulness of XML in transferring.../*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
Viewing 15 posts - 796 through 810 (of 824 total)