| Thread | Last Post | Replies |
|
| Trouble with back up | 31 Mar 2009 19:49 GMT | 1 |
I am using SQL Server 2005 (developer) I created a blank database and restored a 2005 database srome the management studio After mussingaround for a bit I decided to role back and do the restore
|
| Importing excel spreadsheet | 31 Mar 2009 18:07 GMT | 1 |
I'm using SQL Server 2005 sp3 I receive an Excel spreadsheet from Cognos software. I can open it fine in Excel 2003 SP3;however, when I attempt to import it using the import wizard, I get an error which says "External table is not in
|
| How to create a histogram? | 31 Mar 2009 12:07 GMT | 3 |
I have a set of measurements and i'd like to present them as a "histogram". After a few hours of trying and googling, i've given up. How does one do it?
|
| How to count occurences of a post? | 31 Mar 2009 12:05 GMT | 3 |
I have a table with names of places visited. Most of the places are visited several times. Some of the places available for visit are not visited at all. I can't tell how many different places are visited.
|
| ODBC drivers for ms sql 2008 | 30 Mar 2009 22:30 GMT | 3 |
Looking to find an install program for the ODBC driver for ms sql 2008. Somehow I am going in circles in ms web site. I need to run a test in Windows XP. I appreciate the right link for that.
|
| Unable to connect to the SQL Server 2008 Express with visual Studio 2008 Express | 30 Mar 2009 20:32 GMT | 2 |
As the subject says, I am running VS2008Exp (the ASP.net component particularly) and am unable to connect to the SQL Server 2008 Express that is runing directly on the same machine. This is a fresh clean install of the whole entire machine,..the OS, SQL2008Express, and ...
|
| Best way to index 16 million time/location rows for searching? | 30 Mar 2009 18:50 GMT | 6 |
I have only recently started using MS SQL server having made some fairly complicated databases in MS Access but nothing with nearly as much data as i am dealing with at the moment. I have been learning about indexing schemes as I need to speed up access as much as possible. The ...
|
| Database Size grow rapidly | 30 Mar 2009 07:02 GMT | 3 |
Dear Professional, Just want to ask one question. Three months a ago one of my database size was 5 GB and now it's 12 GB but I didn't see much data from last three months, is there anyway I can findout,
|
| I am a Novice just learning SQL | 29 Mar 2009 12:51 GMT | 1 |
I am a novice just learning by self teaching. i created a table, but could not input data into the table. I am so frustrated. Can anyone help me with what could be the problems? I need an online or phone tutor to help get into the swing of events. Thank you all.
|
| Computing consecutive differances | 27 Mar 2009 23:03 GMT | 8 |
I have a table with accumulated values and a date. It looks like this: SELECT Occasion, Distance FROM Records; Occasion Distance
|
| SQL 2000 Agent running but not working Error 14258 on job access | 27 Mar 2009 14:51 GMT | 1 |
We have MS SQL Server 2000 running on a cluster. The SQL Agent shows as running but no jobs are being ran as scheduled as of this past weekend. Stopping and restarting the agent via Service Manager did not fix the
|
| Select Highest Values Within Each Group? | 26 Mar 2009 18:20 GMT | 1 |
I have a table with non-unique things in one coilumn, and a version number for those things in another column. I am trying to SELECT the latest version of those things. For Example: vchThing iVersion
|
| Neat way of sending data as an XML | 26 Mar 2009 16:23 GMT | 3 |
The way i've set up my connection, i use data adapter to fill(...) the data set. Then, i use a parser, written by me, to create an xml of that data. Finally, i send it back. I wonder if there's some neat way to send XML right
|
| inexplicable record deletion | 26 Mar 2009 02:41 GMT | 5 |
i have a strange situation. records in one of tables in my database have inexplicably deleted. only a few person know the access key to do the deletion and they don't do that. in addition to that, the table's primary key definition has also
|
| In memory DB (MS-SQL vs MySQL) | 25 Mar 2009 21:59 GMT | 6 |
I normally work with MS-SQL (inc clustering, mirroring and replicated systems) but I've been tasked with looking at MySQL Cluster so that we can implement a very fast real time online search system. I can't give too many specifics, but it's for a very large web based solution. It's
|