Hi folks, I'm creating a new DB and have a bunch of static data that won't change. If it does, it will be a manual process AND it will happen very rarely. This data is a mix of varchars and Geographies. I'm guessing it could be around 100K or so in total, over 4 or so tables. Questions Should I put these on a READ ONLY filegroup Ca...
Has anyone tried to use xml typed columns with Entity Framework ? The entity returns a string. Will the next version of Entity Framework support XElement types when the table column is of type XML. Regards. ...
What are some of the Hosting Providers out there that support SQL Server 2008 and ASP.NET 2.0/3.5? I am already aware of DiscountASP.NET (I host my blog with them), but I'm wondering if there are any other good hosting companies. GoDaddy hosting is good too, but they don't support SQL 2008 yet. Also, I'm open to finding Shared, Dedicat...
Hi, I have an application which receives GPS data from a mobile device as well as receiving co-ordinate data it also provides signal strength from the GSM network. I am trying to plot the points on a map to display areas of good signal strength and areas of poor signal strength. When I have a few points it all works well, the points are ...
We've got a regular (i.e. not extended) stored procedure in SQL Server 2000 that calls an external exe. That exe, in turn, loads a .dll that came from an SDK and calls some procedures from it (i.e. Init, DoStuff, Shutdown). The only reason we have this external exe thing is because we didn't want to create an extended stored procedure t...
I wonder if anyone know/have a good guide for Replication in MS SQL Server 2008? I want to set up a Replication between two different computers that run MS SQL Server 2008, the master runs on Windows Vista, and the slave will run on Windows XP. I´ve done this in earlier days, but between two MySQL-servers. ...
I have a user defined function defined in SQL Server. I want create a single select statement that would be able to execute the function on all rows in a particular column. Is this possible and what would be the best way to do it? Thank You I saw this 'Execute table-valued function on multiple rows' and dont believe it answers my que...
I recall that the import tool in sql server 2000 would copy indexes, relationships, etc. In sql server 2005/2008 the import tool in SSMS will only create the tables, copy the data, but the keys, indexes, relationships are missing. I can find no option in the import wizard to enable this? What am I missing here? Is this not possible anym...
I'm using SQL Server 2008. Say I create a temporary table like this one: create table #MyTempTable (col1 int,col2 varchar(10)) How can I retrieve the list of fields dynamically? I would like to see something like this: Fields: col1 col2 I was thinking of querying sys.columns but it doesn't seem to store any info about temporary ...
On my local Windows XP machine, I'm not able any more to create databases with FILESTREAM. This error is caused by one of these security updates from MS: KB952004 KB923561 KB961373 KB956572 KB959426 KB960863 Does anybody know how to resolve the problem WITHOUT removing the security updates? ...
Hey guys. I have a column of data containing a string with the following format: blablablabla(XYZ) and I would like to discard everything outside the () - and the parenthesis themselves - and to set update that field with the value inside the (). This implies that, in this particular case, the "blablabla" would be discarded and that ...
Is there anyway to optimize this horrible inefficient UDF in SQL Server 08. I am fairly new to UDF's and especially looking at them for optimizations. UPDATE: Should I be sending a column to a function like this if I wanted to perform it on each row and each column in a query? Is there a better way to go about this? Thank You ** @v...
Not sure what's happening with this, but here's my question. I have a Sql Server 2008 database that I need to be able to do full-text indexing/searching but when I try to setup my indices on the table, I get the following: I've tried running this stored procedure on my database and it's successful: EXEC sp_fulltext_database @action ...
We’re a team of SQL Servers database developers. Our clients are a mixed bag of C#/ASP.NET, C# and Java web services, Java/Unix services and some Excel. Our client developers only use stored procedures that we provide and we expect that (where sensible, of course) they treat them like web service methods. Some our client developers don...
I currently have a query that looks like this: SELECT NON EMPTY ([Measures].[TOTAL]) ON 0, NON EMPTY (([ENROLL DATE].[CALENDAR].[YEAR].[" + Parameters!EnrollDate.Value + "] * [DIM ENROLLMENT].[ENROLLMENT].[ENROLLMENT PROG].ALLMEMBERS)) ON 1 FROM (SELECT (([DIM ENROLLMENT].[ENROLLMENT].[TERMINATION REASON].[Still Enrolled])) ON 0...
Hello all I tried to set-up the SQL tables for ASP .net 2.0 membership provider by clicking on ASP.net Configuration under Project. I have completely uninstalled SQL 2005 Express and installed SQL 2008 Express instead. It seems like that it can not connect to the database. Does anybody know how to get this fixed so I can use 2008 in...
I am developing a website for educational domain. I want to store a document (MS Word or text file) in database in binary format using Filestream in SQL Server 2008. but I am unable to retrieve the document in a textbox. My code is as follows: string path = reader.GetString(0); SqlFileStream stream1 = new SqlFileStream(path, (byte[])r...
I'm using SQL Server 2008 and I would like to use a sproc to tell the database to populate a full-text index. If available, I'd like to know what the sprocs are for the following actions: adding an entry into the index removing an entry into the index full populate ...
It seems that ß=ss in SQL. I need to be able to distinguish on a strict charcter equivalent basis. i.e. select * from table where name like '%ß%' yields Brian Bruß Steven Sossmix etc.. I've looked at different Collations to see if there is one that ignores character expansions, but no luck so far. Database has Latin1_General_CI_AS as...
A fairly comprehensive query of the brain has turned up a thousand and one ways to pass variable length parameter lists that involve such methods as: CLR based methods for parsing strings to lists of integers Table valued functions that require the presence of a 'Numbers' table (wtf?) Passing the data as XML Our requirements are to p...