i have an ms-access backend i have a bunch of users connecting to the back end with their own personal front ends i am changing the backend to sql server, and do not want to re-distribute front ends. is it possible for me to just set it up so that the ms-access backend points to the sql-server? please note that all i need is just one ...
I know this is very subjective, But I would like to know expert opinions about : Pros and Cons for both? the server language is C#. ...
So far, I'm not getting meaningful results from my full-text queries so I decided to give a simple example of what I am trying to do and the results I expect. I've made the the following test table (tblCars) with full-text enabled for the column [Car] and primary key [CarID]. CarID Car ----- ----------------- 9 BMW 330Ci 2009 14 ...
Hi, I'm trying to optimize a SQL Server. I have some experience with Mysql and one of the things that usually help is to enable query cache, that will basically cache query results as long as you are running the same query. Is there something similar to this on SQL Server? Could you please point what is the name of this feature? Thank...
Hi folks, We have a simple Table per Type Entity Framework 4.0 model :- ALl classes are all POCO's. Post class is abstract. Discussion and List are classes are concretes, that inherit's from Posts (as shown in the diagram). When we try to save a Discussion, we do the following code :- Posts.AddObject(discussion); And the Sql Ser...
Someone on our data team added a database constraint and, while it's perfectly valid and desirable, it creates great problems for NHibernate because there doesn't seem to be a way to override NHibernate's save order. Given a (silly example) class like this: public Person { public virtual string FirstName { get; set; } public vi...
In the past I've noted terrible performance when querying a varbinary(max) column. Understandable, but it also seems to happen when checking if it's null or not, and I was hoping the engine would instead take some shortcuts. select top 100 * from Files where Content is null I would suspect that it's slow because it's Needing to pul...
I'm trying to insert multiple rows using SqlCommand from C# to SQL Server. I'm forming a simple query as below: Insert into temp(field1, field2) values (1, 'test'), (2, 'test1'), (3, 'test2') and so on till 100 rows. For the example purpose I only gave couple of fields here but it actually contains 25 fields and 20 out of this are strin...
What are the options for scalability with SQL Server 2008? Or does it even have options to design for scalability? ...
Hi All, I am in a very big trouble. Please help!!!!!!!!!! My website has been attacked by some malicious script < / title> < script src = http : // google-stats50.info/ur.php >. This script is appended to any column(s) of some table automatically. I have removed this script. But after a few hours, it re-appeared in some tables. But thi...
Hi all i want to take record from table named Tblbatch where batch starting date should be from augest 2007 to july 2010... I want to fetch such records which came in between this two dates ...
ALTER PROCEDURE GetSingersGenere (@SingerData ntext) AS BEGIN DECLARE @hDoc int exec sp_xml_preparedocument @hDoc OUTPUT,@SingerData IF OBject_id('SingerTable') IS NOT NULL BEGIN DROP TABLE SingerTable END CREATE TABLE SingerTable ( SingerName varchar(200) ) INSERT INTO SingerTab...
Does anyone have an idea for "word wrap" or something functionally similar in SQL Server 2008 Management Studio's query editor? thx ...
I have one database that has a bigger size than expected, how can I query it to retrieve the fields that take more space. let's say I have 2 only tables Table1.FieldOne Table1.FieldTwo Table2.FieldOne Table2.FieldTwo Let's say 99.9% of DB data is in Table2.FieldTwo, how do I query the db? Of course I have many many tables. The db i...
Hi Im trying to write a query that will tell me how much time a restore (full or log) has taken on SQL server 2008. I can run this query to find out how much time the backup took: select database_name, [uncompressed_size] = backup_size/1024/1024, [compressed_size] = compressed_backup_size/1024/1024, backup_s...
Hello, is there an easy way to get a list of all columns of a SQL query? They are listed in the header of the results window of SSMS but I can't copy them. Thanks in advance. EDIT: sorry, I found it myself after a little googling: http://vidmar.net/weblog/archive/2008/06/05/save-sql-query-results-with-column-names-in-msssms.aspx ...
I am surprised to see that IS NULL and =NULL are yielding different results in a select query. What is difference between them? When to use what. I would be glad if you can explain me in detail. ...
I have a SQL Server 2000 connection string that I need to work with SQL Server 2008. I am using a DSN and it works just fine, but when I try to connect from the web page, the page never loads and I have to restart my IIS to get the web page to load again. this is my SQL Server 2000 string: MM_RFI_Datasource_STRING = "DSN=RFI_Datasour...
I have created a database in SQL Server 2008 and I have assigned a job to it which get backup from my database once a day. Now I want to attach my database to SQL Server in another system. Should I create the job again on the second server or it has been transferred with mdf file itself? ...
I have a SQL table called StudentMarks.which consist of StudentID,SubjectName,SubjectMark I want to write a stored procedure to retrieve StudentID,TotalSubjectMarks,MarksAverage,ClassPosition for each student.I need to find the ClassPosition from the MarksAverage. for the student who has the highest MarksAverage, ClassPosition should b...