|
u r a genrus fellw *smack*
Sorry
A genuinely helpful answer, have well... Helpful
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
|
|
Although you have managed to cover the most important bit up, I suspect you are trying to log in with sql server authentication, not windows.
Otherwise, the message is pretty clear - it tells you what the problem is.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Hi,
I am using SQL 2005 and VS2008. What I want to do is that I want to Insert, Update and Delete data from database using DataGridView. How can I do this? Please Help.
|
|
|
|
|
|
Hey guys, I'm planning to start working on a software which requires a huge database, this database has pictures, text files, PDF files, mp3 files and probably movies files, it would also have information to which these files are related to ! so saving all of them in SQL would be too space consuming, so how would you design such database if u were me ! would u programatically save the huge files on the hard drive of the client or would u save them all in SQL ?
Thanx in advance
Mr.K
|
|
|
|
|
This would depend on several different factors. Have a look at SQL Server 2008 and especially:
- Compressed Storage of Tables and Indexes
- FILESTREAM Storage
- Table partitioning
The need to optimize rises from a bad design
|
|
|
|
|
you will find it harder to store images and video, for that download samples here about "store images in sql database".
Were would you save data? that you have to decide.
In client as a stand alone always works fine, but i dont know if you are thinking about a network.
nelsonpaixao@yahoo.com.br
trying to help & get help
|
|
|
|
|
i know ! I was thinking of having a database online for updates ! but it needs a lot of space and fast connection ! for now It on the clients computer and is mostly single user ! how would u store huge files ? would u store them in SQL SERVER or on the hard drive ?
|
|
|
|
|
if it´s big and you can effort it, better to do a stand alone.
You mean the images, right? you can store them in the database, (dont store a string with the link to it), theres good code samples here like i said before.
So, store in sql it works fine for me.
search: store images in sql
nelsonpaixao@yahoo.com.br
trying to help & get help
|
|
|
|
|
even large audio or video files ? how about them ?
Mr.K
|
|
|
|
|
i think so, how would youtube or those peer-to-peer(p2p) have so many?!
i have no degree in programming but, dont you agree with me???
What i also think is that you have to make a stand alone, because you are emphasing on big big big files you know, that´s expensive to rent a server for.
Maybe create your own server, or a network of many client (p2p) to swap data, that way you wont pay anything, just power bill and telecomunications bill.
nelsonpaixao@yahoo.com.br
trying to help & get help
|
|
|
|
|
If it is just storage then it is fairly straight forward, just add hard drives. You may want to store the different types of MM data into different tables linked to the owner (ie have an owner table with a vid attribute table anda PDF attribute table etc)
You could also store the MM in the file system and only the links in the database.
If you are doing processing on the data and it is seriously large (100gb+ without MM) I would look into Oracle.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hi
I have designed a large system for storing files, any kind of files
The best way in my opinion is to store files on the hard disk and keep filenames or paths in the DB.
Another note will be useful to you: Don't put all files in one folder direcly. This would result in slow serching on a specific file. Rather, you can specify a max file count for each subfolder, say 2000 files. So, if a subfolder reached the 2000-files limit, create a new subfolder and set it the current one.
In DB, you can create a table for [SubFolder] contains the fullpath of each subfolder and the table [File] contains a colunm for filename and a column for a foregin key to the parent subfolder.
Mostafa Noor
Egypt
|
|
|
|
|
Thanx man ! I ve decided to apply the same method ! I have made up my mind about movies and mp3 files, but for PDF/TEXT/Image files it would be possible to store them in database or u suggest storing them all on hard drive ?
Mr.K
|
|
|
|
|
I want to use the system view sys.database_role_members to show what users are in what particular roles. Sys.database_role_members has exactly what I need (the role_principal_id and the member_principal_id) but I want to see them as user or group names, not ID numbers. The view sys.database_principals shows the name and the ID, so I know I can use that as a look-up, but I don't know how to properly join the two.
It seems like it must be pretty simple, but I'm new and I'm just not seeing it. Any help would be appreciated.
Thanks.
|
|
|
|
|
This should get you started: Using Joins[^]. In your case concentrate on inner join if you want only matching pairs.
The need to optimize rises from a bad design
|
|
|
|
|
I can do a basic join but here's what I am having a hard time with:
sys.database_role_members is something like this--
role_principal_id --------------- member_principal_id
5555 ------------------------------ 1
5555 ------------------------------ 2
6666 ------------------------------ 1
6666 ------------------------------ 2
But I want both columns to have names to identify them.
role_principal_id --------------- member_principal_id
data_entry ----------------------- janedoe
data_entry ----------------------- joeschmoe
data_guest ----------------------- janedoe
data_guest ----------------------- joeschmoe
Those names can all be found in one column of sys.database_principals. And I don't think I get how to connect both columns of sys.database_principals to one column of sys.database_principals.
|
|
|
|
|
Ok, I see. Could you post what kind of SQL statement have you made so far?
The basic idea is that you would have the sys.database_principals twice with different aliases (actually this is the same tecnique I used in my previous reply to you). One alias is for role and it's name and the other is for the role member and it's name.
The need to optimize rises from a bad design
|
|
|
|
|
Aha. I needed to use aliases.
I've got it. Thank you!
|
|
|
|
|
No problem
The need to optimize rises from a bad design
|
|
|
|
|
Hi,
Does anyone know if i can change SQL server settings using a script or query?
I should set "minimum memory used" to 512MB and "SQL boost" to true using a script.
thx
kurt
|
|
|
|
|
|
Okay, thx..
just what i was looking for....
greetz
Kurt
|
|
|
|