Specifications say SQL CE runs as an “in-memory-process”. What does that really mean, and what is the difference of this compared to SQL Express? And does it matter if SQL Express is connected as attached or detached in that respect? I’m specially concerned with latency/lag, as my program is not typically User-activity based, but mainly […]
I want to agregate updates of my tables into a feed. Let´s take sample tables News, User->[Info-Update, Friendships, Images, Videos], SomeOtherTable On every update or insert an event is fired. Now there will be, for this different types, some handlers that should generate the feed. Problem 1: FeedTable, its columns, localized titles and text. My […]
How can I perform this MS SQL Query with Linq to SQL in C# SELECT DATEPART(yy, MAX (articleDate)) AS max_year, DATEPART(yy, MIN (articleDate)) AS min_year FROM News; Thanks
I’m using MSSQL2008. The date type is Date, and I would like to set the default date to now or today. I’ve tried GETDATE(), but I get “Error validating the default for column ‘Date’”. If I persist with GETDATE(), it doesn’t work.
I’m having a strange problem with SQL Server 2008, in which some datetime variables within stored procedures are getting incorrect values (1754-01-01). Here is the background/context of the situation: I’m working on an ASP.NET web application using the SqlMembershipProvider class. I use the out-of-box functionality for storing user data in the database, validating usernames/passwords, etc. […]
Let’s say I have a table that contains the following fields: UserId | FirstName | LastName I’d like to put together a search form with a single input for finding people by name. I’ve seen quite a few questions that touch upon this, but am looking for some guidance from someone that has implemented this […]
I’m getting a report of errors from a production system. I don’t have easy access to the production system. I will get all the data that I need for it in due course, but what I’m trying to do is expedite the process of resolution of this issue. I’m trying to eliminate as much guesswork […]
How can I determine who the current owner of SQL Server instance is by interrogating Failover Cluster Management Service using C#? This is on SQL Server 2008. I have the fail over cluster management service configured and I need a programmatic way to determine the current owner.
Is there any way that without installing SQL Server on a machine, a .NET application which inserts and updates data can run on the machine?
I want to display the XML file by taking tag from the XML_TAGS table, and attributes from theMAPPED_TAGS_ATTRIBUTES table – something like <element attributes></element>: String sql = “SELECT Dtd_Tag,Dtd_Attribute_Name FROM Xml_Tags, Mapped_Tags_Attributes WHERE Mapped_Tags_Attributes.Pdf_Tag = Xml_Tags.Pdf_Tag ORDER BY Mapped_Tags_Attributes.Pdf_Tag FOR XML AUTO”;