|
Release 1.3 of Mogwai ERDesignerNG available Personally I am glad to see the post. It has saved me hours of trolling through meaningless search results to find a functional graphical database design tool I (assuming this this is actually functional). I've often wondered which came first, usenet topic-cops or home owners associations. They both resemble m... 5 Jul 2008 21:42
Cursor among several databases Hi all, I am wondering if anyone can help. I am doing a sp that search for any string in any row of any table in any database. The idea is to create the sp on the master database and from there call it passing as parameter the database to do the search and the string to be serached. I using cursor (two cursor... 4 Jul 2008 10:00
design issues with large amounts of data I'm tinkering around with a data collection system, and have come up with a very hackish way to store my data- for reference, I'm anticipating collecting at least 100 million different dataId whatevers per year, possibly much more. ---366 data tables ( one for each day of the year ), each row being assigned a u... 5 Jul 2008 06:24
SELECTing from a DML statement DB2 allows one to select from an insert, update, or delete, e.g.: select * from old table (delete from x where y = 1); --OR-- select * from new table (update x set y = 1 where z = 2); --OR-- select * from final table (insert into x (c1) values (1)); Is there any equivalent in SQL Server? Thanks and... 5 Jul 2008 13:32
Using UPDATE to sequentially abbreviate address information Greetings, I'm trying to update an address field with "standard" abbreviations so that I can do a comparison of various accounts to one another on the address. I can update a set of records for "Road" to "Rd", but when I tried to stack the update clauses, I seem to get random updates within the file. All the u... 4 Jul 2008 16:09
Odd character appended to data The following character keeps appending itself to data inserted through a web form. What is it from (how is it generated) and how can it be removed? Here it is: Â ... 3 Jul 2008 14:34
Datetime import/export issue I am migrating data from one database to another. The process requires that I significantly modify the table and data structure. Therefore, I am exporting the data to a csv, making the adjustments and then importing it to the new table. One of the fields being migrated is a datetime field. When I export the da... 2 Jul 2008 11:53
Yellowfin Business Intelligence Release 4.0 Announced to Industry (CDT) Tue Jul 1, 2008 10:45am -- Announced today, the next release of Yellowfin Business Intelligence, 4.0 is scheduled for the end of July. Whilst most of the activity in the BI space has been busy with merger and acquisitions, Yellowfin has continued focussing its efforts to develop web Business Intelligence soft... 2 Jul 2008 07:47
slow queries for a particular database Bear with me here folks, I don't know much MS SQL performance. Wondering if someone can point me in the right direction. I have 1 particular database where queries are slow. To test this theory, I am running a SELECT COUNT(*) on some of the tables that have many rows (2-4 million rows). Example: A table with ap... 3 Jul 2008 18:41
sql agent JOB to Backup Database and Maintain Backup Files Hi friends, How can I create ONE SQL Agent JOB That will 2 activities: (Using SQL 2005) 1) Backup a specified Database (Full Backup) and store the backup file in a Specified FOLDER. 2) Manage the Backup Files in the FOLDER, ie. Delete the files that are 5 week OLD. I want to schedule the JOB to run every S... 30 Jun 2008 16:51
Need a script to recreate scheduled jobs I created a new database instance, but I forgot to script out the scheduled jobs before I wiped out the original database instance. I have attached the original msdb database as msdb_old onto the new instance, but I need a script to pull out the require information from sysjobs, etc. to recreate the jobs. Ple... 30 Jun 2008 18:55
Help needed for Data formatting. Hello all, I just started using SQL to create a report. I got the syntax working but I have absolutely no idea of how to format data. Can anyone kindly look at my code and help me? I thank you in advance. Details:- The code: SELECT Column1, Column2, Column3 FROM WORKSHEET Output: Column 1 Colu... 30 Jun 2008 16:51
How can I do that using a trigger Hi! I've got a table where an index number is already given. I want to establish a trigger on a tmp table, so each time rows are inserted, the trigger verify the next number available in the main table, and then update it. I've tried this: ----------------------------------------------------------------... 30 Jun 2008 18:55
OLEDB configuration when deploying multiple SSIS packages I have an SSIS package which calls many other SSIS packages. Each of these was created with the import wizard in SSMS. As a result, they all have SourceConnectionOLEDB and DestinationConnectionOLEDB connections listed under the Connection Manager in the package designer. T deploy the packages to another server... 30 Jun 2008 13:45
Decimal point and comma I 'd like to insert (via "bulk insert") between 10-20 files (about 300MB each) into one table. The problem is that in input files decimal point is written as "," and without leading zeros (i.e.: ",45"), and sever uses ".". So I 've got an "type mismatch" error. I can't re-build input file, as well as I can't c... 30 Jun 2008 18:55
Stop hotlinking to a specific file & keeping a counter Sinikeltainen linja romahtaa. �gestan ruotsalaisydinvoimala osoittautui valmistuessaan 1963 jo vanhentuneeksi. Tuottaen ydintyyliin 3 milj kruunua tappiota. Vaivasi itsepintaiset s�teilyvuodot. 1974 suljettiin ensimm�isen� ruotsalaisena ydinvoimahylkyn�.(Vaan ei toki viimeisen�!)) My�s Marvinke-hanke raskasves... 29 Jun 2008 01:57
Please Help - Can't check for duplicates I'm driving myself crazy with a problem in trying to translate a query written for Access to that for SQL server. I would think that I would use a trigger, but am not sure how to set it up. We have a database that manages bookings in four banquet halls. It was running in an Access database, but two years ago... 30 Jun 2008 02:28
Deploying an app with SQL Server (installation on client machine) I have an app that will be using SSE as the backend database. My app consists of several executables and libraries, I need to bundle all of them together with SSE. Ideally, I would like to provide a single installation file that installs my program, and also the SSE database. Any links/instructions/advice on... 27 Jun 2008 12:08
How to secure a database ...? I am writing an application which I will deploy to my clients. It is important for security, support, IP reasons etc, that the users are not able to access my databse schema (i.e. view/modify/run procs etc). What do I have to do to ensure that users will not be able to access my database? Also, I am thinkin... 28 Jun 2008 08:36
FREE SOFTWARE DOWNLOAD FREE SOFTWARES DOWNLOAD ONLINE http://freesoftwareonlinedownload.blogspot.com ... 27 Jun 2008 04:58 |