Currently we use jtds for connecting to our SQL Server databases. I've always taken it for granted that we use it due to performance and reliability reasons, however, it's usage pre-dates my employment. All of that being said, we are now playing with the idea of moving to SQL Server 2008, which jtds has limited support for. Initial tes...
I currently have a SQL Server 2005 instance installed on my local machine, and at the time of installation I named the instance 'localhost\sql05' Can I easily change this to just 'localhost' ...
I am working on a business app (asp.net). Right now I am using sql server. But I plan to support at least mysql and postgresql down the road. What are the issues that I should consider to avoid future headaches? Especially about datatypes (column types). E.g. I think BIT column is not supported on some dbs so I use tinyint? I mostly u...
Looking for performance vs. ease of use comparisons between the two Hopefully some real world examples too ? This is for a desktop Winforms/C# app using SQL Server Compact 3.5 and .net 2.0 ...
Is there anyway of getting the creation date of an entry in an SQL Server table? The reason I want to know the creation time of an entry is for debugging purposes. ...
Can I read a tracefile on 2000 SQL server using fn_trace_gettable without having to stop the trace? ...
I understand it that we have to map this type as binary to get to it in the application code. But why isn't there an exact equivalent with all those type methods? How are we supposed to work with in the code? Or we aren't supposed to work with it outside SQL environment at all? EDIT: The question extends to the geography and geometry t...
Over the years I have seen many approaches to this: Packaging a detached database file Packaging a backup, which is restored at installation time Creating the database from scratch using scripts In my opinion, the 3rd option, creating a new database from scratch, building the data structure from scripts and populating any static data...
We are dealing with an application that needs to handle global time data from different time zones and daylight savings time settings. The idea is to store everything in UTC format internally and only convert back and forth for the localized user interfaces. Does the SQL Server offer any mechanisms for dealing with the translations given...
The procedure will return from a table where name's width is set to 255. So is there any advantage in using @Name nvarchar(255) over @Name nvarchar(Max) ...
I have to write an console application to import log files daily to database. The log files and the database are on different servers. And then an web application will search through this database. I'm considering that should I migrate importing application to this web app or I config this app as a job in SQL Server. (as mentioned earl...
I see from BOL that you can apply permissions to a T-SQL synonym, but in playing around with synonyms I'm not clear when you would need to do that if you have already GRANTed permissions to the base object. eg. If I have a synonym in database A that points to a table FRED in database B, then it appears that as long as user Joe is grante...
I've added a new column, packageNo, to my table: create table Packages( id varchar(20) primary key, -- ok, I know :) orderNo uniqueIdentifier not null, orderlineNo int not null, packageNo int not null default(0) ) Now I want to generate the packageNo with the following rules: reset it for each order ascendantfor order, or...
I have a MS SQL Server with a linked MySQL server. I need to partially synchronize a table between the two servers. This is done in three steps and based on a condition: Delete all rows from the MySQL table that do not satisfy the condition Insert all new rows in the MySQL table that satisfy the condition Update all rows in the MySQL s...
We would like to include a facility in an ASP.NET web application that will allow a user to type in a natural language (or reasonably close to natural) question about a SQL data set (SQL Server) and get useful information in return. The sort of results required is to include min, max, std deviation, top 10, total for a column, and anythi...
This relates to computed columns and default constraints (and possibly other expressions) in SQL Server 2005 (or above). Both of these use an arbitrary expression to generate a value, e.g. (year+1) for a computed column representing "next year" (this is obviously a simple and stupid example). What I'm trying to do: I want to be able to ...
I get strings over an ODBC connection from a SQL Server 2005 which contain characters beginning with 'L\' followed by the character code. These characters are not displayable in Ruby/Rails but with other Applications which are using the same ODBC connection. I am using the ruby-odbc gem with utf-8. Umlaut characters are displayed correct...
I have been given a MS-SQL database to gleen some reports from. However on first inspection most of the data is stored in binary format. Is there a utility avalible that would allow me to peek at the data in the binary fields to give me some sort of idea as to it's contents. ...
Three little questions for the clever people of stackoverflow.... WINDOWS: max file name length in windows is 255 - why is this and why not 256? why is the maximum fully qualified filename (full path) stated as 32,767 when in reality it has to be a max of 255/260 to avoid any errors. SQL: when creating chars or varchars fields in ...
I'm not overly familiar with the SQL Server data dictionary, but I've assumed what I'm trying to do is possible. We have a number of replicated databases, under different names say: Client1 Client2 Client3 Rather than rely on a naming convention, I was hoping to identify these databases, based on whether they include a key table, call ...