Using MS SQL Server

======> Secret Video CLIPS <=========
Hi....Friends, watch and enjoy SECRET WEB-CAMS at LADIES HOSTELS and INTERNET CAFE SEX SCANDALS VIDEOS... http://www.hollywoodpopstars.blogspot.com http://www.googlemobilesphones.blogspot.com ... 6 Jul 2008 10:56

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... 7 Jul 2008 09: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... 8 Jul 2008 12:04

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