Viewing 15 posts - 511 through 525 (of 824 total)
Convince whoever made that decision of the stupidity of using XML to move "large amounts of data." Small messages are one thing, but the bloat of XML when transfering large...
/*****************
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
*****************/
May 23, 2005 at 11:14 am
I will just emphasize a point that Steve made. I have seen several projects both internal and vendors that have attempted to "port" an application from FoxPro or DBase 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
*****************/
May 23, 2005 at 11:08 am
You must login to the server using the SQL Server Service account, configure the MAPI client and then configure SQL Server to select that profile in Enterprise Manager by right...
/*****************
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
*****************/
May 23, 2005 at 10:55 am
Unfortunately, unless you had some sort of auditing application in place at the time the change was made there is only one way to find this out. If your database...
/*****************
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
*****************/
May 23, 2005 at 10:48 am
The biggest con of clustering is cost. You have to run SQL Server Enterprise Edition and have to use a SAN, both of which typically cost a bundle.
The biggest...
/*****************
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
*****************/
May 23, 2005 at 10:27 am
Sure you can shrink tempdb. You can use either the dbcc shrinkdatabase or the dbcc shrinkfile commands. If this is a production instance, I would be careful about shrinking tempdb...
/*****************
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
*****************/
May 23, 2005 at 10:07 am
There are several reasons to store the file data in the database rather than just storing a link.
First and foremost is recoverability. What mechanisim ensures that your filesystem and the...
/*****************
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
*****************/
May 20, 2005 at 1:24 pm
I think this is highly unadvisable. Linked Servers have their place, but they tend to be rather large security holes. First off, you would have to use SQL authentication with...
/*****************
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
*****************/
May 20, 2005 at 12:56 pm
To expand on what Chris said... If your users are accessing the data through the internet you probably need to use the "Per Processor" license, this has nothing to 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
*****************/
May 20, 2005 at 9:51 am
Since you are already able to connect to the other database and query it, all you should need to do is modify your source query to include the appropriate WHERE...
/*****************
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
*****************/
May 16, 2005 at 3:40 pm
Thanks for correcting the XML, but since I don't claim to be an expert in XML (as I avoid it like the plague) I pulled that example right off 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
*****************/
May 3, 2005 at 9:12 am
csv = comma seperated values. Normally it denotes an ASCII file, but not always...
/*****************
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
*****************/
May 3, 2005 at 9:09 am
...as if XML were a universal data format, PLEASE!!! Get real here. Why does a data file format need to be universally agreed upon (as if XML were)? First off...
/*****************
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
*****************/
May 3, 2005 at 9:04 am
See my post above... Run Profiler to capture each statement run with its associated CPU and IO cost.
/*****************
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
*****************/
April 27, 2005 at 2:53 pm
Somebody is either screwing around with you or is inadvertantly doing this. First thing I would do is to lock down SQL Server. Eliminate any unused logins and users. Very...
/*****************
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
*****************/
April 27, 2005 at 2:33 pm
Viewing 15 posts - 511 through 525 (of 824 total)