all groups > sql server misc > november 2003
Convert mysql integer to SQL server datetime
Posted by Ste at 11/27/2003 12:10:20 PM
Hi,
I have a mysql dump with a table with this field:
"hdstart" integer
which contains integer like 1042758000 1028152800 etc etc
How can I convert it to a SQL Server DateTime field?
Thank in advance and sorry for my bad english...
Ste
... more >>
SQL query help
Posted by philh69 NO[at]SPAM hotmail.com at 11/21/2003 2:05:51 PM
Please bear with me, I'm no expert at all (newbie to the bone on SQL)
and this has been something of a problem for me for a bit, and I'm
hoping someone can help with this.
What we have is a SQL table (Item) that has had computer hardware
inventory dumped into it via a program called AIDA32, th... more >>
are to many records going to be a problem ?
Posted by Rudy Truyens at 11/21/2003 7:45:14 AM
We have a web application that supports multiple clients. Some clients will
have (not yet) about 10^9 records in a certain table, others 10^6. The idea
is to make a seperate database for each client, so the small client won't
suffer performance wise because the big client is accessing the databas... more >>
MSDE deployment/config problem please help
Posted by Mike at 11/12/2003 9:40:44 AM
We have a problem distributing the MSDE engine and getting set up to
configure the way we want it
First batch file should start the set up and set security mode and the SA
password. It sets the security mode to both as expected but does not change
the SA password
First.bat
setup SECURITYMO... more >>
SP - concurrent SPs, performance, running at below normal priority
Posted by adeveloper at 11/10/2003 2:48:02 PM
Hi,
We have an application which is heavily SQL Server based and which should
support multiple concurrent users who can add, edit and delete content. We
are finding that all our SPs use 100% CPU and seem to run at normal priority
on the server, so if 2 users try to perform an operation at the... more >>
encrypting stored sql server data
Posted by Steve Cramer at 11/7/2003 2:24:40 PM
We have a sql server database that serves a departmental client server
application. The database contains confidential information and I would
like to encrypt the stored data. Has anyone done this? If so, do you
recommend a particular product? The ones I am aware of are DBEncrypt , SQL
Encr... more >>
|