| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | Hi friend ! is there anyway to erase the whole content of a database
other than executing the script.
Phung
|
10-23-2007 08:37 AM
Jack Vamvas  | 2 | 63 |
 | | Hi,
I have some database files (.MDF, .LDF,...) on the server. When I try
to delete them, the warning "Cannot delete file: There has been a
sharing...
pearl146@hotmail.com
|
10-22-2007 02:34 PM
joel garry | 39 | 195 |
| | | Hi,
Can anyone recommend books in Spanish for Database Design and
Normalisation?
¿Puede alguien recomendar libros en español para Diseño de Base...
mtbvfr
|
10-22-2007 03:03 AM
bbcworldtour@hotmail.com | 1 | 54 |
| | | Hi there
I have been given the job of developing a provision that enables
recording of anniversaries - that is dates - against a variety of
entities...
PeterF
|
10-21-2007 07:02 PM
PeterF | 2 | 45 |
| | | Im trying to dedupe a table with only one field on it. The table has
40 million records in it. What is the fastest way?
1) create a table with a...
Michael Evanchik
|
10-21-2007 05:10 AM
Erland Sommarskog | 1 | 43 |
| | | hi my friends;
i have got a problem.i thing you can help me
a='\x80\x02}q\x00(K\x02K\x03K\x04K\x06K\x05K\x07u.'
i want to store database but i don't...
oruccim@gmail.com
|
10-20-2007 09:05 PM
Ed Murphy | 3 | 53 |
| | | I've come accross queries like this one previously but never got the
time to carefully study them form some book.
SELECT 1 WHERE 1 = 1
1) What do...
Mukesh_Singh_Nick@yahoo.com
|
10-20-2007 11:52 AM
Arto V Viitanen | 3 | 81 |
| | | Im trying to figure out the best way and/or fastest way to Match some data
comming in....example below
the below is all the incomming information i...
MikeJ
|
10-19-2007 05:39 PM
Erland Sommarskog | 1 | 91 |
| | | Hi everybody,
I'm installing a network monitoring tool (OpManager). During
installation I reached the following step: Configure the SQL...
pearl146@hotmail.com
|
10-19-2007 05:28 PM
Erland Sommarskog | 1 | 52 |
| | | Hi,
I have a "funny" problem that does not make sense to me.
I have a SELECT statement that manipulate a datetime :
SELECT COUNT(ID) AS Amount,...
Christian Ulrich
|
10-19-2007 06:40 AM
Christian Ulrich | 2 | 68 |
| | | We have this basic SELECT statement:
SELECT product_id, we_date, sum(demand_units)
FROM weekly_transactions
WHERE demand_units > 0
GROUP BY...
imani_technology_spam@yahoo.com
|
10-18-2007 11:37 PM
--CELKO-- | 4 | 65 |
| | | Hi,
I'm new to SQL Server, but an experienced .Net developer. I'm trying
to accomplish a query the most efficient way possible. My question is
if...
Yota
|
10-18-2007 10:29 PM
Ed Murphy | 5 | 78 |
| | | I need to map several columns of data from one database to another
where the data contains multiple spaces (once occurance of a variable
number or...
Joe Cool
|
10-18-2007 06:43 PM
MikeJ | 8 | 78 |
| | | Is there a way I can set up a SQL script to run when the instance
starts up?
SQL Server 2005 SP2
thanks!
traceable1
|
10-18-2007 05:26 PM
traceable1 | 3 | 59 |
| | | i have a question about indexes
if i create a index on 3 columns
int int int
id1 id2 id3
does SqlServer build the index from left to right based...
MikeJ
|
10-18-2007 05:22 PM
Erland Sommarskog | 1 | 101 |
| | | I am starting a class on SQL Server, and my school wants me to build
db's either on campus or remotely at my home connecting to their SQL
Server...
jamesallen74@gmail.com
|
10-18-2007 03:16 PM
Hugo Kornelis | 1 | 53 |
| | | The company I work for was recently purchased by another company and I
am tasked with getting out old Access 97 Apps with a SQL back end
working on...
mike@mcarlson.net
|
10-18-2007 01:53 PM
mike@mcarlson.net | 0 | 74 |
| | | Yellowfin Release 3.3 Announcement
Yellowfin is delighted to announce the content for our upcoming
release 3.3. Scheduled for release end of...
YellowFin Announcements
|
10-18-2007 08:33 AM
YellowFin Announcements | 0 | 51 |
| | | Hi,
I need help from you...
I want to find SQL Servers which are available in Network and
Databases in Each Server Using Batch file. If i run this...
raghutumma@gmail.com
|
10-18-2007 02:15 AM
raghutumma@gmail.com | 0 | 62 |
| | | hello guys, need help, i;m a bit confused about transactions after
reading some articles about locking/snapshot
let's stay i have this...
Nick Chan
|
10-17-2007 09:30 PM
Nick Chan | 2 | 82 |
| | | Hi,
I have a few questions about sql 2005 as follows:
1. Which MS SQL version (edtion) is good as database to
support a midium size web size?
2. I...
aaabbb16@hotmail.com
|
10-17-2007 08:12 PM
aaabbb16@hotmail.com | 2 | 68 |
| | | This morning I got the following error from a DTS package which had
been running happily for months (we're running SQL Server 2005...
jshunter@waikato.ac.nz
|
10-17-2007 06:20 PM
jshunter@waikato.ac.nz | 0 | 63 |
| | | I have a primary key (column name is emp_id) in employee table. Also,
I would like to make a combination of other two columns is unique.
(combination...
TGEAR
|
10-17-2007 05:47 PM
Ed Murphy | 2 | 57 |
| | | What's the best book to buy for learning MS-SQL Server for a database
programmer. I'll tell you my goals. I want a book that covers:
1) the theory...
Mukesh_Singh_Nick@yahoo.com
|
10-17-2007 05:29 PM
Hugo Kornelis | 3 | 65 |
| | | We have this basic SELECT statement:
SELECT product_id, we_date, sum(demand_units)
FROM weekly_transactions
WHERE demand_units > 0
GROUP BY...
imani_technology_spam@yahoo.com
|
10-17-2007 03:47 PM
imani_technology_spam@yahoo.com | 0 | 60 |
| | | Hi all, I have a problem with sqlserver 2000 and large data management.
I have a database with a large tables.
Every table has a continuative input...
Enorme Vigenti
|
10-17-2007 03:21 AM
Enorme Vigenti | 2 | 53 |
| | | How change every first character string as Upper Case transact sql ?
example
-------
tom and jerry
jerry and tom
result upper
=========
Tom And...
info
|
10-16-2007 05:21 PM
Erland Sommarskog | 1 | 65 |
| | | Hi Folks,
I come from an Informix background, (pauses for the laughter to die
down), where SQL can access a hidden attribute, (ROWID), that...
Tim
|
10-16-2007 05:20 PM
David Portas | 4 | 74 |
| | | Is it possible to load an RSS feed into a SQL db? If so, can you
please point me in the right direction? If not, please tell me why.
Thank you!
- tim
Big Moxy
|
10-16-2007 01:52 PM
Martijn Tonies | 1 | 62 |
| | | Hello,
I'm an absolute newbie when it comes to SQL. I was told that SQL
server does not function well on a WAN where network latency between,
say,...
jeff80@gmail.com
|
10-16-2007 04:00 AM
Tony Rogerson | 2 | 60 |
| | | A few service stop/start/restart questions on SQL Server 2005 SP2, which
I'll call SQLS.
It looks as if there are *potentially* 6 ways to start/stop...
aj
|
10-15-2007 06:05 PM
Erland Sommarskog | 1 | 51 |
| | | Hi.
I was wondering if anybody could piont me to a reference for the .bak
file format.
I need to upload a huge amount of data from a unix machine...
jims
|
10-15-2007 05:56 PM
Erland Sommarskog | 3 | 54 |
| | | We have a quick query regarding SQL performance.
We have SQL Server 2000 (32 Bit) and SQL Server 2005 (64 Bit) as two
separate instances on a DB...
pramodbura
|
10-15-2007 05:48 PM
Erland Sommarskog | 3 | 43 |
| | | Dear Group
I'd be grateful if you can provide me with a hint for the following:
Fields Table Contact
ContactID
Firstname
Lastname
Fields Table...
theintrepidfox
|
10-15-2007 05:40 PM
Erland Sommarskog | 6 | 60 |
| | | i have a table with 6 million row
what is the affect of increasing a varchar(255) column
to varchar(500)
tia
MJ
MikeJ
|
10-15-2007 04:53 PM
Gert-Jan Strik | 1 | 54 |
| | | I am working on a databse on my local box, my source data is on
another. How can I link the database and table from one server to
another? Currently...
rzito@si.rr.com
|
10-14-2007 11:21 PM
rzito@si.rr.com | 2 | 58 |
| | | Hi folks, I would just like to share with you SQL CodeSecure, a newly
released database protection and auditing tool from SqlLabs:
SQL CodeSecure...
dba@sql-labs.com
|
10-14-2007 02:55 PM
dba@sql-labs.com | 0 | 68 |
| | | Jobs in HCL-Noida/Gurgaon/Chennai/Bangalore/Mumbai
1. Citrix Admins - Noida - Chennai
2. Sun Solaris Admins - Noida - Chennai - Mumbai
3. HP Unix...
dbaguru
|
10-14-2007 12:19 AM
dbaguru | 0 | 46 |
| | | We recently upgraded our MS SQL Server 2000 to 2005.
Here is what we did:
1. Perform backup of the database from the old server.
2. Created a blank...
Ben
|
10-13-2007 11:30 PM
Ed Murphy | 5 | 59 |
| | | Hi,
SQL env: sql server 2000
Target column of insertion: varchar(15)
Case, a var is made up of a character of the following characters
(random...
tatata9999@gmail.com
|
10-13-2007 02:05 PM
tatata9999@gmail.com | 7 | 68 |
| | | I was looking to improve the performance of an ASP.NET application by
creating the an indexed view that could be used instead of some of the
root...
Jason Wilson
|
10-13-2007 11:18 AM
Erland Sommarskog | 1 | 45 |
| | | How to get a record value instead of aggregated value with GROUP BY?
Assume that I have a PRODUCT_COMMENT table defined as below. It logs
the...
blackpuppy
|
10-12-2007 05:21 PM
Erland Sommarskog | 2 | 46 |
| | | Hi,
I have a large table with a 'datetime' column that has date and time
values in it. The data is in this format:
2007-10-02 09:54:00.000
The...
jdrake@living-dead.net
|
10-12-2007 02:09 PM
aj | 3 | 39 |
| | | Hi,
How can we execute SQL Scripts using Batch file???
i think Batch file should contain Username,Password,Database and
Scripts...
Using that file...
raghutumma@gmail.com
|
10-12-2007 07:31 AM
Dan Guzman | 2 | 60 |
| | | Hi at all,
I'm trying to bulk insert a uniqueidentifier column from unicode file.
In my file I have guid generated from c# application and they...
bob.speaking@gmail.com
|
10-11-2007 05:37 PM
Erland Sommarskog | 3 | 40 |
| | | A few collation questions on SQL Server 2005 SP2, which I'll call SQLS.
The default collation for SQLS is apparently...
aj
|
10-11-2007 05:16 PM
Erland Sommarskog | 3 | 44 |
| | | I'm running a PHP call to MS SQL to automatically look in sysbojects
and syscolumns to get each table name in realtime so I can make a list
and...
Eddie
|
10-11-2007 02:59 PM
MC | 1 | 38 |
| | | This e-book contains over 1,100 pages of information that establish a
new paradigm for the integrated Enterprise Data Architecture. It is...
Parker
|
10-11-2007 07:24 AM
Parker | 0 | 44 |
| | | Hello!
I have a problem, and I looking for help if someone can handle this.
I use asp.net 2.0, and I create web site which support users from...
Zeljko Bilandzija
|
10-10-2007 05:56 PM
Erland Sommarskog | 1 | 43 |
| | | Good day!
Currently I am using MS SQL Server 2000.
I wish to delete all data in the database table except data in login
table and security table....
hunkgym
|
10-10-2007 05:48 PM
Erland Sommarskog | 1 | 42 |
