all groups > sql server misc > may 2007
Disk and RAM requirements of Views
Posted by JT at 5/29/2007 2:39:33 PM
Hi,
I don't know if these are stupid questions or not.
1. Does a view require any disk space in the database? Is it stored?
2. If not, does a view have an impact on RAM usage, either on the
server, or on the client's machine (if running Management Studio)?
3. If RAM is significantly affect... more >>
Poetry?
Posted by mjswart NO[at]SPAM gmail.com at 5/24/2007 6:29:21 AM
Probably one of the geekiest things I've ever done.
Take a list of SQL Server keywords. Stick the words in a database
table along with it's meter and rhyme. Get SQL Server to cross join
this table to itself concatenate meter and output candidate lines of
poetry. Select and arrange according to... more >>
Import Tables from Access
Posted by Phil at 5/17/2007 12:00:00 AM
Hello,
I'm fairly new to SQL Server. I have a database already in MS Access, and
want to import the structure (just the tables, not the data) into SQL
Express (there are no stored queries, macros, etc... to worry about). What's
the easiest way to do this?
Thanks
Phil.
... more >>
database rights
Posted by Tester at 5/8/2007 1:53:50 PM
Hi there,
I am using SQL 2000 and a database with tables. Somehow only database
owner has permissions to it, select/read etc.although the other
database users have public privileges.
How can I give access to more users to select, insert, etc?
Thanks a lot, T
... more >>
How to tell what SQL 2005 version I'm runing?
Posted by Clayton Sutton at 5/7/2007 8:59:18 PM
Hey everyone,
We have a server that is running SQL 2005 but we don't know if it's full SQL
2005 or SQL 2005 Express. Can someone tell me how I can find out?
We DON'T have SQL Server Mangement Studio installed.
--
TIA,
Clayton
P.S.: I wrote an iTunes podcast tutorial and ju... more >>
|